Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Rows headers are printing with data Post Reply Post New Topic
Author Message
anushka
Newbie
Newbie
Avatar

Joined: 10 Apr 2008
Online Status: Offline
Posts: 29
Quote anushka Replybullet Topic: Rows headers are printing with data
     Posted: 16 Oct 2013 at 11:11am
Hi Everyone,
 
i have a report that has a chart on report header and with column names for the group summary
 
In the group header there is a group field of year and no. of physicians
In details are the details on individual physicians when year is selected for drill down option.
 
However the details also have the column name and data fields
like below
Headings :  Number  name  date  no. of cases
field values for : Number name , date , no. of cases
 
when it prints out in excel each row has header and value of header
example
 
number,name,date,no.of cases, 123,juan,02 oct, 2013
number,name,date,no.of cases, 342,lee,04 oct, 2013
number,name,date,no.of cases, 231,ayyar,02 dec, 2013
number,name,date,no.of cases, 567,smith,12 dec, 2013
i wnat headers to print only once
 
I tried moving detail headers around the report but it didnt solve the problem
 
Can you suggest where can i move the header names so they repeat only with details and just once.
Learning can be fun.
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 16 Oct 2013 at 12:35pm
have you tried placing headers on page header section?
IP IP Logged
anushka
Newbie
Newbie
Avatar

Joined: 10 Apr 2008
Online Status: Offline
Posts: 29
Quote anushka Replybullet Posted: 17 Oct 2013 at 7:35am
yes then it only shows up on first page which has chart and group header summary.
The next page which has the details on the summary comes without any column names.
Learning can be fun.
IP IP Logged
anushka
Newbie
Newbie
Avatar

Joined: 10 Apr 2008
Online Status: Offline
Posts: 29
Quote anushka Replybullet Posted: 17 Oct 2013 at 7:54am
if i create another detail section and add column names in it and suppress blank section it works good on report but when i export it come with alternate rows of column names. How can i avoid repeating column names ?
Learning can be fun.
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 17 Oct 2013 at 8:55am
try creating in section expert another group header place the details headers there.
IP IP Logged
anushka
Newbie
Newbie
Avatar

Joined: 10 Apr 2008
Online Status: Offline
Posts: 29
Quote anushka Replybullet Posted: 17 Oct 2013 at 11:14am
yes but then it displays on the first page after each summary row
 
i added a formula for suppressing it on first page but then when i drill down on the group the first page of details doenst show these columns either.
 
can we add formula in group header b that show only when drill down is clicked without impacting group header a
Learning can be fun.
IP IP Logged
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