question

Gopi-8614 avatar image
0 Votes"
Gopi-8614 asked VJ-5333 answered

How to show 3 months data in tablix


103677-image.png





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.

sql-server-reporting-services
image.png (12.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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)


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

May I know how's the issue going on now?

0 Votes 0 ·
VJ-5333 avatar image
0 Votes"
VJ-5333 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.