Hello!
I have a Paginated Report that I need to do something specific. Some details...
I have 11 separate Datasets that all provide a piece of the final document. Each dataset corresponds to one table. The datasets are from the same datasource but they are not linked together in any star model or anything like that. They stand alone.
The main dataset gives me two parameters, a "Team" dropdown and an "Employee" dropdown. Select the team, get only the employees for said team. Easy peasy, works great. Based on the employee selection, I filter the other datasets for that employee number and if there is data in that dataset, it adds it, else that associated table gets turned invisible. And voila, my report.
Now, I have a working document, however, I need to be able to "Select All" on the employee list and have all the reports generate for each employee, doc after doc, in addition to just picking one report. As it stands now, the name in the header just shows the first name in the list and all of these employees data is just throw together in one report. In the words of Cleveland Brown from Family Guy, "That's nasty".
I need to be able to have each employees report generated one after another. So report emp 1, then report emp 2, etc. etc.
What have I tried, you ask? Two things...
I tried using a list box and move all my tables into there. However, the list box needs a DataSetName. I give it the main dataset name, but then every table I add in gets it's DataSetName changed to match and that breaks the report.
I tried going into my DataSource and associating the tables together based on a common field. That works in the sense that I have no errors, but the data for whatever reason is all over the place and not with the correct values. I can tinker with the data source but I did not create it and I just have to deal with how it is set up. I really only change datatypes or make sure that results are correct.
I am hoping that someone can help me out!
Generic examples below (imagine that sales are from one dataset and taxes are from another, plus 8 to 10 more tables, but for simplicity, just 2 in the examples):
Example 1
Team B is chosen and I want a report for each of the options in the drop down.
| Teams: | Emps: |
| Team A | Emp 2 |
| Team B | Emp 4 |
| | Emp 5 |
Currently, I get something like this:
| Bad Report | Emp 2 | |
| | Total Sales: | 2300 |
| | Total Taxes: | 920 |
What I want:
| Report 1 | Emp 2 | |
| | Total Sales: | 500 |
| | Total Taxes: | 200 |
| | | |
| Report 2 | Emp 4 | |
| | Total Sales: | 1500 |
| | Total Taxes: | 600 |
| | | |
| Report 3 | Emp 5 | |
| | Total Sales: | 300 |
| | Total Taxes: | 120 |
Example 2:
Team A chosen, select all:
| Teams: | Emps: |
| Team A | Emp 1 |
| Team B | Emp 3 |
What I am getting:
| Bad Report | Emp 1 | |
| | Total Sales: | 3800 |
| | Total Taxes: | 1520 |
What I want:
| Report 1 | Emp 1 | |
| | Total Sales: | 2600 |
| | Total Taxes: | 1040 |
| | | |
| Report 2 | Emp 3 | |
| | Total Sales: | 1200 |
| | Total Taxes: | 480 |
