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 |
|
ChrisJohnsonBarringtons
Starting Member
1 Post |
 Posted - 2011-02-03 : 10:03:43
|
| HiI am relatively new to Report Builder (I am using 3.0 with SQL 2008) I have got my head around creating various datasets and how to filter certain data out etc however I am stumped when trying to show the data in a table. I currently have the following table setup;1st Column = StaffId and its expression value is "=Fields!StaffId.Value"2nd Column = Chargeable Amount and its expression value is "=Fields!Sum_ChargeableAmount.Value"3rd Column = Chargeable Minutes and its expression value is "=Fields!Sum_ChargeableMinutes.Value"This is all set with 2 rows 1st being the header for each column (Just text) and then the above expressions in the 2nd row, now this was working fine as when the report was run it increased the table automatically and showed each staff member and there chargeable amount and minutes. Now I need to add a 4th and 5th column where I put chargeable minutes target and percent (showing how far they have got to their target) I am not fussed about the 5th column yet as I should be able to sort that but I cannot figure a way of setting a target for each person via a parameter. My original thought was create a table with say 10 rows and specify which row for each user using the same dataset something like StaffId = DS but I dont know if this can be done? If it can what would be the expression I needed? As all targets (parameters) will be different for each staff member and because with my current setup it only displays one row if I set a paramater to the 4th row it automatically fills that parameter for each row once the report is run.I hope this makes sense to someone as I am finding it hard to explain without showing a screenshot of the table and the current results I am getting, if anyone needs anymore information please let me know.I have just tried the following =Fields!StaffId.Value="DS" Thinking that would only display the results for that user however it just put FALSE in every row that wasnt his name and put a TRUE for the row the StaffId was in.So it didn't work but I thought the above might help explain what I am trying to do!Thanks in advanceChris |
|
|
|
|
|
Populating a field within a table to display a spe