Print Page | Close Window

Grouping by Text formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18862
Printed Date: 03 May 2024 at 2:49am


Topic: Grouping by Text formula
Posted By: tomahames0604
Subject: Grouping by Text formula
Date Posted: 23 Jan 2013 at 4:20am
Hi Everyone

I need your help...

I have a report that passes data to a subreport which in turn passes back data to the main report. In the main report I have a formula called "Attention"

Attention Formula

if {@Dec Marker} = "ATT" then totext ("ATTENTION PHILLIP")

What I want to do is to group by this field so all the "Attention Phillip" are together because at the moment they are spread out throughout 8 pages.

Can this be done?

Thanks


-------------
Tom Hames


Replies:
Posted By: lockwelle
Date Posted: 23 Jan 2013 at 5:46am
It depends.
If the formula @Dec Marker is based on information from the subreport, then no you can't.  Grouping is done prior to the subreport being run.
 
If on the other hand, the value is based on one or more columns that already exist in the main reports datatables, then yes you can group on the formula.

Posted By: tomahames0604
Date Posted: 23 Jan 2013 at 11:19am
Thank you, unfortunately the formula is based on information from the subreport. The one thing that I find so annoying is if I want to suppress the details that are not relevant, huge gaps are left in the report, because it will still pass details over. Annoying that you can't suppress a subreport. Does anyone know?

-------------
Tom Hames

Posted By: aharonmc
Date Posted: 24 Jan 2013 at 8:01am
You have to suppress all sections in the subreport,
format the subreport to 'Suppress Blank Subreport' on the Subreport tab,
remove the borders,
and format the section on the main report to "suppress blank section".
 
This will make the section disppear if the subreport is blank.


Print Page | Close Window