<div>
<div class="content wysiwyg-content">
Hello, &nbsp;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.<br />
<br />
Here is what I am trying to figure out in Reporting servies 2005, for an expression. &nbsp;Calculate cases and bottles sold. &nbsp; Data is stored in Bottles. <br />
<br />
I would do the following in T-SQL<br />
<br />
QtySold (13) % BottlesPerCase (12) as Cases<br />
QtySold (13) / BottlesPerCase (12) as Bottles<br />
My two columns would be 1 case and 1 bottle. &nbsp;PERFECT<br />
<br />
In my Reporting services I have all of the same elements for the calculation but % is unknown to the expression editor. &nbsp;I am sure that its probably a funtion but the descriptions are not helpful enought to make be use them. &nbsp;<br />

</div>
</div>


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.  


Reporting services Calculating whole numbers.

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.