cancel
Showing results for 
Search instead for 
Did you mean: 

Formating in a Parameter

Former Member
0 Kudos

I have two dynamic parameter prompts that I want to modify.

One hits a SQL date field and, when the dates appear in the user selection list, then are in the long SQL format with full date and time 2002-06-01 00:00:00. I want it to appear as just the 2008-06-01. Can that be done.

Also, I have a place where the "year" is in a number field -- eg. 2008. But when the parameter is selected, I see 2,008. I'm looking for a way to remove the comma.

Help appreciated -- general principles will probably suffice.

Ridge (in New Joisey)

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

if you want the parameters to be displayed in such format try to convert them at the database level using convert function and add the query to the report using add command and try creating the parameters from this command instead of creating from the existing tables.

Regards,

Raghavendra

Former Member
0 Kudos

Thank you. R.