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

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

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

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

Hi, I am using CRv10. I have developed a report which will list the amount of times a prisoner has moved cells (placement). I am only interested in prisoners who have moved at least once. The report is grouped by: 1. Facility 2. Prisoner Name 3. Custody Number Each placement is given a...

Hi, I am using Crystal Reports v9 with an oracle database. I am currently developing a report which will calculate the total amount of community work hours/minutes performed at each community work location. The report is to be broken down by order type and location and also by month over a...

I am current developing a report using Crystal Reports v10. I initially created it by linking a number of tables and adding a date range parameter as well as a location parameter however, the performance was dismal and as a result, I am now looking at developing a similar report using an SQL...

Hi, I have created a main report which is grouped by Person_Id. An On Demand subreport is also placed on the same group level which allows users to view any photos attached to the Person_Id if they wish. The subreport and main report are also linked via the Person_Id field and the On Demand...

I'm currently using CRv10 and one of my reports is scheduled to run on the 3rd day of each month. The date is based on records created in the previous month ie: {DATE.FIELD} = LASTFULLMONTH. I've now been asked whether it is possible to randomly select a number and then only display records...

Hi, I'm developing a report which brings back the number of arrests over a date range. The requestor would also like to be able to choose days of the week within this date range and also a time range. An example of this might be: how many arrests were made between (date range) where the day...

Hi, I have developed a report in CR10 which is scheduled to run monthly via CE10. The report has two columns; one which shows the results for the previous month and the other column shows a year to date total. The report appears to run without an problems and returns the correct data at the...

I've developed a report which will allow users to choose whether the records are to be sorted by location or date. To do this, I created a string parameter called "Sort Order" which prompts users to select "date" or "location". The only problem is that if the date option is selected then the...

Hi, I'm currently developing a report (CRv10) which includes two parameters; date range and region. The region parameter relies on a formula and ideally the report would first search the date range before bringing back the regional information. I find however, that whilst I make sure the...

I have report which has been developed in CR9. The reports list attendees at different stations. There are currently three different versions of this report which lists the station attedances according to Region, Division, District. For example, in the Region Report the end user can elect to...

I have created a report using CR9 which contains three different groups. Ideally I would like to keep the groups together but realise this won't always be possible as the records for a particular group may exceed the page and as a result need to continue on the next page. I've found that if I...

I've created a report which contains an edit mask in the agency code parameter. Since the agency code can be either 3 or 4 characters I chose to use >AAAa as my edit mask so the end user could enter the code in lowercase if they wanted to. This works fine in Crystal Reports, however once the...