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!

Upgrade to Version 9 and now zeroes are blank

Status
Not open for further replies.

chaverly

Technical User
Sep 24, 2004
18
0
0
US
I just upgraded from CR 8.5 to 9.0 this AM. My datasource is SQL Server.

In version 8.5 I have Running Totals of the number of Date fields as a Count.
Count of VRG VRN VSE Total
0 0 1 1
1 2 2 5

Now my report is coming out as

Count of VRG VRN VSE Total
1 1
1 2 2 5

I selected File -> Report Options and checked the Convert Database Nulls and Convert Others selection.
In the File -> Options I selected the Fields , Number, Number option and set Show zero values as 0. Counts are calculated in a Subroutine.

No zero fields are showing up at all.
 
I figured it out by myself. I had to open the subroutine and apply the changes in the subroutine including the File -> report Options and checked the Convert Database Nulls and Convert Others. Then I selected each Running Total field and selected Format Objects -> Number, Number, Custom and set zero to 0. It would not work just doing this in the Main report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top