February 11, 2016 at 9:54 am
Dear SQLServerCentral members:
Hello, and a pleasant day to you.
Is there a way to add an additional column in SSRS/RDL by the end of the month? A client of ours wants a monthly delivery every month. They want to subscribe to this report every last day of the month. Thus, if they had this report last month, it should output:
Company | Item | Jan. 2016 delivery
=========================================================
Acme Corp | 00A-1 | 100
Acme Corp | 00A-2 | 50
Then, if they access this report at the end of February, then it should output:
Company | Item | Jan. 2016 delivery | Feb. 2016 delivery
=======================================================================
Acme Corp | 00A-1 | 100 | 25
Acme Corp | 00A-2 | 50 | 30
And the list goes on until column [December <current year> delivery] is reached.
In addition, at the very last column, after [December <current year> delivery] , it will have a column named [Grand total delivery] in which it will add all those monthly deliveries for a specific item.
Any help, or articles, or tutorial I could follow step by step regarding this?
Thank you and more power. 😎
Warm regards,
Mark Squall
________________________________
"Listen to advice and accept instruction, and in the end you will be wise." -Proverbs 19:20
February 11, 2016 at 12:51 pm
Instead of using a tablix, use a matrix. then put the date field in the columns part of the matrix and you should be off to the races.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply