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

SSRS: Use of Sparkline Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 5:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 30, 2013 1:33 AM
Points: 10, Visits: 15
I am currently trying to Show the monthly Customer income rate by customer. I would really like to use sparklines for it, the Matrix which i am using, usually spread horizontaly over all months of current year till the current Month seems to hold the sparkline only within 1 Cell (see Image).



as you can see, the sparkline does what it is supposed to, though only in 1 cell, and I'am trying to do this over all cells, so the title on the cell aboves (2013-01) Shows it over all Points (2013-01 | 2013-02 | etc.) Does anybody know how this can be achieved? thanks a lot
Post #1496336
Posted Thursday, September 19, 2013 7:34 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 11:09 PM
Points: 3,187, Visits: 1,392
It looks like you are using a matrix and want to dynamically merge columns. I don't believe this can be done (would love to know how if it can).

The usually way sparklines are shown is in a column alongside the data so that the trend of the values can be compared between different customers in your case. Adding the sparkline on alternating rows may be nice so that the values are above the point on the sparkline. You could do this using data point labels though.

In the attachment the first table is what is normally shown.

The second table shows what I think you want. This is a mixture of a header table with two subreports. The first subreport holds that table. The second has the sparkline. Both use a parameter of customer passed. You can dynamically change the width of the chart using the dynamicwidth property to change dependent upon the number of months the customer has bought.

Both look ok, but the first option allows the comparison and the alignwithintablix allows the months to align horizontally.

Fitz


  Post Attachments 
Sparklines on rows.jpg (20 views, 55.76 KB)
Post #1496390
Posted Thursday, September 19, 2013 8:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 30, 2013 1:33 AM
Points: 10, Visits: 15
HI and thanks for your answer!
a i love the second Picture with the subreports, it's just that i don't have the slightest idea about how i can build it?
do you have any tipps for that ?
Post #1496409
Posted Thursday, September 19, 2013 8:15 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 11:09 PM
Points: 3,187, Visits: 1,392
Zip file attached with the project / solution.

This is provided as is and I would strongly advise testing in isolation first. Not that there should be any problems.

Fitz


  Post Attachments 
Sparklines.zip (8 views, 21.40 KB)
Post #1496419
Posted Thursday, September 19, 2013 8:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 30, 2013 1:33 AM
Points: 10, Visits: 15
Million Thanks!
Post #1496420
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse