A Question about Textual SQL Query Data Source 1

[japanese]

hi, everyone.

I have a question about Textual SQL Query Data Source.

I've used Graphical SQL Query Data Source before,
but I need to use 'CASE WHEN --- THEN --- END'
statement of SQL.
So I created a new Textual SQL Query Data Source,
then I have a problem now.

I can't put Ad Hoc Parameters in it.
Because, the Tab 'Ad Hoc Parameter' is out of use....

How to set up Ad Hoc Parameter in this Tab ??
Anybody knows how to make it possible, please give me
advice.

Regards,
japanese

 

[milton747]

With Textual query, you have to hand edit the SQL.
Example:
SELECT TopDeals.custID, TopDeals.customName, TopDeals.Status, TopDeals.Amount
FROM TopDeals
WHERE :?P1

I had to hand type in: WHERE :?P1

Once I did that (and hit describe button) P1 will appear in the Ad Hoc display. Hand enter the column you wish P1 to apply to. eg: I typed TopDeals.Amount. Then I chose Intger as the data type.

Thats it. Run the report and enter a value
I entered: >2000000