
Hi Folks,
I have to show last 3 months data on report running month. Client want to do it tablix. How to show dynamic columns . Please help me out.
Thanks in advance.

Hi Folks,
I have to show last 3 months data on report running month. Client want to do it tablix. How to show dynamic columns . Please help me out.
Thanks in advance.
Client want to do it tablix.
A tablix can act as a simple table or as a matrix, whereby a matrix support dynamic column basing on the existing data; so your first choise for the clients requirements.
See
Create a Matrix (Report Builder and SSRS)
Tutorial: Creating a Matrix Report (Report Builder)
Hi @Gopi-8614,
You may deal with the data with t-sql before you design the report to get last 3 months data on report running month.
Sample for your reference:
SQL query for getting data for last 3 months
You may also add parameter in the report to get the month you want.
ssrs-date-parameter-previous-month-specific-date
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October
Hello,
If you are looking for filtering at tablix label only then you can put filter column grouping of your Month Column. Refer the below URL for Reference:
http://www.sqlcircuit.com/2013/09/ssrs-how-to-filter-report-data-at.html
Thanks,
VJ
9 people are following this question.