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

[infinitizon]

Hi all,

I have 3 reports already created, each report talking to a different view in the sql server2008 database.

Now I am supposed to create a single report that show the running total of each report such that when you drill down, it takes you to the individual report.

This looks preety complex for me and I dont even know how to begin.

Any Ideas? Thanks in advance

 

[lbass]

You could add each report as an on-demand subreport, so that you could click on each to get detail, but I'm not following what you mean by the "running total of each report". Can you provide a sample layout and explain more?

-LB

 

[infinitizon]

Ok, thanks LBass,
Here it is:

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.