Reports with Groupings

P

Pedro

Hi everyone
I have a report based on several crosstab qry and that report gives me the
data i want from every sales office. Now i want a total. Just a page with all
totals. Do i have to rebuild all my crosstab qry, or it's simply change
something on my report? I've tried to delete my group level and it didn't
work. My report has like 220 fields. Can't support not much more and i need
the same number of fields, that's why i'll do another (copy-paste).
Hope i was clear enough so you can help me.
Tks in advance
Pedro
 
D

Duane Hookom

If you want to display all the details from the crosstab and then a summary
at the end of the report of all group totals, you may need to use a subreport
of the summary in the report footer section. This would require another query
or the same query but not displaying the details.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping a Report made with a cross tab qry 11
Reports with dates 2
weird sum on report 2
Create a balance on every line of a report 16
Default value = 0 3
Subtract on a report based on QRY cross table 14
Acumulative value 1
IIF function in Report Footer 5

Top