Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

Group Specified on a non-recurring field

Hi there,
 
I would like to group a report based on a shared valued from a sub-report.

I have the following in the group (this is the first grouping)

if {@SHAREDAction Type} in
["Identification", "Identification/Engagement"]
then "Identification"

else if not (isnull ({@SHAREDAction Type}))
then {@SHAREDAction Type}

else "No Stage Assigned"

But I receive the error message, "group specified on a non-recurring field"

I'm not sure what to do with this one! Any help would be appreciated,

Thanks,
CS
0
rporter45
Asked:
rporter45
  • 3
  • 2
1 Solution
 
mlmccCommented:
Groups are added to the report before the subreports are run so the values aren't available for use in grouping.

Not sure why you get that as the message instead of an indication that the field is evaluated  later in the report.

To do what you want, you will need to get the data required to make the Action Type determination into the main report.

Does your report have other subreports?

mlmcc
0
 
rporter45Author Commented:
Hi there,

Your comment does make sense - yes, there is another sub report in the report.  It does not have any shared values with the main report.

So rather than have the sub-report with these values that need to be shared, I need to have that detail in the main report instead and build the remaining pieces of that from there?

Thanks for your quick response,

CS
0
 
mlmccCommented:
That would be the way to go.

I assume you know a subreport can't have a subreport so it is not as simple as making the one subreport into the maion and the maion into the sub.

mlmcc
0
 
rporter45Author Commented:
yes - thank you! Off i go to re-make this one!
0
 
rporter45Author Commented:
thank you very much for the quick response. Perfect answer, logical explanation based on the report.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now