SP23 - Parameter incorrect with dynamic list of values parameters

[Former Member]

parameter-is-incorrect-message.pngHello,

We have had Crystal Reports integrated into our application for many years now, and have periodically updated the runtime versions. We have just updated from SP20 to SP23. Generally, this has been fine however we are having trouble running Crystal Reports that contain parameters which are dynamic list of values. Just as the report is loading in the viewer and the parameter dialog is about to open, we get a message from Crystal Reports that says 'The parameter is incorrect.' (please see attached picture) and the parameter dialog doesn't load.

Crystal Reports that contain all static parameters or no parameters at all work fine.

Is there a fix for this or anything I can try?

Please let me know if there is any more information I can supply.

Kind regards

Elliott

[former_member11696 · Accepted solution]

Try this eStore link:

https://www.sapstore.com/

Don

[Former Member · Accepted solution]

And what's the name of the product that I should be looking for?

Elliott

[former_member11696 · Accepted solution]

Crystal Report will do. Just tell them you are using Crystal Reports for Visual Studio and the Component is BI-DEV-NET

[Former Member · Accepted solution]

I don't really know what you mean. We already have Crystal Reports, so I don't want to buy this again. You previously said I would need to purchase a 'single case'. I cannot find this on the SAP store link that you sent me. Nor can I find BI-DEV-NET.

Can you send me a link to the specific thing that we need to purchase please?

All I need is support to get this issue resolved as soon as possible.

Elliott

[former_member11696]

Try calling them -

Call us at +1-866-776-6567

Chat is only for People with Support Contracts.

[Former Member]

Hi Don

I managed to find the parameter test app, but didn't really get anywhere with it. I updated it to use SP23 and I get similar results as I do with our application.

So I wonder if we can escalate this to a support case? You previously mentioned purchasing a single case and directed me to your 'product- support' page. I couldn't find any mention on there about a single case. I tried 'Start an Expert Chat', which directed me to ONE Support Launchpad, but there were no options on here to do anything.

Could you please advise how we can go forward with this.

Kind Regards

Elliott

[former_member11696]

Parameter test app link is on the WIKI page where you get all the other info from:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

[former_member11696]

Hi Elliot,

Issue is becoming to complicated for Forums. Can you purchase a simgle case and I'll pick the case up, just let me know the incident number.

If it is a bug you will get a refund - https://support.sap.com/en/my-support/product-support.html

Did you try my Parameter test app and see if that works?

Did you update the DB client to latest version?

Does a new report work?

Don

[Former Member]

Hi Don

I do not think you provided me with a parameter test app.If you could provide this to me please, I will try this out first.

I am not sure what you mean by updating the 'DB client to latest version'; the runtime is the latest version and the CR references in the project are the latest version (13.0.3500.0).

If I create a completely new CR, this does not work either.

I also followed your link to the product support, what option would this be, 'Schedule an Expert', 'Start an Expert Chat' or 'Report an Incident'?

Kind Regards

Elliott

[Former Member]

Hi Don

If you could send me your parameter test app please, I will give that a try and we can move forward with this.

This is becoming a very serious issue as we have customers who are unable to run these particular reports.

I look forward to hearing from you.

Kind Regards

Elliott

[Former Member]

Hi Don

Could you please provide an update on my previous comment please.

Kind Regards

Elliott

[former_member11696]

I did a quick test and Vitaly sent me a reprot with params set up the same as you have and I don't see the issue, it does prompt because multi-level dynamic parameters will only return the last parameter in the SDK, but I don't get any error, it does prompt for them.

So I need more details about the code you are using?

Are you setting any values or do you expect the report to prompt for them?

If expecting it to prompt then I suggest look at the CR References, it may be your Cr viewer needs to be udpated to 13.0.3500.0 as well.

VS will not replace the viewer when updating the project, Notes on the download WIKI page does tell you to manually replace all references and the viwer in your app.

Don

[Former Member]

Hi Don

I have been doing some more testing and still no joy.

I have tried setting ReuseParameterValuesOnRefresh to false and this doesn't fix it.

I have the following CR references in the application;

CrystalDecisions.CrystalReports.Engine
CrystalDecisions.ReportAppServer.Prompting
CrystalDecisions.ReportSource
CrystalDecisions.Shared
CrystalDecisions.Web
CrystalDecisions.Windows.Forms

All of these are version 13.0.3500.0.

I have removed the CrystalReportViewer from the Windows Form and re-added it and I still get the problem.

As well as the multi-level dynamic parameter, the report also includes 3 static string parameters.

These 3 static string parameters are being set by the application.

This is done using the method, ReportDocument.SetParameterValue(string, object).

Again this was working with SP20.

Thanks

Elliott

[Former Member]

Hi Don

I was just wondering if you have an update my previous comment?

Following on from this, we have since found another issue with SP23.

We have a report that contains a sub report; if a parameter is added to the parent report and a sub report link is added to pass the parameter value through to the sub report then an error occurs.

In this case, the parameter is a just a static number parameter. The report begins to load, and the parameter dialog appears. If I enter a value into the parameter field and click 'Ok', another dialog appears that just says 'Unspecified error' and the dialog has the title 'Crystal Report Windows Forms Viewer'.

Again this type of report was working fine with SP20.

I look forward to hearing from you.

Kind Regards

Elliott

[former_member11696]

It's call ReuseParameterValuesOnRefresh, should be set to false.

I have not done parameter testing since SP 20 so I'll have to create a report with 2 levels of parameters and see what happens.

I'll try to get to it today if time allows

Don

[Former Member]

Hi Don

The report is connecting to a Microsoft SQL Server 2008 database.

The report was built using the driver 'Microsoft OLE DB Provider for SQL Server'. The report runs fine from within Crystal Reports itself, even with this driver. When building the report, I have changed the report to use 'SQL Server Native Client 11.0', but it still does not work in the application.

Do you have to force the report to use 'SQL Server Native Client 11.0' within the application code? If so how is this done? As previously mentioned the connection information is set using TableLogOnInfo and ConnectionInfo objects within the code.

Thanks.

Elliott

[former_member11696]

What SQL Server version are you connecting to?

What DB driver are you using? If it's current then you will need to update the report to use MS SQL Native 11 client.

[Former Member]

Hi Don

Thank you for getting back to me.

The parameter is not a stored procedure parameter, but the parameter is based on the data. The parameter has 2 levels - the selected option at level 1 determines what is shown at level 2. Please find attached a screenshot of how the parameter is defined within Crystal Reports.

I can confirm that the logon information is set before the report is loaded in the CrystalReportViewer control. This is done using the TableLogOnInfo and ConnectionInfo classes in code and it is connecting to a Micrsoft SQL Database.

I wasn't able to find a 'Discard Parameter Value' in the viewer properties. I looked within the Crystal Report itself and on the CrystalReportViewer control in the application. Whereabouts can I find this property?

I can confirm that this report was working with SP20 but not with SP23. We have also tried other Crystal Reports that have the multi level dynamic LOV parameters and these no longer work either. The Crystal Report runs fine if we remove this specificedit-parameter.png parameter.

I look forward to hearing from you.

Kind regards

Elliott

[former_member11696]

Hi Elliott,

Are they Stored Procedure Parameters? If so you need to set the log on info first.

And in the Viewer Properties change the discard parameter value to false or true and test again.

It also depends on your database driver, what DB are you connecting to and which Client are you using and how are you connecting, ODBC, OLE DB or Native?

Don