formatting a parameter input value

[unknownly]

Hi All,

Iam using Crystal version 8 which comes with Peoplesoft. Reports are intergrated with peoplesoft using a Page in Peoplesoft( report are run using that page)

Users enter input values in the parametres on the page and the values enter are stored into a special table in Peoplsesoft(oracle database). We developers using the special table in the Peoplesoft Queries and designing the reports to run accordingly to given users input values
the fields in the special table are varchar type.

My users wants to see a format when they enter a value.

or eg: they want to see has

? filter amount :1,000,000

right now it shows as:

? filter amount :1000000


Can anyone of you please help me how can I do this.

Thanks in advance,

Sweetie

 

[hilfy]

If you're talking about the value the user enters on the page, you'll have to go to PeopleSoft to get that information.

If you're talking about the value on the report, you just have to format the number to include the commas. Right-click on the formula in the report, select Format Field and then select the Number tab. Choose one of the formats that has commas already in it. (This assumes that the parameter format comming from Oracle is a number.)

-D