So, I'm not sure this is even possible in SSRS, but I know you guys will know for sure and be able to help me out.
At work we are trying to create a universal report that anyone can utilize via SSIS. What we want is the following:
- The ability to chose the database being worked in (COMPLETED)
- Field boxes (up to 4) that allow the user to select what to select the job counts by. For example, selecting counts by State by City by Zip.
- Once chosen, those fields would automatically populate in a table in the report.
So, it would be like the order of the fields selected would determine the order of the group, order by. So if you were to choose File_Source in field 1 box, QuoteSaveType in Field 2 and Industry in Field 3, it would automatically know to do the following and put it in a table. The Table and fields will be the same, just the order/group by will be different.
Select File_Source, QuoteSaveType, Industry, COUNT(*) Count
From Input
Group By File_Source, QuoteSaveType, Industry
Order By File_Source, QuoteSaveType, Industry
Does that make sense? Is it even possible?
Aucun commentaire:
Enregistrer un commentaire