SSRS Page break based on start and end date parameters.

  • 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.

  • 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