Fake group based value list? 1

[beltmanjr]

I need to create a fake group which acts as a normal group based on a table with 3 values in it:

The group names should be like
'A'
'B'
'C'

So I get:
Group Header 1: A
Details: 'Blah blah'

Group Header 1: B
Details: 'Blah blah'

Group Header 1: C
Details: 'Blah blah'

How can I get this done?

 

[lbass]

What is fake about this if as you say there are three values in the group field? What is the purpose of the group?

-LB

 

[beltmanjr]

Well,
the values dont come from a table field, but from a list I put together myself in crystal.

I'll use it to group and display particular subreports. These sunreports should only be displayed for one of the list values of the group. For each set of subreports I need to be able to reset the page number and insert a page break too. So, creating this group to group these sets of subreports seemed an easy way out.

 

[lbass]

Just put the subreports in separate report footer sections, and then format the last two sections to "new page before" and set each to "reset page number after".

-LB

 

[beltmanjr]

That is a thought.
Just wondering if it isnt possible to create the groups I was thinking about?

 

[lbass]

Create a formula:

whilereadingrecords;
stringvar array grp := ["A","B","C"];
numbervar i := i + 1;
numbervar j := ubound(grp);
stringvar k;

if i <= j then(
redim preserve grp[j];
k := grp
);
k

Insert a group on this formula.

-LB

 

[beltmanjr]

Hi Lbass,
I tried the solution you gave above, but I can only see group 'A' and not 'B' and 'C'.

Have I missed something?

 

[lbass]

Please post exactly what you did, as I did test this and it worked perfectly.

-LB

 

[beltmanjr]

I just tried this on the xtreme sample db.
The issue is that my main report only retrieves 1 single record.

The main report then uses this 1 single record to link to the many subreports. I wanted these subreports, that come in sets, to be nicely kept together and made visible based on which group (A,B,C) would be displayed.

However, I'm afraid that this would never work in this manner, unless I can somehow couple A,B,C to the data in the main report, creating 3 rows instead of 1 to return.

I can't picture this clearly yet though.

 

[lbass]

You just need to add a table that has at least three records, or a larger table that you limit to three or a few more records in the record selection formula, and place one field in the report header, in order for the formula to work.

-LB

 

[beltmanjr]

Indeed I do need to add that table.

Thanks for your help