Search results for query: *

I am having problems getting a CR9 report to display dates in the format '21/09/2003'. If I ask for 'System Default Short Format' then the date is displayed in US format: '09/21/2003'. If I force the '01-Mar-1999' format, then it does successfully show '21-Sep-2003'. But this is not what the...

I have a Crystal 8 report, based on a SQL Query on a DB2 UDB database, which includes 4 parameters: - Parameter1 - Parameter2 - Start Date - End Date All of the parameters are optional, thus I have used: ({table}.{field} = '{?Parameter1}') OR ('{?Parameter1}' = '') to disregard any parameter...

I want an integer field to display as an integer (eg. if the field holds 123, I want to display '123'). CR9 is insisting on displaying this field - when I use it as part of a formula field - with decimal point and places (eg. '123.00'). I know there is a way of preventing this. It is something...

Hi folks I need to select only records where field-x = today's date. (DB2 UDB). Or even field-x = DATE(today's date). I can't find the term used to refer to today's date (I have tried SYSDATE, TODAY, DATE, and some others). Thanks if you can help.

Am I missing something here? I have an .rpt based on a Crystal .qry (Crystal Reports v8) that has been running fine for weeks. I added an extra field into the dataset returned by the .qry, and can I get the .rpt to acknowledge the update to the .qry? Not a hope. I have tried: - Verify database...

A long-standing (10 months) CE8.5 solution that reports on an Oracle 8i database (native connectivity) was recently updated to include some new reports. The new reports run through a native connection against a SQL Server 2000 database. The solution, which had been stable throughout its 10...

I know I've been here before (about 3 years ago!) but I can't remember the outcome. 2 SQL Server 7 databases on one server. I need a report that includes data from both. What are my options? Thanks for any pointers. Marc Kozlowski

A report has been written based on a Crystal query, and it was running fine. The Crystal query was then changed to pick up some new fields. Query runs fine with new fields picked up. BUT...although the new fields are visible and available on the Field Explorer on the main report editor, they...

Hi Folks My report is grouping on transaction type from a selected dataset. In each group footer I am showing the maximum value of transaction within this transaction type and the minimum value of transaction within this transaction type. So far so good. However, as well as the max and min...