Create new detail section and suppress old based on a condition

[Former Member]

Hi All,

I am having trouble figuring out how to suppress a detail section when condition is true. I have a detail section (Detail Section A) on the report which displays all the details by default based on the linecodes {Invoice_Details_Prn.sLineCode}.

I want to create to new detail section (Detail Section B) similar to what I have right now. When the {Invoice_Details_Prn.sLineCode}=["CL"] then I want to the old detail section (Detail Section A)  to be suppressed. I don't want to use suppress section. The reason, I am trying to create the new detail section is ; I have other  {Invoice_Details_Prn.sLineCode}=["FR","PO"] to display when {Invoice_Details_Prn.sLineCode}=["CL"]. Can someone give a hand on this? Thanks.

Amol

[Former Member]

Can anybody help me out to deal with this issue? Thanks.

Amol

[Former Member]

Hi Abhilash/Dell,

I tried using both the conditions you guys mentioned above. Do not seem to work.

Thanks,

Amol

[abhilash_kumar]

Hi Amol,

Both the Details Section a and b essentially 'look' at the same database value.

Meaning, if the value of the database field {Invoice_Details_Prn.sLineCode} on particular row is equal to 'CL', the both Details Section a and b will show the same value.

Also, how do you plan to do this without a suppress condition anyway?

-Abhilash

[Former Member]

Hi Abilash/Ido,

Can you guys help me with the suppress condition for Detail A and Detail B section on my report?

Thanks,

Amol

[abhilash_kumar]

Please provide more examples of when you wish to suppress and unsuppress the Details A and B sections.

-Abhilash

[DellSC]

Go to the Section Expert for DetailsA and click on the formula button to the right of "Suppress" (DO NOT check the checkbox!.  Enter the following:  {Invoice_Details_Prn.sLineCode}=["CL"]

Do the same for DetailsB and enter the formula:  {Invoice_Details_Prn.sLineCode}<>["CL"]

-Dell

[Former Member]

I want to suppress Detail Section A when {Invoice_Details_Prn.sLineCode}="CL" and {Invoice_Details_Prn.sLineCode}="FR" and show Detail Section B.

Second condition- If {Invoice_Details_Prn.sLineCode} in ["1","2","6","7","Q","Q1"] then suppress Detail Section B and show Detail Section A.

Thanks,

Amol

[abhilash_kumar]

Hi Amol,

Go to the suppress formula for Details A and use this code:

{Invoice_Details_Prn.sLineCode} IN ["CL","FR"]

Go to the suppress formula for Details A and use this code:

{Invoice_Details_Prn.sLineCode} in ["1","2","6","7","Q","Q1"]

-Abhilash

[Former Member]

Abhilash,

The first condition works fine - {Invoice_Details_Prn.sLineCode} IN ["CL","FR"]

In second condition detail lines having - {Invoice_Details_Prn.sLineCode} in ["1","2","6","7","Q","Q1"] does not suppress.

Thanks,

Amol

[DellSC]

Is the Suppress checkbox checked?  If so, uncheck it.

-Dell

[abhilash_kumar]

I don't think the checkbox matters, Dell.

The formula 'overrides' the checkbox anyway!

-Abhilash

[Former Member]

Yes, the checkbox is unchecked.

[DellSC]

Actually, I've seen different results with suppression formulas with checked vs. unchecked.  This may have been in earlier versions of Crystal though (considering how many versions I've actually used.....) and it may not be true now.

-Dell

[Former Member]

Hi Dell,

I tried using the above formula as you suggested. The detail section shows all the detail lines including linecode CL. Is there a way detail section B will show only the detail lines when {Invoice_Details_Prn.sLineCode} = ["CL"] ? I am stuck with issue for too long. Please help. Thanks.

Amol

[ido_millet]

Use expressions to control the suppress attribute of Detail a and Detail b sections.