My report is connected to a stored procedure. In Field Explorer there is an integer column which is not insert on the report but it is used as a query string parameter when a hyperlinked field is clicked on the report.
This integer field, RecNo, is coming to Field Explorer in the format: #,###. I don't want to use comma and want to use a number like: ####.
rpk2006
Member
631 Points
629 Posts
Numeric field appearing with comma in report even after custom formatting
Jan 12, 2012 10:55 AM|LINK
My report is connected to a stored procedure. In Field Explorer there is an integer column which is not insert on the report but it is used as a query string parameter when a hyperlinked field is clicked on the report.
This integer field, RecNo, is coming to Field Explorer in the format: #,###. I don't want to use comma and want to use a number like: ####.
How to truncate comma?