Search results for query: *

Thanks lbass I was trying to do something similar, only at group level as the data in the subreport is at group level (details suppressed) using GroupNumber. Your formula is much more elegant than my If statement so I will see how I go using this. Tweetie

Hi If you want stop the group tree from being available, you can uncheck Show Preview Panel under Report Options. When the report runs in Enterprise the Group Tree panel does not appear.

These are regular in-line subreports that just display data based on the parameter values selected in the main report. The reason I want to suppress the header on the subreport is because when the data displays on the main report (which is how the users are supposed to look at it), if it is not...

I am using Crystal Reports 2008 and the reports are published to Crystal Reports Server 2008. I have a main report that includes 4 subreports. Each page of the main report displays a security message in the Page Header and Page Footer. I have now received a request that when a drilldown on...

Hi I am using Crystal Reports 2008 v1, Crystal Reports Server 2008 v1 (we will be using Window AD authentication), Oracle 11g. We are trying to capture the computer name and the user name of person who has run the report on the Crystal Reports Server. I have used the function CurrentCEUserName...

Hi Madawc Thanks, but I know how to work out the time differences between 2 timers, but I can't work out how to write a formula to work out the times using the Start Timer and End Timer parameter values selected when the report runs without trying to write a huge if statement for every...

Also, I had a look on the SAP site and their response to the question is: Symptom Where do I download the ufldate.exe file? Resolution Log in to the support site and go to the Business Objects downloads are: https://www.sdn.sap.com/irj/sdn/businessobjects-downloads Set the product to...

Hi Ernst What version of Crystal are you using? Do you get an error when you run a particular report to let you know the dll is missing? Is there a reason why you can't use the 'standard' function CDate which you will find under Functions > Type Conversion in the formula workshop. It sounds...

Hi I am using Crystal 2008, Crystal Reports Server 2008, Oracle 11g. I am writing a report to display the elapsed times between different statuses for an incident. There are 10 different statuses. The user wants to be able to select the statuses to start and end the elapsed time calculations...

Thanks for the responses. I used the formula provided by lbass and it is working fine.

I’m using Crystal Reports 12.1 and the database is Oracle 11g. I have been requested to create a report based on a count of incidents (for which I am going to use a Crosstab). Data looks something like this: Incident Number Type Priority Incident Date 000161-21102010 Type 1 1 21/10/2010...

Hi I think I've got this working now. Changed the select to: (not HasValue({?Area - REGION}) OR {?Area - REGION} = {Regions.REGION} and {Regions.REGIONID} = {Districts.REGIONID} and {Divisions.DISTRICTID} = {Districts.DISTRICTID} and {Divisions.DIVISIONID} = {INCIDENT.LOCATION}) and...

Hi Turkbear The select statement in Crystal is: (not HasValue({?Operator}) OR {INCIDENT_NARRATIVE.OPERATOR_ID} = {?Operator}) and instr({INCIDENT_NARRATIVE.MESSAGE},"Priority changed") > 0 and {INCIDENT_NARRATIVE.MESSAGE_TIME} in {?From Date} to ({?To Date} + 1) and (not HasValue({?QPS Area -...

Does one report have Save Data with Report option in Report Options selected?

Hi I have been using Crystal Reports for years but only recently started using CR2008. I am reporting against an Oracle 11g database. I have set up a dynamic cascading parameter based on the following: Region District Division These are set up as optional (if no division is selected then all...

I have manually run the report and exported to CSV in both CR XI and CR 10 and the output looks exactly the same. I can only guess that the export is being handled differently in this version of Enterprise, but how would I check this?

We have recently upgraded to Crystal Decisions (BO XI R2) and Crystal Reports XI from CE10 and Crystal Reports 10. There is a Crystal Report that is scheduled to run daily and export to CSV format which formatted correctly in V10. Since the upgrade the CSV output has a blank row added to the...