How to supress text object in group header, needs to show only once

[kyzina]

Crystal Report XI
Multiple columns formatting + suppressing

I am in a process creating a report. I have all my data in. I have multiple column down then across, I have my data in two groups and a detail section . It’s look like a phone book when I preview.

Department GH1
Last Name, First Name (as @Name formula) GH2a
Title GH2b
Phone Detail

I have couple problems :

When I am preview the report I have Dept and @Name on one column and title and phone in another column. How I can format that?

Another problem: I have to print that report and fold it should fit my wallet. And on half of the first page I have to have it Company logo and some text. I have out text object in in GH and it’s need to show once

Any suggestions?


Thank you

 

[Madawc]

Group headers only show once unless you set them to repeat on a new page. If you do that, you can vary the display. I used the following to identify a continuation:

if Inrepeatedgroupheader 
then   "Continued"
else   ""

You should be able to adapt this not to show a particular field in a repeated group header. Note that you can suppress selectively using a formula.

===
As for the matter of phone numbers, I can't follow what you're after or what you've tried. PLease clarify.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[kyzina]

Thank you,
But when I put this formula in section expert in group header > Suppress I am getting a message"The formula result must be a boolen" Please advise. I have only 1 page of report and I need to have this text object appears only once.
____
For the second question I have multiple columns in the report :
Dept
Name
Title
Phone
and I can have Dept and Name on one column and Title and Phone on the next column. I want to keep them on 1 column/

Thank you again

 

[kyzina]

More details:
I grouped my report by Dept, and when I insert text object in the group header, the text objects is showing with each group when I am running a report. I want to show the text object only once with the first dept.
Please help. Thank you

 

[Madawc]

Try just Inrepeatedgroupheader. I was wrong earlier, those selection formulas should be just a test, no 'IF'.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[kyzina]

Thank you for reply but it's not working

 

[pamaley]

I'm not as advance as these wonderful pros in this forum but Why not put this text object in the report header since it would only show one time??? Dunno.