Search results for query: *

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...

LBass you have come through me yet again. The report is perfect. Thank you so much.

Hi LBass, I'm hoping you won't mind me asking you another question about this cross tab. I have managed to get my row percentages working based on your suggestion but the column totals percentages are not calculating as I would hope. Ideally I would like to keep the row % as is but the...

Hi LB, you have been extremely helpful once again. Have a vague idea of how this works but would have never worked it out myself so thank you very much.

Hi am using Crystal Reports v10 and have developed a cross tab based on the number of days it has taken for an assessment to be completed by gender. Each Assessment is allocated a unique number and as a result, the summarised field is made up of distinct count of this unique number. The...

Thanks to the both of you, I really appreciate it. The running total is in the report footer and because the report is run over a date range, a person could potentially have more than one custody number if he's been particularly naughty over a period of time :) If he has been released from...