I figured it out. I just added a statement to the TheDays formula and it works fine. Here is what I am using:
whileprintingrecords;
numbervar TheDays;
if (not(onfirstrecord) and {table.custmerID} = previous({table.customerID})) then...
I actually had a formula like this already. The calculation is great for just one customer but the first record of the next customer has the incorrect days. The way I see it, the first record of each customer should be 0 days since there is nothing to compare it to. Hoewver, the report is...
I have a report in which I need to calculate the number of days between a date value stored on each record for a customer. Below is an example of how the data would look:
order # customer ID order date
1 123 12/21/2004
5 123 12/28/2004
10 123...
Wow. That looks like it will do excactly what I want it to do. Did you look into the Crystal Reports Distributor at all? I would definately like to try both packages to see which one works best for me. Can I demo the package through you or do I need to contact Millet Software directly?
I have a report that is made up of multiple patient records totaling about 1500 pages. I am printing the report to our networked copier and would like to be able to staple the individual patient records. Does anyone know if there is a way to have Crystal Reports recoginize a command that would...
Thanks for all your help!! I did not have a lot of luck with the booleanvar suggestion but just got the report working by creating a running total field. I suppress section F if the running total is not equal to 1. I am sure I was doing something wrong with the booleanvar. Anyway, I just...
OK. The last post helped clarify the booleanvar suggestion so my section F is only printing once. However, now my sections F, G, H and I are not conditionally suppressing so they are printing on every patient record even when that patient did not receive the service.
It does not seem to be working but I have never used the whileprintingrecords command so I am not sure I am doing it correctly. From reading your post, I am assuming that I need create the @patient group formula and then insert it in section F. Currently, the result is always false. Next in...
Hello,
I have a report that will be used to generate patient surveys dependent on the type of service received. Our patients can receive anywhere from one service to eight services. I have created a group on service and added multiple sections to the group footer. Each section is set to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.