January 31, 2008 at 12:08 pm
Hi,
I have created a report which returns count of records in 20 columns .Created individual dataset's for each separate column.The query within the dataset does a SELECT count of records based on certain criteria.I have formatted the textbox[where the dataset value is returned on the report], Formatcode to = "##,###" as I wanted the value to be returned in this format, example :- "111,233".
All was well..till .I had datasets that has 0 value.This value was not returned on the report as "0" but rather just blank.If I were to remove the textbox formatcode of "##,###", 0 is returned.I need to keep the formatcode of "##,###" as that is required by the users and column counts change from time to time, therefore it would be silly to remove formatcode of "##,###" for all those blank values textbox for now.
Can anyone out there give me a solution for this ?
Problem is , Iff value of dataset is "0", returned "0" ELSE return the value, while having the formatcode of "##,###"
I know my Topic is pretty long, but I just wanted to make everyone understand my problem.Thank You in Advance !
[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]
January 31, 2008 at 12:21 pm
Can you give an example of one of your counts?
The Count(*) in T-SQL always returns a value, even if 0, so i am curious how you're coming up with your counts.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 31, 2008 at 12:48 pm
My SELECT COUNT(*) does return a "0",when the column has no records.
Tested in SSRS[data tab] and Mng Studio.
Problem arises when the value of dataset is displayed in a textbox, where the textbox Properties>Format>Format Code is "##,###".
[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]
January 31, 2008 at 1:18 pm
Ah - took a second to visualize what you're looking at.
If you change the format to ###,##0 it won't suppress ALL of the digits if something has a value of 0. 0 represents a non-optional/non-suppressible digit. If you put in ###,000 it would always return 3 digits (even if the first first is 0).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 31, 2008 at 1:32 pm
Thank You Matt....Tried with "###,##0" & works fine....
Never thought of that:Wow:
[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy