March 17, 2011 at 8:43 am
In my SQL in have column "(s.rate/r.num_period) rate". This is showing blank in the output of SSRS. Is there any thing that i need to change i mean properties of that column. Please help.Thank you.
March 17, 2011 at 9:10 am
you can try using expression 4 / 2.
That will tell you if you have some sort of display issue.
If that works, change the 4 to the first column and test again.
If that works, then change the 2 for the other column and see what is your format expression. You could use N0 to make sure to see some figures.
The other explaination is that nulls don't display unless you force it with a cast.
March 18, 2011 at 6:28 am
Did you missed adding .Value at the end? One quick check
Measure.Value
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply