Recent content by Sange

We recently carried out a new install of Crystal Reports V10 which I thought was completed without incident. However I am now developing a report that contains person images. Prior to the install, I could select the image field and drop it into the report. When I try to do this now, I get a...

I am currently using CRv10 and have developed a report that randomly selects 15% of offender files to be audited. The requestor has asked for a few more additions and I'm not sure if this is possible. First the report is to run quarterly however they would like to ensure the records returned...

Thanks hilfy - good to know that I was on the right track. I guess this means I will be setting up limits to stop them from deleting! Thanks again.

Hi, I am currently using version CR10 & CE10. I have developed a report which is accessed by users via Crystal Enterprise. The report runs daily for a number of locations. Typically, a user will view the report instance for their location and then delete the scheduled instance once the report...

Hi LB, I'm not quite sure how this works but it does! The first formula keeps displaying zero in the actual report but then the group footer formula will in fact display if the absence is unacceptable. Wonderful. Thanks so much.

Hi, I am developing a report in CR10 and need to capture any person who has missed 3 consequtive days of community work with the status "Absent No Contact". I have grouped the report by community work site and then person id. As a result the data looks like this: ABC PARKLANDS PERSON_ID...

Hi lbass, great news your suggestion was spot on and it looks like it's now flagging contracted / uncontracted records correctly. I have also been able to add the formula into a running total to count which records are contracted and that looks like it's working too so thank you very very much.

Sorry lbass, I forgot to add that I also need to add totals for each location ie. total offenders & total offenders contracted. Obviously the total offenders is easy enough but am also having trouble with calculating the total offenders contracted. Thanks again.

Thanks lbass, this solution would have worked perfectly but then I discovered the following: My report contains duplicate records at the detail section may which means the sum({@relevantcontract} will also count duplicates. I have done my best to eliminate duplicates but some continue to...

Hi Madawc and lbass, yes the issue is testing the max in my running total and that I can't seem to do it. lbass, your solution was great in that it was able to just return those uncontracted offenders. I was hoping this would be enough however the customer wants to be able to see contracted...

Hi, I am developing a report using CR10 and it is proving to be a lot more difficult than I expected. The purpose of the report is to count how many offenders have had all their order conditions contracted. Each offender can be subject to one or more orders. Each order will contain at least...

It worked! Once again your assistance has been invaluable. Thank you so much lbass.

Hi, I have spent so much time trying different work arounds and have got no where so I am hoping someone will be able to assist me. I am using CRv10. My report is grouped by Order_Id and what I'm trying to do is work out the datediff between two program types/dates attached to each order. The...

Hi lbass, as always you have been very helpful. Your solution is so logical that I'm actually quite embarrassed I didn't see it myself! Also, I have never used your way of calculating % so will definitely do so from now on - thanks for including it in your post. Sange

Hi, I am using CRv10 with an Oracle database. I have a report which currently calculates the total amount of work hours expected compared with hours actually worked for each agency. To do this, I created formulas to calculate the datediff (in seconds) for Scheduled and Actual hours and then...