Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Subtotal formula Post Reply Post New Topic
Author Message
rumbafum
Newbie
Newbie


Joined: 15 Nov 2006
Location: Portugal
Online Status: Offline
Posts: 6
Quote rumbafum Replybullet Topic: Subtotal formula
    Posted: 12 Jun 2007 at 7:11am
I have a report with several items being displayed in the report detail section. What i want is to have a transport value by page, like this:
 
Page1:
 
detail:
item1    value 10
item2    value 20
 
pagefooter:
transport : 30
 
 
Page2:
 
pageheader:
transport: 30
 
details:
item3    value 20
item4    value 30
 
pagefooter:
transport: 80
 
 
Page3:
 
pageheader:
transport: 80
 
.....and so on
 
I was using a running total to do this but the problem is that the displayed values are incorrect
for instance in the first page i was always getting value 50, so it's counting with item3 which is in page2 and it shouldn't
 
I don't have any grouping in the report.
 
Any ideas why this happen and solutions?
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 12 Jun 2007 at 9:01am
I think that maybe you wrote the question wrong? Did you mean to say that the Page Header is including the 30 even though it hasn't printed yet? I haven't seen a running total include a value from another page before, but it's a common complaint for the page header to do so because people want it to match the value of the previous page footer.

I would make it a manual running total using a shared variable. Then display the running total in the footer and reset it. That usually gets rid of any running total problems.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
rumbafum
Newbie
Newbie


Joined: 15 Nov 2006
Location: Portugal
Online Status: Offline
Posts: 6
Quote rumbafum Replybullet Posted: 14 Jun 2007 at 3:56am

In my first page the pageheader does not show any value because it hasn't print nothing yet, but in the next pages the pageheader prints the accumulated value until that point.

The PageFooter always shows values so in the first page shows accumulated value for the detail in that page, in the next page shows, accumulated page1 + accumulated page2 and so on.
 
Problem is that, sometimes not always, in my page footer or pageheader the values include one extra detail. For instance im my page1 i have 2 items, and so the pagefooter should display item1+item2 but it shows item1+item2+item3 instead, although item3 is in page2
 
I use a manual running total already and this problem occurs. I think the problem is because of my detail section showing a description which has size undefined
 
item1 Value
Description
 
and in my report i have in detail section not to keep together. Maybe thats the problem.
 
Thanks for your help!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.020 seconds.