Link to home
Start Free TrialLog in
Avatar of valmatic
valmaticFlag for United States of America

asked on

Display Top n Hours and Top n % insame SSRS report

Hi. I am working on a report request to show top 50 variance between reported actual vs. standard run labor in a manufacturing environment. No big deal but the manager requesting this wants top 50 by both hours and by percentage.  That means most likely two separate result sets.  I'm having a hard time wrapping my head around this.  This has to be presented in separate reports right?  is there any way to essentially create two reports with separate output within a single report in SSRS?  My SQL query source includes calculated data columns RunVarianceHrsPerUnit & RunVariancePctPerUnit, which I'd run the Top n reporting against. thanks
Avatar of Bembi
Flag of Germany image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
To have both reports showing the same (consistent) result:
Option 1: Make DB snapshot.
Option 2: Replicate DB to another server for read-only access by report.
Option 3: Duplicate tables for reports in the same DB.

You can use change DateTime column in a rows to filter out data for reporting period to minimize data volume in Options 2/3.

Then you can generate 2 reports and export them to files:
User generated image

After you've got two reports in two files you can merge files in one.


You can use C#:
1. Develop code.
2. Save 2 reports in one file from EXE. C# can generate Excel, HTML, CSV. TXT, XML, etc.
Avatar of valmatic


Thanks Bembi,  I haven't tried using sub-reports but I think this makes the most sense.  I'll check it out..