Skip to Content

Display/Hide text in Report Footer based on specific text in Group - Crystal Reports 2013

Hello,

I have a CR which displays data in both Detail and Group Footer sections. I'm looking to hide/display a text in Report Footer based on the specific string in a column that appears in Group Footer.

When any of the customers has same values (across multiple columns) then I combine them into one row in Group Footer as "Grouped Customers" or else they show up in Detailed section.

Now in the Report Footer I want to show a text message whenever the GROUP FOOTER contains the word "Grouped Customers" in Customer Column. If it doesn't then hide the text in Report footer.

Ex: See the attached image - This is how my Report shows "Grouped Customers" in Group Footer: for CA & IL as the product and state (which is my condition for grouping customers) for these two customers are same.

below is the approach that I have taken

I tried to get the count of number of occurrences of the word "Grouped Customer" in the Group Footer and then use that to suppress the Report Footer using that if the count is <1.

Count of Grouped Customers

var1: if {@GroupName}="Grouped Customers" then 1 else 0

use the var2 to suppress report footer

var2: if var1<1 then True else False

The problem is var1 is showing the correct count when placed in Group Footer (from the above example var1 is 2) but when i use it in Report Footer to show/hide the text it is now working since the var1 values is always returning 0 in Report Footer.

Any help on this is really appreciated.

-Dilip

sample-report.jpg (71.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 22, 2019 at 03:46 PM

    I would either do a running total or a grand total sum on Var1. Then, in the report footer, suppress if that sum is equal to 0.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.