Suppressing in a formula

[mudflap]

I have a forumla that prints out the below

Chris Boylan 02-0527 Industrial Accident Prevention

This is the sales person, docket number, Client
Sometimes sales will have more then one job under there name I want to add to something to my formula so it will take the sales person name make it a Title and not print the name again but the jobs..I.e

Chris Boylan
02-0527 Industrial Accident Prevention
02-0528 What ever account

Right now it looks like this

Chris Boylan 02-0527 Industrial Accident Prevention
Chris Boylan 02-0528 What ever account

Thanks
Peter

 

[mudflap]

Oh yah.. Here is my current formula

whileprintingrecords;
stringvar job24;

If {Prepress WIP.Production Status (User Defined)} in ["Out on Proofs (No Film Imaged)","Out on Proofs (Film Imaged)","Out on 2nd Proofs (Film Imaged)","Out on 2nd Proofs (No Film Imaged)"] and {Prepress WIP.To (User Defined)} in ["Chris Boylan"]
then
job24 := job24 + {Prepress WIP.Docket (User Defined)} +" "+{Prepress WIP.Client (User Defined)}+chr(13)
else job24;

 

[Naith]

You need to create a new group on {Prepress WIP.To (User Defined)}

Change your formula to permanently drop the sales person so that it reads:

WhilePrintingRecords;
StringVar job24;

If {Prepress WIP.Production Status (User Defined)} in ["Out on Proofs (No Film Imaged)","Out on Proofs (Film Imaged)","Out on 2nd Proofs (Film Imaged)","Out on 2nd Proofs (No Film Imaged)"] and {Prepress WIP.To (User Defined)} in ["Chris Boylan"]
Then
job24 := job24 + {Prepress WIP.Client (User Defined)}+chr(13)
Else job24;

Naith

 

[mudflap]

Can I not use that sales person's name and put it as a title and suppress and duplicate name?
The reason I ask is because I want to be able to collapse the whole formula if there is no result.

Thanks
Peter

 

[Naith]

How are you going to use the salesperson's name as a title, if you don't group on it?

If you have a salesperson group, then there won't be any duplicate names to suppress in the first place.

Perhaps you should provide an example of how you expect your data to be displayed, compared to how it's displayed at the moment.

Naith

 

[mudflap]

Provided the look above..
Not sure Naith. As you know..Not good at this stuff.
Getting better. But still not good.

Does the above give you what you need?

 

[Naith]

Yeah - but the example you gave in your first post is what the solution I gave in my first post offers.

Chris Boylan

 This is the group header

02-0527 Industrial Accident Prevention

 This is the details

02-0528 What ever account

 This is the details

Naith

 

[mudflap]

Not really looking for a grouping though..
I have the last page that is only formulas..Those are the ones I want to do this with..

Guess it is confusing sorry people.