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

Thanks for your help but I can't seem to able to export report definition..!

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

Thanks for your help lbass I am not limiting the data because the next step is to find the time difference in months between MinDate and any Date Completed before that date. i.e. In the above example MinDate= 03 June 07. So I want to know the difference in month between 03 June 07 and 31 May 07...

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

Thank you for your response. I do know the use of disctict count function. That's not what I was asking in my original question. Sorry for the confusion. I thought a formula get evaluated on the basis of where it is placed. If my formula is placed in the header then it shouldn't double count...

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

May be I am not explaining myself very well. Let me try again. As I mentioned, Case to CourtReport has one to many relationship. CaseId is the unique identifier field in both tables(tblCase and tblCourtReport) and CourtReport and CourtReportTypeRef are the fields in CourtReport table...

I am using tblCase and tblCourtReport. I am trying to find all cases where there was either 1) No report or 2) If there was a report then the report type was other than 1. Case to CourtReport has one to many relation. I get the result of (1) by the full outer join but don't know how to...

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

Thank you all. It worked.

Thanks But it still doesn't work. this is what I have in my reset formula whileprintingrecords; If Not InRepeatedGroupHeader then Global NumberVar DOFH:=0; Global NumberVar DRFH:=0; Global NumberVar DODR:=0; is it wrong ? or am I missing anything ? C8

NO spoke too soon. It didn't work.

I have manage to solve it myself. I had to use global variable instead of shared variable. C8

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

Thank you both.