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!
-
Hide zero value
[thanks2] I told you I am sql challenged, I will remember this in the future. Appreciate the help.- CarrieRo
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Hide zero value
Frederico, this did not work. Now no records are being returned. I just need the rows that randomly will be blank in both the Base charge and Misc charge columns to not show up. If either one is populated it should show up. & thx for the NOLOCK info.- CarrieRo
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Hide zero value
In the following code, I can't figure out how to hide 0 values. The created fields of 'Base Charge' and 'Misc Charges' in some instances are all 0. The four rate descriptions, Base Rate, Fuel Surcharge, Pieces and Weight you will see repeated for each job #. Some of these are 0 on the base...- CarrieRo
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Hide zero value
In the following code, I can't figure out how to hide 0 values. The created fields of 'Base Charge' and 'Misc Charges' in some instances are all 0. The four rate descriptions, Base Rate, Fuel Surcharge, Pieces and Weight you will see repeated for each job #. Some of these are 0 on the base...- CarrieRo
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Reporting Services
