Report prints different from different machines - VB6

[rich914]

Have a report that prints differently from different computers all going to HP printers.

Have some 30 reports and this is the first one to do this. Also it is one of two that I had to draw a bar graph around the data using the line tool with page header b (column headings) and report footer colored light grey.

The grey shading extends beyond the normal print range and the last line down the right side does not print.

Also in the heading am using a formula to print the year within text. It is returned differntly also. Some machines print 2,003.00 while others print 2003.

Printing the report through VB6 using the CRViewer via Access stored procedure query with program passing parameters.

Any suggestion / help would be appreciated.
Thanks

 

[SurfingGecko]

For the printer issue you may want to have a look at the following KBase for an idea of how important the printer driver is. YOu may need to redesign the report a bit to make it 'universally friendly'

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scrprinterdependency.pdf.asp

As for the number formatting, this looks like a Regional Setting issue on the client machines that is deciding the format. Running into this can be a drag so , I have tried to implement the following formula to supercede

For each of your number fields add this formula --

ToText({number_field},0,"&quot

This will force 0 decimals with not separator



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[rich914]

Actually it appears to be a computer software/hardware problem. Two different computer printing to the same HP printer, prints the report different.

One computer (which has VB6 ED & CR8.0 Pro installed) is newer faster cpu, and has more memory than the older other. Both running win98 on a novel 6.0 network.

On the same network another computer sort of in between the two, also has the same problem printing to 2 additional HP printers.

Still at a loss?

 

[SurfingGecko]

Going back to what I mentioned earlier. Add the ToText function to force your numbers to show without decimals or separators.

Also make sure all computers are using the SAME printer driver. Same printer does not mean the same driver is being used.

Incidentally, the printer would not be dictating this formatting anyway. This is a regional Setting or field formatting issue.

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[rich914]

Not sure why, but I had to take your suggestion a step further to make it work consistently.

ToText (Year ({?Datevalue}),"####", 0, "", "&quot