Programmaticaly set default values for filter params in C#

[Former Member]

Hi

In my application i would like to programmatically (in C#) set default values for parameters/ report filters. The user should then be able to choose a different report parameter if he needs to. (for example: set the start date to today if some critera is met)

However, if i do his in code, the parameter filter is no longer displayd when the report is shown. It seems to me that crystal reports assumes that the value for the filter parameter is already set. However, i just want to set the value that is shown in the filter control, the user should be able to choose a different filter value.

Is it possible in crystal reports to set the default value programmatically (in C#)???

Greetings

I am using:

Crystal Reports 2008

Version .NET 3.5 (SP1)

[Former Member · Accepted solution]

Hello, Daniel;

Are you using Crystal Reports Basic for Visual Studio .NET 2008 (10.5) or full Crysatl Reports Developer 2008 (12.0)

Yes, you can set Default values at runtime. I found two examples for you:

Check this SAP [Note|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_boj_erq/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes.do]

There is also a Web or Windows application example called "CS_Web_RDObjMod_Parameters" or "CS_Win_RDObjMod_Parameters" in the tutorials:

[Click Here|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b07a158a-b766-2b10-a79e-bfc6d19c6b99]

This passes the default values to the ReportObject. How are you accessing the default values for your client? Are you using our viewer prompt?

Elaine

[Former Member · Accepted solution]

Hi Eliane

Thanks for your very helpfull support.

We are using Crysatl Reports Developer 2008 (12.0).

Previously, we tried to modify the default value as follows via the SetParameterValue method, but from the link you posted, i see now that this could never work.

I changed my code as suggested and it works well for all non-dynamic filter values. Thank you very much.

There are still some minor obstacles but i am working on it:

-It seems to me that it is not possible to set default values if the filter params are dynamic (i recieve the following message: "Dynamic parameters cannot be modified...". ). Maybe it is possible to just select the first dynamic filter value that is found.

- when i try to set start date programmatically, the gui adds a dropdown, with the default value but the actual date picker drop down, remains empty. I hope there is a solution for this.

However, thank you very much for your support

Daniel

[Former Member]

Hi

As i mentioned in my last post, i still have some problems with setting default filter parameter values programmatically. To set these default values, i use the following (or a similar) code snippet:

private void SetCurrentValuesForParameterField(ReportDocument reportDocument, ArrayList arrayList)
		{
			ParameterValues currentParameterValues = new ParameterValues();
			foreach (object submittedValue in arrayList)
			{
				ParameterDiscreteValue parameterDiscreteValue = new ParameterDiscreteValue();
				parameterDiscreteValue.Value = submittedValue.ToString();
				currentParameterValues.Add(parameterDiscreteValue);

			}
			ParameterFieldDefinitions parameterFieldDefinitions = reportDocument.DataDefinition.ParameterFields;
			ParameterFieldDefinition parameterFieldDefinition = parameterFieldDefinitions[PARAMETER_FIELD_NAME];
			parameterFieldDefinition.ApplyCurrentValues(currentParameterValues);
		}

In most cases, this works fine. However, the following issues remains:

- no default value can be set dynamic filter params. This is ok for me(us): However, it would be nice, if one could just choose the first retrieved dynamic value as default value. However, this is not a high priority task for us.

- Setting default values for dates seems to work a bit strange. Having set a default value programmatically, an additional dropdown appears where one can choose the passed default value. This is not what we would like to have. We would rather have the default value being set in the date textbox. Is this somehow possible?

Greetings and thanks in advance.

Daniel

[former_member11696]

Don't use the Add method and use this one:

reportClientDocument.DataDefController.ParameterFieldController.SetCurrentValue("", @"Your Parameter Name", @"Your Parameter Value");

Using the Add method adds a new parameter which will fail because thename already exists.