Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slackbladder
Starting Member
1 Post |
 Posted - 2011-12-09 : 08:55:54
|
| Hello Forum,Fairly new to SSRS so I am hoping this is an "easy" fix for a problem I am having....I have two datasets, one data source in a report.One dataset issues a query to figure out the number of rows in a table (count)The other dataset figures out the total number of rows (count) that match a specific criteriaI am trying to use the ".value" property of each item to work out the percentage that the matched number represents versus the total number of recordsExamples below"Total number of records" "Total number of matched records" "% matched versus total""883" "24" "2.718"The problem I am having is that when I enter the calculation in the expression field for the third item (in this case a text box) =sum(field!FIELD02.value)/field!FIELD01.value)*100 the first section is underlined in red, which means it's invalid. The thing is, I don't actually type this in and use the GUI to select the value.Can I use the .value results in a calculation like this ???Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-09 : 10:08:42
|
| you can use it. try it first without worrying about red line and see if it works------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Applying calculations to the .value of a field