Joining 3 reports and getting the summary of each on one report

[infinitizon]

Hi all

I posted this earlier but did not really get help. I'm reposting to see if someone will be reading it this time.

I have a report called GenSetSalesReport that gives a report of gen sets sold by the company and the cost of each. It has a field that shows the amount of sales (by customer) and at the buttom we sum all the sales made (to get the summary). It talks to a procedure on a sqlserver 2008 database.

I have another report showing the spare parts sold. It also has a field that shows the amount of sales (by customer) and at the buttom we sum all the sales made (to get the summary). It also talks to a procedure on the sqlserver 2008 database.

Finally, I have a report showing the Work In Progress which also talks to a procedure in the sqlserver 2008 database.

Remember that each of them has a total for the sales at the bottom.

So a manager wants to be able to see the total for the sales of each report. Therefore, I want to create a new report to show this totals which when I click on each, it drills down on the report.

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.

 

[lbass]

I lost track of that thread--You should have just bumped it, instead of starting a new thread on the same topic.

I think subreports are the best option, and on-demand subreports would give you the functionality you want if you can bring all three procedutes into the container report and link them together. There is probably a reason you didn't do this--it will likely force duplication of amounts, but if you can do this, you can create running totals that return the correct amounts and then use totext versions of these as the captions for the ono-demand subreports which would be duplicate free. Then one click on a text version of the total that acts as a link to the sub would show the detail.

-LB