Solved

Reporting services Calculating whole numbers.

Posted on 2008-10-29
1
196 Views
Last Modified: 2008-10-30
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.  
0
Comment
Question by:tjwent69
1 Comment
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 50 total points
ID: 22836636
does 'mod' work? Other languages often uses mod or modulus
 
0

Featured Post

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question