Home » Developer & Programmer » Reports & Discoverer » Parameter setting as ? only on Win 2000 machines
Parameter setting as ? only on Win 2000 machines [message #88663] Mon, 13 January 2003 00:14 Go to next message
prakash
Messages: 24
Registered: October 2001
Junior Member
Hi All,
We have this Peculiar Problem happening only on Win 2000 machines.
In the Report, we are allowing user to give Start Date Range and End Date Range. Its Fetching the Records, but when viewed SQL Query from SHOW SQL Query it shows something like this.

SELECT
field1,field2
FROM
some_table
WHERE
some_table.DtTm >= ?
some_table.DtTm <= ?

Also If Both Start Date Range and End Date Range are same then query is Formed like below.

SELECT
field1,field2
FROM
some_table
WHERE
some_table.DtTm = ?

But The Same Report Works fine in WinNT (giving Correct Queries and getting correct results).

Crystal Version 8.5

Could Anybody here know what could be causing this Problem only for Win2000 machines and solution if any?
Thank you.
Re: Parameter setting as ? only on Win 2000 machines [message #88664 is a reply to message #88663] Mon, 13 January 2003 00:27 Go to previous message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi Prakash,
you don't think so its a parameter passing problem? just check it....because i don't think so report should behave different on different platforms(except Solaris).

Regards,
Ravi
Previous Topic: distinct option on groups
Next Topic: Drill-Down Reports
Goto Forum:
  


Current Time: Thu Apr 25 21:28:15 CDT 2024