Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

need help with complex SSRS report request: Expand / Collapse
Author
Message
Posted Thursday, February 6, 2014 9:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 13, 2014 10:16 AM
Points: 1, Visits: 8
Hi, first time posting here and I have a report requirement that I cannot seem to find any solution for.
I have a matrix with two datasets. The report will show current day data so it will be 5 rows. I've added a second row to the report, inserted a sparkline and the sparkline needs to reference the 2nd dataset in order to provide a 5 day trending for each metric. My problem is everytime I run this report, it comes up blank on the sparkline with no data. I've tried to reference the 2nd dataset under series properties, but that doesnt do anything.

I've attached some sample data broken into 2 tabs which goes into more detail. I'm starting to think this is not possible to do, but just need to see if any anyone has a solution.

Thanks,
Please let me know if I need to provide any additional information.


  Post Attachments 
sampleData.xlsx (13 views, 11.16 KB)
Post #1538742
Posted Wednesday, February 19, 2014 7:39 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 4:52 AM
Points: 493, Visits: 1,475
Something like this?

Design the spark line as a sub report with the second data set in it and use a parameter for the metricname and it should work and a little where clause in the data set to take the parameter and work out the dates needed. (Image attached)


  Post Attachments 
Spark.jpg (14 views, 80.27 KB)
Post #1543006
Posted Thursday, February 20, 2014 1:26 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 2:53 PM
Points: 204, Visits: 1,246
Something like this?
Design the spark line as a sub report with the second data set in it and use a parameter for the metricname and it should work and a little where clause in the data set to take the parameter and work out the dates needed. (Image attached)


This should work. You really have no choice but to use a additional report (in this case, the above mentioned subreport) with its own data region as you can only attach a single dataset to any of the data regions.
Post #1543707
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse