Can anyone help with Crystal Reports 7?
19 November 2003, 03:55 PM
#1
Scooby Regular
Thread Starter
Join Date: Jun 2000
Posts: 4,413
Likes: 0
Received 0 Likes
on
0 Posts
I've got a report which was having some problems. I've managed to just about fix it but have one last problem I need to solve.
Basically, the records are made up of Entry Headers, which have multiple invoices, which have multilpe lines. I group the records by entry. Some lines are duplicated due to autiding methods so they would repeat 3 or 4 times, but I've managed to suppress these. The problem is that as I've suppressed duplicate they no longer appear on the ones I want them to.
EG It looks like this.
Entry Invoice Line QTY
123....888.......999 100
......................777 100
......................666 100
.......999..........999 100
......................777 100
When I want this..
Entry Invoice Line QTY
123 888 999 100
123 888 777 100
123 888 666 100
123 999 999 100
123 999 777 100
Any ideas?
Ta
EDIT to make them line up
[Edited by Nimbus - 11/19/2003 4:00:50 PM]
Basically, the records are made up of Entry Headers, which have multiple invoices, which have multilpe lines. I group the records by entry. Some lines are duplicated due to autiding methods so they would repeat 3 or 4 times, but I've managed to suppress these. The problem is that as I've suppressed duplicate they no longer appear on the ones I want them to.
EG It looks like this.
Entry Invoice Line QTY
123....888.......999 100
......................777 100
......................666 100
.......999..........999 100
......................777 100
When I want this..
Entry Invoice Line QTY
123 888 999 100
123 888 777 100
123 888 666 100
123 999 999 100
123 999 777 100
Any ideas?
Ta
EDIT to make them line up
[Edited by Nimbus - 11/19/2003 4:00:50 PM]
19 November 2003, 06:23 PM
#2
Scooby Regular
Join Date: Oct 2002
Posts: 358
Likes: 0
Received 0 Likes
on
0 Posts
Have you suppressed duplicates for all the detail section of the report (i.e. selected one format for all fields) ?
Maybe using suppression by individual field would work better ?
Or maybe using whileprintingrecord instruction ?
Tricky to answer without it in front of me.
If you e-mail me a sample I can look at it tomorrow (I'm on 8.5 so apologies if not applicable to 7)
Baz
Maybe using suppression by individual field would work better ?
Or maybe using whileprintingrecord instruction ?
Tricky to answer without it in front of me.
If you e-mail me a sample I can look at it tomorrow (I'm on 8.5 so apologies if not applicable to 7)
Baz
21 November 2003, 10:44 AM
#3
Scooby Regular
Thread Starter
Join Date: Jun 2000
Posts: 4,413
Likes: 0
Received 0 Likes
on
0 Posts
Baz,
I got it to work using the "whileprintingrecords" function to suppress duplicated rows. This bit now works fine. Thanks.
Problem is that the subtotals I'm producing are not working properly
It's adding up all the values, not just the ones displyed on the report. Some lines are hidden as they are just duplicates, but it's including these in the subtotal. I've tried using the same "whileprintingrecords" formular that I used to suppress the duplicates, but it's not helping.
Does anyone know how to stop it summing all records and just the ones printed?
Need to get this done today.
Cheers
Does anyone
I got it to work using the "whileprintingrecords" function to suppress duplicated rows. This bit now works fine. Thanks.
Problem is that the subtotals I'm producing are not working properly
It's adding up all the values, not just the ones displyed on the report. Some lines are hidden as they are just duplicates, but it's including these in the subtotal. I've tried using the same "whileprintingrecords" formular that I used to suppress the duplicates, but it's not helping.Does anyone know how to stop it summing all records and just the ones printed?
Need to get this done today.
Cheers
Does anyone
21 November 2003, 06:58 PM
#4
Scooby Regular
Join Date: Oct 2002
Posts: 358
Likes: 0
Received 0 Likes
on
0 Posts
Getting there !
Use a running total with a formula to reset to zero. It's another while printing records one where you define two GlobalVar - one to equal the detail and one to accumulate the values.
The idea is to tell it to keep adding until something changes.
Baz
Use a running total with a formula to reset to zero. It's another while printing records one where you define two GlobalVar - one to equal the detail and one to accumulate the values.
The idea is to tell it to keep adding until something changes.
Baz