Hello All,
I am recently facing a problem with my crystal Report Builder XI.
I have created a subreport in the group footer and inside it, I have placed a Command. The command has this SQL statement:
Select deal_no from deals where deal_dt={?dealdt}
The type of the parameter is date. Once I ran the report in crystal where I am building my reports, it showing the prompt, but during the runtime, it will be skipped and nothing will prompted.
I tried to change the SQL command and modify the query to accept only number paramters. The report is working fine and the prompt is showing for entering the value of it.
Can anyone help.
Thanks