Joined: 23 Jan 2013
Online Status: Offline
Posts: 2
Topic: Grouping by Text formula 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.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
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.
Joined: 23 Jan 2013
Online Status: Offline
Posts: 2
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?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum