Dynamic columns SSRS

  • Please check the attachment.in my SSRS report i can hide/display Months columns based on input parameter "columns. "Total" column should dynamically add the selected month values only.now its adding all the months values irrespective of selection.

  • I beleive you are getting all the months data into dataset. Total calculation will calculate all the months column be coz , you're jus setting the visibility is false. Why can't you use the month parameter to get only required months alone in the dataset instead of hiding the columns. Here how are you populating the column headings? Is it dynamic or static?

    You can create a table with Months and select left outer join with your dataset month column. In this query you can add a filter condtion. This way, report data set will have only the selected month's data and total will come correctly.

Viewing 2 posts - 1 through 1 (of 1 total)

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