Skip to Content
0
Former Member
Dec 11, 2011 at 09:51 PM

The date parameter in the command is not prompting

23 Views

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