SSRS: Use of Sparkline

  • 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

  • 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

  • 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 ?

  • 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

  • Million Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply