Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Page Header, Footer while exporting to Excel Post Reply Post New Topic
<< Prev Page  of 2
Author Message
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 07 Jun 2007 at 10:12am
I just had a thought...
 
Depending on the complexity of the report on the number of groups you have, you might be able to put the group header in a separate details section at the top of the details.  You would then put a suppess formula on that section:
 
{group field} = previous({group field})
 
This way the "header" will only appear at the beginning of each group like it should and, since it's in the details line, should also appear in the excel export.
 
I haven't tested this, though, so I'm not absolutely certain it will work.
 
-Dell
IP IP Logged
Atheeque
Newbie
Newbie
Avatar

Joined: 31 May 2007
Location: Canada
Online Status: Offline
Posts: 2
Quote Atheeque Replybullet Posted: 12 Jun 2007 at 11:30am
hi guys
Thanks for your reply. 
I am able to get the header row information by spliting the header section into two sections and keeping each row on the seperate sections.
I dont know whether the process is correct or not. but when exported the data comes in the write format as i need them.

Atheeque
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.012 seconds.