Recent content by pastasalad

Thanks for all the suggestions folks. Here is what fixed it in the end: The ASP pages have been written to save the parameter names and corresponding values in a cookie, and then read back the names and values from the cookie later on. It turned out that it was during the period of time that...

Oops. Forgot to mention that the date does display UK format in CR itself, but reverts to US format when viewed on a webserver, using the ActiveX viewer. And yes, I have checked the webserver date format. It is also dd/MM/yyyy.

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

Thanks Synapse In fact everything I referred to was in the Crystal SQL statement, rather than the report selection formula. I have now got the selection to ignore blank parameter date fields, however, by using: ({table}.{field} >= '{?Start Date}') OR ({?Start Date} IS NULL)

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

Ahh! Just found the answer in the rounding thread below. Kirk out.

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

Doh! CURRENT DATE is what I was after. I'll get me coat.

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.

Cydamac There are a lot of possibile solutions here but we need to know more about your table and field definitions, as lbass says. Can you provide a couple of sample records? Marc

After 2 and a half HOURS of trying to get the .rpt to notice the new dataset from the .qry, it finally - and mysteriously - woke up and noticed! No particular reason as far as I could see. I just kept trying the same things over and over and eventually one of them worked. Sometimes I think of...

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

NateUNI - try Mid({String},instr({String},"ArticleTitle=") + 13) This finds the position at which the string "ArticelTitle=" starts (I am assuming that the string "ArticleTitle=" will always be present), then adds 13 to it to get past the ArticleTitle= string, and...

I think you are after CreateFieldDefFile() and CreateReportOnRuntimeDS(). Have you looked at this article yet? http://support.crystaldecisions.com/library/kbase/articles/c2002376.asp Let us know how you get on. Regards Marc