Hi all,
I have a report which is sorted by category and products each category are displayed on different pages. Now when my users exports the data in excel it gives one bank row between each category. But my users wanted that each category should be create separate sheet one excel file.
Can I do achieve this in crystal report? Or Is this fixed in Excel?
Any suggestions would be appreciated,
Thanks,
-V
I have a report which is sorted by category and products each category are displayed on different pages. Now when my users exports the data in excel it gives one bank row between each category. But my users wanted that each category should be create separate sheet one excel file.
Can I do achieve this in crystal report? Or Is this fixed in Excel?
Any suggestions would be appreciated,
Thanks,
-V