crviewer9 not formatting numbers same as report

[miller201]

Hi. Just upgraded to version 9 viewer, but some clients still viewing 8.5 reports. With new viewer, number format for year is showing up as 2,003 instead of 2003 as it does if you look at report in Crystal itself. I know I can create a formula to get around this, but I have a ton of reports that would need modification.

Isn't there a way around this w/in my VB app? For example, is there any way to specify the style to use for all number formats in the given report, or for a particular field?

Using CRAXDRT9.DLL & CRVIEWER9.dll.

Any help is appreciated.

Thanks!

 

[IdoMillet]

I just tested what you are describing using my own 9.0 Viewer application and I can't replicate the problem.

I saved a CR 8.5 report with a Year formula being formatted with no decimals and no commas. I then opened this report in my DataLink Viewer and the formula shows correctly just like in the 8.5 Crystal viewer.

Is it possible you are opening two different copies of the report?

Cheers
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[miller201]

Thanks for responding so quickly! Unfortunately, it's definitely the same report. Not sure if it makes a difference, but this is a number field that happens to represent a year value, not a formula within Crystal. It's using ODBC to pull from a SQL Server database (a view, not a table, if that matters).

 

[IdoMillet]

Connections mechanism to SQL server has been changed in CR 9 if memory serves. Do a quick search on CD web site and you should be able to find a description...

hth,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com