July 7, 2015 at 9:51 am
Hi All,
I have a detailed report in ssrs in which data can come from start date and end date parameters.
but the problem is. for example i gave startdate as 01/01/2015 and end date as 09/31/2015 then the data must be in displayed in such a way that jan month in one tab and feb month data in one tab and sooo on to sep month data in new tab when i export to Excel.
Is this posible in ssrs ?
Please help out in figuring out this problem, its kind of urgent.
Thanks,
Kalyan.
July 7, 2015 at 1:23 pm
dhanekulakalyan (7/7/2015)
Hi All,I have a detailed report in ssrs in which data can come from start date and end date parameters.
but the problem is. for example i gave startdate as 01/01/2015 and end date as 09/31/2015 then the data must be in displayed in such a way that jan month in one tab and feb month data in one tab and sooo on to sep month data in new tab when i export to Excel.
Is this posible in ssrs ?
Please help out in figuring out this problem, its kind of urgent.
Thanks,
Kalyan.
It is possible. However, it's also possible that you'll end up with more data than 1 page can hold for a given month.
Change your dataset to include a field based on year and month, such as:
SELECT CAST(YEAR(DATEFIELD) AS char(4)) + '_' +
RIGHT('0' + CAST(MONTH(DATEFIELD) AS varchar(2)), 2) AS YEAR_MONTH
Then, use that field to control a Group, and just suppress the group's footer section.
In the group header section, check the box for New Page After.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply