Modify a parameter field value

[Former Member]

Hi,

Is it possible to modify a parameter field value after user's input in CR 2008 by using a formula?

I'm trying:

{?[!V000036]} = "[CALMONTH].[200905]" and

{?[!V000036]} := "[CALMONTH].[200905]"

but none is working.

Is it possible in any other way?

Thanks and best regards,

David.

[fritzfeltus · Accepted solution]

You could assign the value of your parameter to a variable and modify it. What do you want to do with the modified value?

[Former Member · Accepted solution]

Thanks for your reply.

My intention is to dinamically modify a parameter value, like a "current day" parameter.

But I'm not able to assing a value to a parameter in a formula.

Best regards,

David.

[fritzfeltus · Accepted solution]

You cannot assign a value to a parameter field. What do you want to do with the parameter's value? Are you using it within a Selection Formula? Please explain the workflow of what you are trying to achieve, so we can come up with some suggestions.

[Former Member · Accepted solution]

My scenario has to do with an OLAP universe based on a SAP BW Query.

My parameter {?[!V000036]} is a BW Query parameter.

I would like to be able to execute this webi document and set this parameter dinamically, without needing to ask it to the user.

But if you say that parameter values can't be modified, then my solution won't work.

Thanks and best regards,

David.

[Former Member · Accepted solution]

Any other suggestions?

[former_member292966 · Accepted solution]

Hi David,

Inside Crystal you cannot reassign the parameter field value. If you plan to call the report from an external application you do have the ability to do this programmatically but only once, after the report is opened.

It sounds like you want to have the parameter change between records and that's not possible. Using a formula to evaluate the parameter and return a valid value would work in place of the parameter. So something like:

If {?Parameter} = 1234 Then 
   1235 
Else {?Parameter};

You can then use this formula almost anywhere you would use your parameter.

Good luck,

Brian

[Former Member · Accepted solution]

Hi Brian, thank you for your reply.

The problem is that I won't filter anything on my crystal report with this parameter, parameter value is used to execute BW query and return results. If I'm not able to change this parameter before BW query is executed, I don't see how can I use it only on CR.

Thanks and best regards,

David.