Post reply

Creating pages on a drill down report

  • February 10, 2009 at 6:07 am

    #205200

    Hello,

    I currently am creating a three column report, where the first column is a drill down list that when opened, opens the second column, which is another drill down column, opening the last column.

    When I preview this report or deploy it to my report server, all of the information is all displayed on one page, and I want to split it into multiple pages, which I am not sure how to do. Optimally, I would like only a set number (let's say ten) of groupings of the first column on the first page.

    I think the method I have to use would have something to do with numbering my groupings, so that my first 10 groupings have the same number, then doing some kind of "page break at end" on the group, but I'm not sure what kind of expression would do this.

    Any help would be greatly appreciated.

    edit: I suppose I should mention that when I say "drill down" I mean that the initial visibility is hidden for the second and third column, and the visibility can be toggled by the previous column, just in case I'm not using the correct term for it 🙂

    Thanks

  • February 10, 2009 at 7:06 am

    #941175

    I've figured out one way of doing it, which might not be the best way - I grouped the data of my first column in SQL and then numbered this column so that it did incrementing count for every ten rows, then joined this count data to my existing dataset, so that I now have a column in the dataset that groups by every ten of my first column.

    This would be the SQL solution to my problem, I don't know if there is an SSRS solution too... some clever expression, or something 🙂

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply