Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

InfoView Paramters

Status
Not open for further replies.

kskid

Technical User
Mar 21, 2003
1,767
US
CR XI on Oracle DB using Oracle ODBC Driver.

Is there a way to set the format of numeric parameters that appears in Infoview? The nummeric parameters that appear in the history screen are displaying as 111,222,333.00 insead of 111222333.

I don't want the thousand separators and the decimal.

-lw
 
Hi,

I get around this by creating a numeric parameter - export the pick list into a notepad document to remove the ".00" and then reimport it back into a new string parameter.

Then I do the conversion from string to number in the record selection - messy I know but it works.

If you are using dynamic parameters - you could do this in the report using a formula - as XI stores the dynamic picklist in a Crystal Report.

Cheers
paulmarr
 
Rats! I was hoping for an easier solution.

-lw
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top