A Crystal Report parameter became an unselectable dropdownbox when imported in SAP B1

[Former Member]

Hello everyone,

Im new here in forum. Could anyone help me out on my issue? I have created a report and it works well in Crystal report Ver 14.0.4.738 RTM. I have encountered problem after importing the report in SAP B1 8.82.076 PL12. The report parameter in SAP became a dropdownbox and cannot be clicked or selected. The parameter should be a textbox, I didnt expect to have a dropdown box.

I have attached below a screenshot:

Please help me on this.

Regards,

Jerard

[Former Member]

Hi Jeard ,

         Remove Stored Procedure from Crystal report . Add a command through Database Expert call the procedure from there. Create a Date Parameter @Date first

exec SP_Test {?@Date}

Regards

Reena

[julie_jamieson2]

Create a parameter in your command 'DateSelected' then in you declare statement @DateSelected = {?Dateselected}

[former_member325312]

Hi Jeard ,

Instead Of this write a sub query for this as on selected date and see then it might work

Regards

Jenny

[Former Member]

Hi Jerard,

May be there is no connection between SP and Crystal report so you try only Dateselected@, then you will not get that dropdown box.

Hope it helps you.

[julie_jamieson2]

Hi Jerard,

If you want them just to be able to enter a date, remove the @ symbol from in front of your parameter.

If you want to select a date from a database list, you will need to refer to the table and field name in your parameter eg Date@SELECT RefDate from OJDT

[Former Member]

Hi Julie, Thanks. I tried to update the stored proc by removing "@" and it displayed error: "Incorrect syntax near 'DateSelected'".