Report Works Different in Seagate Info

[horna]

I have a Crystal Report that has a Order Counter in a formula. Inside the formula it reads "if {TBLORDERS.ORDNUM}>"0" then 1 else 0". This adds the number of Orders per selected catagory. If I run it from Crystal Reports, it works fine, BUT if I run it from Seagate Info it does not. The problem is after the page break the counter does a very stange thing. It takes the total on the previous page, say 45, and just adds 1 to it, to make 46. It should clear the 45, and then add up the next catagory on the new page whatever it is. I have moved the information around, but it always happens after the page break no matter where it is on the report.
Thanks very much for your help.

 

[synapsevampire]

Interesting...

I'd try changing the formula to something like:

if isnull({TBLORDERS.ORDNUM}) or trim({TBLORDERS.ORDNUM}) = "" then
0
else
1

This assumes that the ordernumber is generally blank or null. Note that the null check has to come before the check for ""

-k

 

[horna]

Thanks for the feedback. I tried your suggestion, but it still does not work. The thing is, it works perfect when I run it directly from Crystal Reports. I then run it from Info, and after the page break, that one counter column is incorrect. I can't imagine why Info is altering it.

 

[synapsevampire]

You got me...

But a counter isn't reset because of a page break unless you've specifically instructed it to reset in code.

Typically counters are reset at a group level, which may have a reset and new page after in it, but not at the page level.

You rpoint being that you get different behaviors from SI and CR seems to be the real issue though.

Keep in mind that CR is printer based, so if you have a different printer, or no printer, on the SI box you may experience different formatting.

-k

-k

 

[horna]

This is still bugging me. I have tried changing the Crystal report several different ways, but the one column in the report still prints incorrect at the beginning of the second page, AND ONLY WHEN I RUN IT IN INFO. If I run it from Crystal Reports, it prints fine.
I have a Formula "if {TBLORDERS.ORDNUM}>"0" then 1 else 0", which I put on the "Details Area" in the report. It counts the number of orders. I then have several running totals for each Group in the report.
The settings in the "Edit Running Total Field" is Order Number in the Field to Summerize, and Count in the Type of Summary. In the "Reset Area", I put a group, and checked off "On Change of Group".
Any thoughts? Thank you very much for your help.