March 31, 2011 at 12:30 pm
I don't know for some reason Divide "/" in my SQL statement pulls empty in SSRS report. For example 2/3 in my SQL gives empty in SSRS report. I have aliasing for 2/3 just so you know.
Is there any setting or something. It's weird. Someone please help me. Thanks.:-D
March 31, 2011 at 1:00 pm
Can you please show the entire expression that is not working?
One other thing to be aware of, in T-SQL depending on your data types 2/3 will result in zero in many cases. Do you have any special handling in SSRS for a value of zero?
March 31, 2011 at 1:24 pm
select 2/3 tru from dual
Its not T-sql its oracle. Thanks.
March 31, 2011 at 2:12 pm
When you execute the dataset in SSRS, not the report itself, just the dataset, what is returned?
March 31, 2011 at 2:17 pm
I opened the dataset and clicked on run and it went through. When i run this in Toad it gives me the result.:-D
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply