Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal report prompting parameters for optional field of stored procedure


    Can anyone help me with this issue. I couldn't find a solution for this problem.

I have a storedprocedure that has one field optional

@ReportID VARCHAR(14) = '0X000000000000'

In Report I have 30 parameters Field [no ReportID field as its optional in storedprocedure].

1. In visual studio 'Main Report Preview' It prompts me for 30 parameters [Working fine]

2. I run the code in web with nothing filled. When it prompts it shows me 31 parameters. Why is it asking me that optional parameter.

Current fix [not a perfect one]

. Planning to modify the storedprocedure and report, which mean I have to modify a lot of report which uses that storedprocedure.

Is there other alternative for this fix.

Code used

Crystal report XI

Thank you


Former Member
Former Member replied

I installed SP10.

My case was little bit different. There is optional parameter in Storedprocedure and that paramter isn't there in Report.

So I was getting a Popup for that parameter. Well I asked Report guy to add additional parameter. It kinda solved that problem.

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question