If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Rename Excel tabs based on grouping criteria

Started by TheDarkKnight, 23 Nov 2010 04:22:19 AM

Previous topic - Next topic

TheDarkKnight

Hi Pals,
i have to page break based the output and the desired output is Excel 2002.

My requirement is to name each worksheet in excel automatically based on the grouping column?

Thanks!
Dinesh


sdee_sekaran

1. create a data item which will fetch only the grouping value.
2. Assign it to PageName()
hope this will give you the title as expected.

Regards, Dhana.

Sreeni P

Quote from: TheDarkKnight on 23 Nov 2010 04:22:19 AM
Hi Pals,
i have to page break based the output and the desired output is Excel 2002.

My requirement is to name each worksheet in excel automatically based on the grouping column?

Thanks!
Dinesh



I've had the need to do this several times and also never seen a good solution. From everything I've read this is not possible (other than perhaps through SDK or Excel Macro, neither of which are great solutions). I have put in an enhancement request for this for future release, and I believe several others have also (and encouraged people to do so). Hopefully if enough people request this they will add in next version. This seems to be a common need and would be very slick...