Search results for query: *

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

Use the Active Data driver and a ttx file. http://support.crystaldecisions.com/library/kbase/articles/c2004983.asp Regards Marc

Can you try taking the '= TRUE' out of the first line? I'm not able to check this at the moment but it may well be knocking out the test processing sequence, and is superfluous in any case. Let us know if this changes anything. Regards Marc

OK then. How about you design the report and the SQL Stored Procedure to have three parameters... ...then, add a 'vSource' variable in the report that defaults to 'Printed from ASP' or whatever the required legend is... ...then, in the calling VB code, use CrxRpt.SetReportVariableValue to...

Reebo - I think Matt needs to run the same reports under VB, at which time they need the extra parameter. Matt - I believe in VB you can append a parameter (and then obviously populate it). Not got time to try this at the moment, but something in or around CrxRpt.ParameterFields.(something)...

Any chance of putting the maintainable codes into an Oracle table rather than Access? That would make the whole thing do-able in a single SQL statement. If you must use Access then over to folks who are clever than I for further instructions... Regards Marc Kozlowski