Create Impromptu report using SQL

[frienatic]

Hi there

I'm using Impromptu v7.

I can create an impromptu report using SQL.
However, I seem to be hitting some problems when inserting prompts to the query.

Any advise would be greatly appreciated.

TIA

 

[ALSAP]

Elaborate on the problem.

I've done this for years with no issues.

Would look like this: CP.CAL_PD_DATE BETWEEN ?PD1? AND ?PD2? Just use the insert prompt option in the query window.

-al

 

[frienatic]

Hi Al

The test query I did was just a simple one something that goes like this:

Select * from employee_table
where join_date > ?wdate?

?wdate? -> thats where i used the insert prompt button provided

and when I clicked on the verify button I got an error message:

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
Line 1: Incorrect syntax near '2008-11-01'.
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
General SQL Server error: Check messages from the SQL Server.

Then when you click the OK button you get an Invalid SQL query.

Would be great if you can help with this.

 

[MasterOveride]

Are you running the report inside of Report Studio? If you are you can try using the prompt macro. Would be something like:

#prompt('wdate','date')#

-don