Exporting data in to multiple tabs in excel based on a Field

[cognos05]

Hi ,

I have a report studio cross tab  report , which has GLAccounts in Rows and Time in columns with Actuals and planned value measures Nested under  it.  Now I have a requirement to run this report based on CostCenters and Email to users accordingly .

Say there is a Group called HR, I will have to email them an excel file with say 5 tabs having 5 cost centers related to HR with above report .

So I have the costcenter field in report with attribute values on it as HR . So I nest this before the GL and should I just set page break on cost center , will this work for cross tab.

Can you let me know which way would be appropriate to achieve this .

Thanks,