Running total field stops printing on page 40 of 53

[dminich]

I have a summary field that is reset at the group level which prints correctly on page 1 - 40 page 40 - 53 it does not appear??? Does anyone have any ideas what is going on?

 

[synapsevampire]

Perhaps it's an issue of a value being null.

If so, you might avoid it by selecting File->Report Options->Convert Null Value to Default.

-k

 

[dminich]

Thank you for your response, however that didn't work. This is a fairly simple report that is just creating a running total on a salary field that is grouped by account number and all records for that account are visible in the detail line.

 

[synapsevampire]

How is this running total created, are you using a Running Total type of field? Include any applicable code.

How large does the number become?

-k-

 

[dminich]

I've created a running total field summarizing Prem which is a formula field with the following calculation (If {Employee.b2_dpremiu}>{Employee.b2_epremiu}Then {Employee.b2_dpremiu}Else{Employee.b2_epremiu}) * {@Percent}. The type of summary is sum, it's evaluated on each field, and reset on change of group Group #1:Employee.U_J1act

 

[lyanch]

I have had this problem (always with larger 30+page reports
). I never could figure out what caused it. I ended up starting the report over from scratch and it started working perfectly. Maybe someone else has some better insight on how to fix.. rather than recreate. At least you know your not alone..

Lisa

 

[synapsevampire]

What's in @percent?

Your logic seems sound, so I suspect that you're getting a null in a column somewhere, or perhaps you have a suppression on somewhere.

-k

 

[dminich]

@percent is a numeric value such as 100 or 45 etc. It's the percent of their total salary that is paid out of that account number.

Perhaps, I just don't understand why it is displayed correctly for each group on page 1 - 39. I think this might actually be a bug in CR. I saw an article posted for a bug of this nature in 8.0 but nothing as to whether the bug still appears in 8.5.

 

[synapsevampire]

I doubt that it's a bug, it's pretty basic stuff.

I'd be more inclined to think that @percent may be returning a null in it, which would appear as blank, but if Lisa has experienced the same thing, you may be right.

Have you considered creating your own running total using the 3 formulas method?

Group header formula:
global numbervar MySum:= 0;

Details formula
global numbervar MySum;
If {Employee.b2_dpremiu}>{Employee.b2_epremiu}Then
MySum :=MySum+{Employee.b2_dpremiu}
Else
MySum :=MySum+{Employee.b2_epremiu}) * {@Percent}

Group footer formula:
global numbervar MySum;
MySum

-k

 

[lyanch]

Sorry -k .. it is a bug.. I have seen it before and just rebuilding the report it started working. I now also remember that for some reports I used 3 formula totals to bypass it as well (as you suggested). Why it happens is truely a mystery. I could run the original report and the running total would die.. and run the rebuilt report across the same set of data and it would work. I remember getting a couple greys over that one because I was also on a too tight deadline as well..

Lisa

 

[dminich]

I've finally figured it out!!!! After recreating the report and began to reduce the height of some of sections to reduce the number of pages, I reduced a group footer and scrolled through the report and noticed that again some of my totals stopped displaying on the later pages, when I undid the action they appeared again. I went back to my orginal report and increased the height of that footer and all my totals re-appeared. So it seems as thought it is a bug since half of the report displays correctly and the other half does not but fortunately it's a simple solution. Just check the height of your sections if this happens to you.