Change data type of parameter from number to text

[Anonymous]

Hi All,

I have created a parameter on Posting Period: Values for posting period are 001,002,003,.........011,012.

When I create a parameter and enter the current value ass "001" and click on OK, it changes to "1".

The data in my database is 001 and passing just 1 is giving me an error.

I need to change the parameter data type to Text(ABC) rather than whole number(123) to accept 001 as value and pass to the DB to fetch the data.

Can someone please let me know how to achieve this?

Thanks

Poojitha

[Icey · Accepted solution]

Hi @Anonymous ,

When you create "Posting Period" parameter, it is needed to change the type to "Text", not "Any".

You can modify the type according to the following steps:

1. Manage Parameter.

2. Change the Type of Parameter from "Any" to "Text".

3. Enter "001" to current value.

4. OK.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.