Crystal reports group naming issues

building reports crystal reports
1

Hi All,

I had to add a group to an existing report as below:
The report had 8 groups in which each group was divided into sub groups. This report is based of a sql query which had 10 sections and used UNION ALL between each section.
So in section expert I see group 1: has 1A to 1G, grop 2: 2A to 2C same way other groups are divided except for 5,6,7,8.

I am unable to find out how the groups are named…how does the name populate in the tree structure on the left?

So the tree structure that I see is:

Report Name
Statement
Group Statement(when I expand + it shows sub names for GH2b, GF3a–this is footer)
.
.
.
.
Product Group Statement(when I expand the + in this it has all the names of subgroup under it)—GH1f, GH2e, GH3b,GH4b and then it has details F

Now the requirement is to add another group below this which should be similar to Product Group Statement and should be named as Product Group Statement1 and in details has extra fields, this is similar to section 7 in the sql query which is the report based of. I entered the same query with union all which is section 11 and added extra fields as required.

In the section expert added the sub groups below the Product Group Statement sub groups and I am getting the exact format of the report. Here the problem is how is the tree structure named? when I added section 11 in the query I named it as “Product Group Statement1” which displays in the group tree. other subgroups dont display. When I customize GH3b to display in the tree GH3a, GH3c display as “NULL”. How do I change this to either display blank and not “NULL”

Did I follow the right approach is achieve the requirement?

Thanks.
Nisha

Nishasavvy (BOB member since 2012-09-30)

2

that is the default behaviour of groups… if you want to change groups up and down either you group by in backend query or go to section expert and then click on up and down arrows to change the sequence.

surya.g :india: (BOB member since 2009-11-24)

3

For your information, there is no subgroup here. You need to understand about how crystal reports works with groups.

If we insert First group from Group Expert, A Group header and A group footer will be added to the report.

GH
GF

If we insert second group, the groups sections changes as below.

GH1
GH2
GF2
GF1

And so on…

Now, at any point of time, you can insert a new section under any group header or footer. If I add one section under GH2 then you will see below

GH1
GH2a
GH2b
GF2
GF1

Hope it is clear.

anil.ganga1 :us: (BOB member since 2007-07-04)