Joined: 29 May 2007
Online Status: Offline
Posts: 1
Topic: Formula not working as expected Posted: 29 May 2007 at 7:07am
I run a loan brokerage firm and we use an access database that we input data into. I've generated a report in crystal and i'm trying to do a summary section of the report and it's giving me some trouble. We have several different types of loans and access refers to them as numbers 1,2,3, and 4 ... The report is split/categorized into offices. On the Last page of my report i want a read out of how many types (1&2 combined, and 3&4 combined), so i need some sort of count if statement BUT i need it to count types 1 and 3 as the value 1 and 2 and 4 as .5
One of the main problems i'm having is that crystal will only read the last entry of the last office and report from there?
I'm not really sure where to go, any help would be great
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 29 May 2007 at 2:44pm
You can have a manual running total do this. Create a formula that has two global variables. For each record check to see what the loan type is and increment the appropriate variable. Then in the report footer have two formulas where each formula just spits out one of the two global variables. This lets you display their value on the last page.
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>
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
IP Logged
