hi
i am trying to upload my sp in Framework manager and i have 1 parameter in sp which is datetime format.
when i am trying to create parameter like #prompt('date1') # it gives me error like
incorrect date format.should be CCYY-MM-DDThh:mm:ss
.
i tried to_date(#prompt('Start_Date')#,'yyyy-mm-dd')
and also cast,but still getting same error
Any help?
is this parameter going to be supplied from within the report?
If so, you can just put in #prompt('param1','token')#
hi
what you mean by token here,this parameter will come from stored procedure
Surely the parameter will be passed to the stored procedure, not derived from it? What Arsenal suggested is a prompt macro to prompt for the parameter which is then passed to the stored procedure, and the 'token' part is in the place where a data type would normally be specified in the prompt macro. Token simply means that nothing is assumed about the data type and the value is passed as-is.
Regards,
MF.
ok.i did like this
#prompt('param1','datetime') it gives me error like param1 is not found in stored procedure.
RQP-DEF-0177 An error occurred while performing operation 'sqlExecute' status='-69'.
UDA-SQL-0043 The underlying database detected an error during processing the SQL request.
[Microsoft][SQL Server Native Client 10.0][SQL Server]pram1 parameter not found in Validation_result
Any help