IBM Db2 Web Query for i

Hi,

Is it possible to automatically split a report into seperate sheets of a single excel file based on the contents of a particular column in the report?

My workaround would be to duplicate the report, hard-code the filters and then combine it back into a document. 

Many thanks,
Thomas

Hi Thomas, 
Not sure if this is exactly what you're looking for or not, but the "Table of contents" button in InfoAssist (under Format tab) will, when the output is excel, put sections of the report into unique tabs of the spreadsheet based on the highest-level sort column/field. 

The "trick" is to have that field that differentiates each tab's content as that first sort field (you can hide it if you want). 

Hi Doug,

Many thanks for this - it's exactly what I wanted and will be very useful.

If I can push my luck a little further, we have a requirement for sales reports where we'd like to do a traditional burst of sales to each sales rep for their territory and then, within that, each report to do a "table of contents" for each business division.  In my mind it would be a case of bursting by the first column and then a table of contents from the second column but I fear that this is not feasible.  Can you think of a way?

Kind regards,
Thomas