Reporting services Calculating whole numbers.
Posted on 2008-10-29
Hello, I usually try to do my report queries in T-SQL then use them in reporting services but I find myself unable to do that with an access database I am working with.
Here is what I am trying to figure out in Reporting servies 2005, for an expression. Calculate cases and bottles sold. Data is stored in Bottles.
I would do the following in T-SQL
QtySold (13) % BottlesPerCase (12) as Cases
QtySold (13) / BottlesPerCase (12) as Bottles
My two columns would be 1 case and 1 bottle. PERFECT
In my Reporting services I have all of the same elements for the calculation but % is unknown to the expression editor. I am sure that its probably a funtion but the descriptions are not helpful enought to make be use them.