Sub reports

[sanders720]

I have a report with quote data - which is grouped in three levels. The report works great.

I would like to pull in a sub report at the end of the report that uses different data. When I do this, the report does not pront any of the data. I do not want to print certain data based on otherf report data, I just want to have this information appear at the end of the other report as entirely separate data, but formatted on the same grid. What can I do to accomplish this?

Thankyou in advance for the help...

 

[mdthornton]

If the subreport is completely independent what happens if you open it on its own. Do you see data? Assuming you do try putting an arbitrary text label in the report header (not page) of the subreport. When you run the main report you should always see that text box. If you don't see it something is set wrong on the subreport properties. Check the obvious stuff like "visible" etc Best Regards,
Mike

 

[sanders720]

I do see the text box. What I do not see is the data. The report works great independently.

 

[mdthornton]

The only thing I can think of is if you inherited and/or cloned this from another report you may have some linkage set up. This is a long shot but check the link properties of the subreport.

ps what version are you using? Best Regards,
Mike

 

[sanders720]

Okay, it works... The only problem I'm having now is that the dlookup does not work. The syntax must be different when I am in a sub report vs a report. Any thoughts on this?

=DLookUp("[Customer]","[Customer]","[Customer ID] = '" & [Reports]![rptInquiryInfo]![CustomerID] & "' &quot

Thx,