Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   How to use many query in one report (http://www.go4expert.com/forums/query-report-t26183/)

dododo 30Jun2011 14:22

How to use many query in one report
I have many query and i wan to show a lot of query in one report. How can i do that? I designed report by my own and want to bound it with many query. Please tell me how to do it.

Please see the link of my report. Each rows and columns of my report need to bound with one query.


Webdeveloper 5Jul2011 17:05

Re: How to use many query in one report

Since there are fixed number of queries to be executed and the result shown in a particular order, so what you can do is you can first execute all the queries save the result in respective variables and then use the variables to show in the report matrix.



jaydeee 18Oct2012 19:36

Re: How to use many query in one report
I know this is and old thread but I just wanted to share what I am do in this scenario.

I simply create another query to combine all the queries I've made in one and use it as the recordsource in my report. that is one approach.

Anotherone is to have mini or subreports put all together in one main report.

My scenarios were mostly include total and subtotal that I wanted to put in one report so the first option is best for me. however if you're joining a datawindow, then subreport is your best option.

hope it helps.

Orion 19Oct2012 12:44

Re: How to use many query in one report
Increase the columns of your report. make it look attractive.. as i take a look at your report . it doesn't seems to be interesting.

All times are GMT +5.5. The time now is 11:03.