In one report want to show data from two different query. (1 Viewer)

[Sokkheng]

i want to make report that detail of invoice group by customer, and at the end of report (report footer) i want to get data from other query that show only the total summary of debt, payment and balance. mean in one report i want to show data from two different query. how can i do that?
thanks.

 

[isladogs]

Use a subreport for the second query

 

[Sokkheng]

In sub report it always have relationship with main report? for the two queries that i want to show data it doesn't have relationship to each other.

 

[The_Doc_Man]

Technically, it is not required that a sub-report has a relationship to the main report. But if the main report has a grouping, you would (as you suggest) have to put the sub-report in the report footer to prevent it from repeating (as it would in any other section).

 

[Sokkheng]

Technically, it is not required that a sub-report has a relationship to the main report. But if the main report has a grouping, you would (as you suggest) have to put the sub-report in the report footer to prevent it from repeating (as it would in any other section).

Thanks for your reply.