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
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.
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...