Subreports (1 Viewer)

[jonp]

I have two queries that generate data from one table. One query sums a field based on a date range entered in the DATE OF RECEIPT field. The second query sums another field based again on a date range entered in a field called CHARGE OFF DATE.

Here's the deal...I need a report with a subreport, but the queries do not contain fields that can be linked by MASTER and CHILDS. I have tried setting this linkage to none but this setting causes the system to go in loops asking for the date range over and over. What am I doing wrong?

Thanks in advance!!!

 

[llkhoutx]

Create some kind of relationship and link on it.

 

[jonp]

The only relationship I can build off of is the date. But the dates are WHERE criteria in the query.

Any suggestions?