troubleshooting Question

Display Top n Hours and Top n % insame SSRS report

Avatar of valmatic
valmaticFlag for United States of America asked on
SSRSMicrosoft Server OSMicrosoft SQL Server
3 Comments1 Solution13 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Bembi
CEO

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros