cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to show Top 1 in GH3?

Former Member
0 Kudos

Post Author: kcornett

CA Forum: General

I am using CR 11.0.0.1282 on XP Pro SP2

Group Header 1 separates by Product Code ("Mold", "Repair", or "Production")

Group Header 2 separates by Order (list of order numbers)

Details shows Jobs (list of order numbers with -01, -02, etc.)

How do I show just the first job (-01) in group header 2?

thanks,

kcornett

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Post Author: kcornett

CA Forum: General

typo... sorry

I have 3 product codes that I want to report on - Mold, Repair, and Production. For Mold and Repair, I want to print out only the top 1 job for each order. For Production, I want to print all jobs. I have GH1 to group by ProdCode. GH2 groups by Orders. Detail A section has a formula to suppress if ProdCode = Production. Detail B suppresses if ProdCode is not Production. I can get the suppresion to work but I don't know how to get the Top 1 to show when Detail A is shown.

Obviously I'm new at Crystal Reports - about 3 weeks.

Thanks for your help...

Keith

ps: what are the Tags for when posting?

Former Member
0 Kudos

Post Author: synapsevampire

CA Forum: General

Add the table.Jobs to the order criteria (Report->Record Sort Expert), then just place the field in GH2, the first one for GH2 will will diplay.

Not sure what this has to do with a Top 1 function in a group header 3 as the topic suggests.

-k