Search results for query: *

Hello LB, I worked the whole thing out with the help of google and its worked perfectly. Thank you so so so much for all your help, I really appreciate it. Beth :-)

Hi, I don't know how to do much of the stuff in your last reply, I will see what I can work out/google tomorrow. Will let you know again if I get stuck. Thank you very much Beth

Hi LB, This will not work as some customers have multiple lines with 0 in month 0 1 and 2. Is there away to put a count on each line of detail? if so I could do as above but if row number =1. Not sure if this is possible just thinking in my head!! Thanks Beth

Hi LB, I think your suggestion will still end up with some repetitions. Here is a very simple version of what the details look like, it can have many more lines for some customers, also more ID's but this is the basic of how it works. And this is how I would want that data to display If...

The detail of the report has one row for each line of a shop order so the months are correct and not repeated, each row then finds the credit limit and open balances from the customer master, it does this for each row so they are repeated over and over. The debt formula is like this....both...

The running total for Debt is as follows, Field to summerise: @Debt Evaluate - on change of field - SOFCM.customer_ID Reset - On change of fiels - SOFCM.customer_name For credit limit is is exactly the same but summerise @crd lim. Is there another way to get the total of the group 2 footers...

Hi LB If i try this it tells me that it cannot be summerised. This is the formula for Group 2 "spare" +Maximum ({SOFCM.CREDIT_LIMIT}, {SOFCM.CUSTOMER_ID})-Maximum ({@Debt}, {SOFCM.CUSTOMER_ID})-Sum ({@Month 0}, {SOFCM.CUSTOMER_ID})-Sum ({@Month +2}, {SOFCM.CUSTOMER_ID})-Sum ({@Month +1}...

Hi I am new here and new (self taught) to crystal. I am trying to supress group two footer if group one footer is supressed, I can't find an easy way or can't find a formula that works. I have googled for ages!! Here is a summary of my report Group 1 Header: Customer Name Group 2 Footer...