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.
Crystal report XI
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.