Hi All, Does anyone know how I c

[zaq888]

Hi All,

Does anyone know how I can pass a SQL statement as a parameter into the Crystal Report Designer from my source code.

the SQL statement is:

SELECT TUnit.[cs-username]
FROM TUnit LEFT JOIN [SELECT * FROM Tdata WHERE Tdata.date BETWEEN ? AND ?]. AS MyTempTbl ON TUnit.[cs-username] = MyTempTbl.[cs-username]
WHERE (((MyTempTbl.[cs-username]) Is Null))
ORDER BY Tunit.[cs-username];

? stand for datepicker.value

I'm Keep Studying.... please show the way...
Not Good in English

 

[synapsevampire]

Are you using VB, and which version of Crystal, and which method are you using for invoking the report?

Here's the listing of sample applications:

http://support.crystaldecisions.com/fix/samplescr.asp?ref=default.asp_selectlist

Check for SQLQueryString, which may allow for this depending upon whatever it is that you are doing. Otherwise consider using ADO.

-k

 

[zaq888]

i'm using vb 6 and crystal report 8.0

Can u help me out

I'm Keep Studying.... please show the way...
Not Good in English

 

[synapsevampire]

You can edit the Where clause, check:

http://www.andreavb.com/forum/viewtopic.php?TopicID=671

-k