Thanks for the reply Chuck. >Does it crash immediately? If not perhaps there is an index problem. It doesn’t crash. It just doesn’t generate the report. I dropped and rebuilt indexes. Also tried totally different data files.
>What happens with only one record on the report? Also what 4D >version, and O/S combination are you running in? This is under Windows 10, 4D 17.3hf2. I will try it in v18. Tom > On Feb 25, 2020, at 11:49, Charles Miller via 4D_Tech <[email protected]> > wrote: > > Does it crash immediately? If not perhaps there is an index problem. > What happens with only one record on the report? Also what 4D > version, and O/S combination are you running in? > > Regards > > Chuck > > On Tue, Feb 25, 2020 at 1:20 PM Tom Benedict via 4D_Tech > <[email protected]> wrote: >> >> It’s been many years since I’ve done much with Quick Reports, but now a >> customer has reported that a specific Quick Report template that they use is >> no longer working. The “Print Preview” and “Print” icons in the QR Toolbar >> are enabled, but clicking on them does “nothing” (no report is generated). >> Only if the two columns which reference fields in one of the related tables >> are removed will the report generate. There are other columns which >> reference related fields in other tables, and they work fine, but using >> fields from this one related table stops report generation. >> >> I’ve tried rebuilding the report from scratch, but once I add a column from >> the troublesome table, the report stops generating. I’ve confirmed that the >> tables are related (actually deleted and recreated the relation) and I’ve >> tried adding a calculated column which holds a query to relate the tables. >> And I tried rebuilding using the QR Wizard. I’ve also tried it on different >> data files. >> >> The customer reports that this QR template worked until we gave them a new >> structure file. Unfortunately we don’t have the source code for their prior >> build, so I can’t compare structures, but I don’t see any evidence of recent >> schema changes which may have introduced this behavior. >> >> Is there something obvious I’ve overlooked? >> >> Thanks, >> >> Tom Benedict ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
