Post reply

Repeating multiple tables in a report based on parameter selection

  • April 8, 2011 at 8:30 am

    #389238

    Hi all, I have an "is this even possible?" query.

    I have a report which consists of four small tables, each drawing from it's own dataset, but all using the same parameter. What I'd like to do is have it output to Excel with each group of four tables on a seperate Excel tab for each instance of the parameter. Is this something that can be accomplished, maybe using a list to group the tables?

    TIA!

  • April 11, 2011 at 7:05 am

    #1309796

    You can do the separate worksheets in Excel easily enough; they're done by setting a page break (like per group in a list object that contains all of those other tables). Though you can't name those worksheets until 2008R2.

    Alter the query to return the data for each 4 types of query but in one large table, with one column that will let you group them in the list.

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

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