Do not want Comma in the drop down of my dynamic Parameter

[Former Member]

Hello All,

I have a dynamic parameter on year and the database values are

2007

2008

2009

But when the user selects from the drop down box it displays with a comma as a seaprator in thousands like

2,007

2,008

2,009

Please suggest me how can i remove this comma in the drop down box.

Thanks

Robinn

[Former Member · Accepted solution]

Try to convert the numeric values to a string or varchar and check the values. By default the numeric fields take the default system format.

Regards,

Raghavendra

[Former Member · Accepted solution]

Thanks for your reply Raghvendra, but can you pls tell me where should i convert?? I vcannot edit the parameter as it is dynamci so where should i do this conversion

[Former Member · Accepted solution]

Since it is a dynamic parameter you can try creating LOV using Business View Manager or try to create a new report using add command and use the query with convert function and try to create a dynamic parameter using the field in the report. If the format is fine then try to save the report to server which will automatically generates LOV in the repository.

Regards,

Raghavendra.G

[Former Member · Accepted solution]

Thanks Raghvendra,

I am working on an existing report with Oracle as a database. So what I understand is I should create a new LOV in business view manager and then use that one in my dynamic parametre. Pls let me know if i understand correctly.

Thanks a lot

[Former Member · Accepted solution]

Yes!! you are right , you need to create LOV using Business View and use it in the dynamic parameter. This is useful whenever you want to apply filter condition for LOV or formatting chnages. Because by default it takes the filter condition that is used in the report datasource (not record selection condition) as a command.

Regards,

Raghavendra

[Former Member · Accepted solution]

OK thanks Raghvendra