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 |
|
mfemenel
Professor Frink
1421 Posts |
 Posted - 2008-05-02 : 10:19:30
|
| After many years of sql2k I'm finally sitting down with 2005 and reporting services to knock something out and I'm hoping to find 2 helpful things here.1. Does anyone have a good reference or link to the properties of the different collections in reporting services? Specifically looking for the different items available within the fields collection.2. In my report I have a table and am creating a heading based on a formula. Let's say for simplicity sake the formula is Now()-1. Well the data source for that column is a field in my db called pkgExec01. As the headings go off to the right I need to adjust my formula to be -1, then -2, then -3 etc and the field names coincide pkgExec01, pkgExec02, pkgExec03. Instead of changing the formula manually what I would like to do is refer to the name of the data field and get the right 2 values and subtract it from Now() in my column heading. So my forumula for the heading would look something like =Now()-right(datafieldname,2). This would make it a lot more dymnamic.Mike"oh, that monkey is going to pay" |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-02 : 13:53:02
|
| 1.http://msdn.microsoft.com/en-us/library/ms157274.aspx2.I think this is what you're looking at=Now()-Cint(Right(Fields!YourDataField.value,2)) |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2008-05-02 : 14:27:08
|
| Perfect on both. Thank you.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Fields References