One tablix - multiple datasets

  • Hi all

    I've come across a bit of an issue where I need to display different data depending on the field in the report.

    For the majority of the data in the tablix, I need to show the data corresponding to the month selected by the user.

    However, I also want to show a sparkline graph showing the year-to-date position (for the last 12 rolling months).

    I've got most of it working apart from the sparkline (which is coming from a different dataset) and I just can't get that to work.

    I thought about adding an item to the original dataset to show the rolling 12 months in it but that gives me duplicated rows and makes a mess of the original dataset.

    It appears to be possible by changing the dataset name just for the sparklines but I can't see how to get it working (and Google just shows what people have tried without success).

    Has anyone got this to work and, if so, can they let me have a step-by-step guide please?

Viewing 0 posts

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