Using multiple datasets in SSRS 2005
Posted on 2011-03-01
I'm trying to get a report to work with multiple datasets. The datasets do not have a direct tie to each other and come from different databases. But the totals from one dataset need to be used in a subsequent dataset. One dataset with goals, a second dataset has gifts and 3rd dataset has income and expenses. I need to take X % of the gift dataset and add it into the income and expense dataset. Then I need to get a grand total and determine the % of goal using the first dataset. Once I start adding different datasets and data regions the report only runs if I use first or sum on each of the fields. Some of these can't be summed - the goals for example have to be listed separately by FY. I'm not sure what I'm doing wrong. I know I can't use sub reports because I can't carry totals from them onto the other data regions. Any input?