Crystal report prompting parameters for optional field of stored procedure

[Former Member]

Hi,

    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

Asp.net/C#

Crystal report XI

Thank you

Lakpa

[former_member183750 · Accepted solution]

What is the exact version of CR: 11.0.x or 11.5.x?

What version of .NET?

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member · Accepted solution]

Net Version : 4

Crystal Report version: 11.0.0.2495 [SP 4]

In Visual Studio

CrystalDecisions.ReportAppServer

[Version 13.0.2000.0]

Runtime Version: v2.0.50727

[former_member183750 · Accepted solution]

Not sure what Net Version 4 is(?). I suspect you mean framework 4, but that does not tell me if it is VS .NET 2008, 2010, 2012, 2013...

If 2010 / 2012 / 2013 make sure you are using SP 10 for SAP Crystal Reports, Developer Version for Visual Studio .NET:

- Ludek

[Former Member · Accepted solution]

I am using

Visual Studio 2012

yes, its .net framework 4.

[former_member183750 · Accepted solution]

I still do not know if you are using SP 10. What is the version of the crpe32.dll?

- Ludek

[Former Member · Accepted solution]

Hi,

I installed SP10 and

.Crpe32.dll version: 11.0.0.2491.

Visual Studio 2013, not 2012

[former_member183750 · Accepted solution]

Hmmm. Version 11.0.0.2491 is from Crystal Reports XI which is about 5+ years out of support. To use CR with VS 2013, you must have "SAP Crystal Reports, Developer Version for Visual Studio .NET", Service pack 10. This will give you version 13.0.10.x. Version 11.0.0.2491 is not supported in CRVS.

CR assemblies referenced in your project should have version 13.0.2000.x.

- Ludek

[Former Member · Accepted solution]

Hi,

These list of Crystal report dll with versions, that I am using for our projects

Report made on Crystal Report XI

[former_member183750 · Accepted solution]

OK. If those are the CR references, then your app will be using crpe32.dll of version 13.x. I still do not know if you are using SP 10, but let's assume you are... Please see if the following will help:

HOW TO PASS OPTIONAL PARAMETERS IN CRYSTAL REPORT | The ASP.NET Forums

Also see this:

http://ow.ly/Bx05e

- Ludek

[Former Member · Accepted solution]

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.