TheEntertainer
MIS
Hello,
Are you sitting comfortable. Once upon a time......
We have a number of reports which contain several groups (4 or 5) and because in the reports there are tables with a one to many relationship. Some of the group totals are running totals so we only get one occurence of them i.e.
Claim No. Paid Payments
D: 01010101 5000 500
D: 01010101 5000 1500
D: 01010101 5000 1000
D: 01010101 5000 800
D: 01010101 5000 1200
GF 01010101 5000 5000
The paid column only looks at the claim once. Now this is the strange part, after I wrote the reports and passed them over to the team that runs them using the crystal runtime process on an Oracle 7 database, after a while the running total field start to double the figures in the group footer. We were group on a field which had entries like PL, EL, but it would only double it on the PL group i.e
Claim No. Paid Payments
D: 01010101 5000 500
D: 01010101 5000 1500
D: 01010101 5000 1000
D: 01010101 5000 800
D: 01010101 5000 1200
GF(PL) 01010101 10000 5000
D: 01010102 5000 1000
D: 01010102 5000 800
D: 01010102 5000 1200
GF(EL) 01010102 5000 5000
The details lines are surpressed so you only see the group footer totals. But if I exported the report to Word the figures by magic corrected themselves. Eventually after much discuss with crystal(who said "I have never seen this happen before in a report"
they sent me an update to Crystal 8 Version 8.0.0.514, which by magic cured the problem. Now I have to 2 questions
a) Has anyone else experienced this problem?
b) The team that run reports here uses 7 (before anyone suggests it upgrading to 8 isn't an option, as they try that and the other reports went "off the planet" is there a solution for Crystal 7 besides creating manual running totals as I've had to do with one report.
The moral of this story is.........I haven't a clue
Thanking you in advance for any assistence
LOL
Are you sitting comfortable. Once upon a time......
We have a number of reports which contain several groups (4 or 5) and because in the reports there are tables with a one to many relationship. Some of the group totals are running totals so we only get one occurence of them i.e.
Claim No. Paid Payments
D: 01010101 5000 500
D: 01010101 5000 1500
D: 01010101 5000 1000
D: 01010101 5000 800
D: 01010101 5000 1200
GF 01010101 5000 5000
The paid column only looks at the claim once. Now this is the strange part, after I wrote the reports and passed them over to the team that runs them using the crystal runtime process on an Oracle 7 database, after a while the running total field start to double the figures in the group footer. We were group on a field which had entries like PL, EL, but it would only double it on the PL group i.e
Claim No. Paid Payments
D: 01010101 5000 500
D: 01010101 5000 1500
D: 01010101 5000 1000
D: 01010101 5000 800
D: 01010101 5000 1200
GF(PL) 01010101 10000 5000
D: 01010102 5000 1000
D: 01010102 5000 800
D: 01010102 5000 1200
GF(EL) 01010102 5000 5000
The details lines are surpressed so you only see the group footer totals. But if I exported the report to Word the figures by magic corrected themselves. Eventually after much discuss with crystal(who said "I have never seen this happen before in a report"
they sent me an update to Crystal 8 Version 8.0.0.514, which by magic cured the problem. Now I have to 2 questionsa) Has anyone else experienced this problem?
b) The team that run reports here uses 7 (before anyone suggests it upgrading to 8 isn't an option, as they try that and the other reports went "off the planet"
is there a solution for Crystal 7 besides creating manual running totals as I've had to do with one report.The moral of this story is.........I haven't a clue
Thanking you in advance for any assistence
LOL