Search results for query: *

Using CR XI I work for a law firm and I would like to find out the second allocated solicitor for the case. for example. CaseID Allocation date Solicitor ID Case 1 01/11/2013 1111 case 1 13/11/2013 1112 case 1 24/11/2013 1113 case 1 30/11/2013 1114 so if I create a group on CaseID I...

Using CR XI I work for a law firm and I would like to find out the second allocated solicitor for the case. for example. CaseID Allocation date Solicitor ID Case 1 01/11/2013 1111 case 1 13/11/2013 1112 case 1 24/11/2013 1113 case 1 30/11/2013...

Using CR XI I am using a cross tab to show data by quarters. When I export this data in to Excel using the export option Microsoft Excel 97-2000(XLS) , it export the titles for each page. So I have to manually go through the exported excel sheet and delete all the extra rows with headings. Is...

Using CR XI Hi All We had changes made in the database so we have some old tables which are replaced with new tables. My task is to amend the report which use the old table with the new table and make sure the functionality of those reports don’t change. To do this, I add the new tables, and...

Hi All Using CR XI I have to create a report where the grouping on the time interval doesn’t fall into any options provided in Crystal. I need to run the report for the time period of 6 weeks. My time series looks like the following. It’s block of 6 weeks and then one week is added to the...

Using CR XI Does any one know what method is quicker in terms of report running time. Stored procedure or View ?? Thanks C8

Using CR XI My data looks as below GH -4242 (tblPerson.PersonID) Case ID Date Received Date Completed D-1111 01 Feb 07 31 May 07 D-1112 03 June 07 01 Aug 07 D-1113 09 Sept 07 02 Feb 08 Data is grouped by personID. A person could be on more than one case. I am trying to find...

Using CR XI I have 2 tables. Case CourtHearing One case could have many court hearings. The details tab contains Case.CaseId and CourtHearing.HearingDate To avoid seeing duplicate case ID, I have grouped the data by Case.CaseID. In the group header I have placed Case.CaseId and...

Hello all Using CR XI I am trying to use the following in my record selection but it doesn't seem to work. The link to the tblCourtReport is a full outer join. ((isnull({tblCourtReport.CourtReportTypeRef})) or ({tblCourtReport.CourtReportTypeRef} <> 1)) My dataset doesn't seem to reflect...

Using CR XI Hello all I have a variable which calculates running total. The following formula is in GH#3 Shared NumberVar DODR; DODR:= DODR + {@WrkDaysDtOrd_DtRecv} CR resets the value of this formula if there are more than one page. This formula works fine on page 1 but on page 2 it resets...

Using CR XI Hello All My report has the following layout. GH #1 D GF #1 The report have some headings in the page header section. The detail section is hidden( not suppressed) so details could be viewed by clicking on the group header. When I do this the headings don't appear. So the detail...

Hello All Using CR XI I have a date field which is empty. I am trying to create a formula which shows where there is no value in the date field. I am using the Isnull() function but it doesn't work. Does any one know what to put in the formula to identify blank date ? i.e for string fields one...

I have the following formulas in different sections of my report {@InterpreterPresent?} if not isnull({tlkpSpeciality.Caption}) and {tlkpSpeciality.Caption} = "Interpreter" then 1 else 0 {@InterpreterRequired?} if not isnull({tblPerson.InterpreterReq}) and {tblPerson.InterpreterReq} = True...

Using CR XI Hello all I only want to see data for the selected case IDs which I have in an Excel sheet. To achive this I put the following in the record selection formula: {tblCase.CaseID} in [3378, 3513, 3517, 4261, 4757, 4853] the list is long. I put about 4500 Case IDs in the above...

Using CR XI Here is the layout of the report Case ID HearingDt ResponseDt Dif in days GH1 0001 01/02/2008 D 12/12/2007 01/02/2008 51 D 26/07/2007 01/02/2008 159 GH1 0002 12/03/2008 D 31/03/2008 12/03/2008 -19 D 15/01/2008 12/03/2008 57 D 28/08/2007 12/03/2008...

Hi All Using CR XI I have to create a report on answers given to a questionnaire survey. Here are some sample questions Q1 – How would you rate the services provided by the salesman? A1 – Excellent A2 – Good A3 – Poor Q2 – Did you think the salesman had adequate knowledge of the product...

Hello All Using CR XI I have a report which has a date parameter. I accidently entered the wrong date. Instead of entering 01/01/2007 I entered 01/01/1007 and it gave me the following error. Failed to retrieve data from the database. Details: ADO Error Code 0x80040e07 Source: Microsoft OLE...

Hello All Useing CR XI I have a time field in my database which is stored in 24 hour clock formate (i.e 13:11:00) I want to find am / pm from time. Does any one know the function for this ? Thanks in Advance. C8

Hi All Using CR XI I have a parameter called 'Period' which has 'allow range value' option on so one can enter two date value in the period parameter. My question is how can I restrict the user entry so that minimum of perid can't be beyond 01/04/2007 ? Hope this makes sense. Many thanks in...

Hi All Recently I had to investigate on what our HR system was and I found out it is a system called KCS and it uses database called Progress. After spending a lot of time on internet I couldn't find much on Progress DB. Does any one out there know how to connect CR XI to Progress ? or have...