July 21, 2008 at 3:43 am
Hello I have developed a report, and when i run the report there are some certain fields which dont display any form of data.
For example the Qty returned box, it appears blank because of the fact that there is no data from that particular field from the data source itself, secondly in the total cash field, the £ symbol appears alone if there is no value in the field from the data source.
What I will like to do is have the figure 0, in the Qty returned box if there is no items returned, and the currency figure of £0.00 if there is no value?
Can anyone help?
July 21, 2008 at 12:49 pm
The best way to deal with this is to ensure that your dataset always returns a zero value even when there is no data in the column, currently you will have something like:
SELECT Qty, Amount FROM tablename WHERE........
You should use the following to ensure zero's are returned:
SELECT ISNULL(Qty,0), ISNULL(Amount,0) FROM tablename WHERE......
Good luck,
Nigel West
UK
July 22, 2008 at 10:56 am
Actually you should just check your format statement. Use "#0" instead of "#" and "£#0.00".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply