on 11-01-2016 1:48 PM
Hello,
I want to suppress some sepecific part of the rows in the Details Section and then the suppress rows show up in the Group Footer Sections in Crystal Report.
Currently the Detail Section is look like this...
Item
1
30
40
AA
9
12
BB
CC
I want to have the Detail Section becomes like this...
Item
1
30
40
9
12
Then AA, BB, CC to be shown in the Group Footer sections...
AA -- Group Footer1
BB -- Group Footer2
CC -- Group Footer3
Thanks,
Jean
Hi Jean,
1. Create a formula (@Group) with this code:
if isnumeric({item}) then
'*A*' else {Item}
2. Insert a group on this formula field
3. Suppress the Group Header.
4. Copy the Item field from the Details to Group Footer - so you now have the same field on Details as well as Group Footer.
5. Go to the Section Expert > Highlight the Details Section > Click the formula button beside 'Suppress' and use this code:
{@Group} <> '*A*'
6. While in the Section Expert, highlight the Group Footer > Click the formula button beside 'Suppress' and use this code:
{@Group} = '*A*'
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jean,
Here's what you need to do:
1. Insert a Group Footer 1b section.
2. Go to the Section Expert > Highlight the Group Footer 1b Section > Click the formula button beside 'Suppress' and use this code:
{@Group} <> '*A*'
3. Go to Insert Summary > Choose Qty as the field to summarize > Choose Sum as the operation > Under 'Summary Location', choose 'Group Footer 1'.
4. Move the summary field to Group Footer 1b.
5. Create a formula with this code and place this on the Group Footer 1a:
shared numbervar g2;
if {@Group} <> '*A*' then
g2 := g2 + {Qty}
6. Right-click the formula field > Format field > common tab > Check 'Suppress'.
7. Create another formula to display the total and place this on the Report Footer:
shared numbervar g2;
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Abhilash,
Thank you so much for your time. It works great.
-Jean
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jean,
Try to keep one question/issue per post so it's easy to search on and find the answer to....
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.