Question Re: vb.net Parameter Default Value in Technology Q&A

vb.net Parameter Default Value

Former Member — Tue, 06 Oct 2020 18:16:08 GMT

Hi,

I have an application coded in vb.net that opens a crystal report in the crystal report viewer. I understand how to set parameter values in my vb.net code, but I also want to be able to access the default value of the parameter that is already assigned within the crystal report. Does anyone know how I access the default value of the parameter?

Thanks

Re: vb.net Parameter Default Value

former_member11696 — Tue, 06 Oct 2020 21:51:36 GMT

Hi Chris,

What version of the sDK are you using?

Have a look at this test app: https://blogs.sap.com/2016/02/17/how-to-parameters-in-crystal-reports-for-visual-studio-net/

It's C# but in the drop down list box there is a routine to get parameter values.

Don

Re: vb.net Parameter Default Value

Former Member — Wed, 07 Oct 2020 13:06:01 GMT

I am using Visual Studio 2019. The SDK I Installed was titled "crnet13_sp14_api_en". I looked through your code and I'm having trouble finding where you call the default value of the parameter. Can you assist?

Re: vb.net Parameter Default Value

former_member11696 — Wed, 07 Oct 2020 13:14:23 GMT

Ah, SP 13 is n ot supported in VS 2019, you need the latest SP 19 from here:

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

Uninstall first, then install just the EXE, don't install the MSI's nat required on your DEV PC.

Wiki above has all of the latest info.

Don

Re: vb.net Parameter Default Value

Former Member — Wed, 07 Oct 2020 18:05:53 GMT

I installed the latest version, SP29, Will that work as well?

Re: vb.net Parameter Default Value

former_member11696 — Wed, 07 Oct 2020 21:57:01 GMT

Yes, WIKI page tells you what versions support what versions...

Re: vb.net Parameter Default Value

Former Member — Wed, 07 Oct 2020 21:58:32 GMT

My code is working, I just don't know the syntax to pull in the default values for the parameters, where needed, in my code. Do you know the syntax to do this?

Re: vb.net Parameter Default Value

former_member11696 — Thu, 08 Oct 2020 12:59:53 GMT

As I mentioned, have a look at this project, it has routines on how to get the info:

Have a look at this test app: https://blogs.sap.com/2016/02/17/how-to-parameters-in-crystal-reports-for-visual-studio-net/

There are sites out there that will convert C# to VB... easy enough to do yourself though.

Don

Re: vb.net Parameter Default Value

Former Member — Thu, 08 Oct 2020 15:14:23 GMT

Hi Don,

Looking through the code I think this is the line that pulls in the value : getDiscreteValues(paramfield). Is this correct? Do you know if this pulls in the current values from a previous run of the report or the default value?

Re: vb.net Parameter Default Value

former_member11696 — Wed, 14 Oct 2020 13:10:17 GMT

Hi Chris,

Build the project and test it and see what the various properties of the report it gets.

It will only get what is saved in the Report, what changes/updates you make in code will not return, you'll have to keep track of them yourself.

Don