I have a report I am trying to build and I have two different fields for salespeople. Salesperson 1 and salesperson 2. I don't want to put them next to each other in the report but set it up so that the reports have the same underlying information just one for salesperson 1 and one for salesperson 2. Do I have to create separate reports or could I create one report that will give me the information in two tabs when I expor it to Excel?
The best way to accomplish this is to create a page set based on salesperson, then put the detail information on the report page:
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id28446cr_rptstd_frmat_rep_create_page_set.html
I use this often. The report exports to excel in different tabs which is great, but is there a way to have the tabs pick up the names of the salespeople?
I wish I had a nickel for every time that question gets asked!! As far as I know it could only be done via some sort of post-processing outside of Cognos. Or maybe with the SDK?