Recent content by poujor

Try using this in your Record Selection Formula ({W000001.DATETIME} >= DateAdd('h',-32,cdatetime(CurrentDate)))and ({W000001.DATETIME} < Currentdate) I assume your datetime field has the name {W000001.DateTime}

It seems you are grouping on PatienceId and creating a pie chart. What about using GroupNumber to identify each Patient select{?anonymize} case 'N' : {patients.surname}+' '+{patients.Firstname}+' '+cstr({patients.patient_ID})//[1] case 'Y' : "Patient "+GroupNumber default :"Patient "+GroupNumber

Or even simpler: {?Region} = "All" or {ItemRevenue.Region} = {?Region}

Hi LB Thank you for the reply. Now I have made further investigations too. Selecting all Countries and only the Region "Distrito Federal" when prompted for paramtere input only returns Brasilia It Ought to return 4 as you stated. I think Crystal Ought to use the query SELECT Distinct...

Hi The Following registry might solve it: HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV If you are using R2, then change 11.0 to 11.5. Add a string called MaxRowsetRecords and set a new maximium number of records. Making it 0 gives you unlimited...

Hi I'm doing some testing on Cascading dynamic prompts. The 'issue' is found in XI, XI R2 and 2008. Do Use the customer table from the Xtreme Sample 11.5 database (part of XI R2) - can be downloaded at https://smpdl.sap-ag.de/~sapidp/012002523100005852352008E/cr_xi_xtreme_rep_smpl_en.zip...

Hi Campu5 Edition? I assume you have grouping on the field {client.client_area}. If not there is your explanation. I have had some minor issues (a minor bug) in the Alert Condition formula in CR XI R2 newest SP. It seems to be like your error. It normally happens when the Alert Condition...

Hi lbass is right. This is just some additional information. Crystal Reports 2008 is the first edition allowing you to change between Portrait and Landscape. This is done on section level. Additionally it forces an New Page Before and a New page After on the section you configure to use...

Hi Charting data where print-time formulas are required is somewhat advanced. I suggest you have a look at the fo0llowing document describing how to chart on print-time formulas: http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_charting_print_time_formulas.pdf.asp poujor

Crystal Reports XI Crystal Reports stores temporary data in the temp folder. in files named ~crw*.tmp Is there a way to change this location? Thanks Poul

Hi, I understand, you want pagenumbers on all pages except pages 1 through 4 and last page. To handle this create the following formula and use it as page number if (PageNumber in [1,2,3,4]) or (PageNumber = TotalPageCount) then "" else cstr(PageNumber,0,"")

HI, Consider: {ContHist.ONDATE} = {?Date_Range} and ((not ({Contact1.COMPANY} startswith ["Party Time", "PTR", "CS3"])) or isnull({Contact1.COMPANY})) and {ContHist.REF} startswith ["1.", "2.", "3.", "4.", "5.", "6.", "7.", "8."]

To handle the Regional settings issue the Static date can be referenced using Cdate(year,month,day) An example for January 4th 2007: Cdate(2007,1,4)

In Crystal Reports XI, the landscape option is not available if no printer is installed....

or: select ({ITSM_INCIDENTS.INC_CIT_OID}mod 100) case 72 : "None" case 73 : "Low" case 74 : "Medium" case 75 : "High" case 76 : "Critical"