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 |
|
kdnichols
Posting Yak Master
232 Posts |
 Posted - 2006-12-22 : 10:21:35
|
Hello,Here is the statement Peso gave me and It works except that I want it to put in the name of the field and only display on the last page of the report if it meets this condition.=IIf( Parameters!SummaryBy3.Value = "Vendor" AND Fields!VendorId.Value = 7, "true", "false") Can anyone help me out with this.Thanks In Advance for Peso TIA = Thanks In Advance must use Telekenesis now!Merry Christmas Kurt |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-22 : 11:14:27
|
| Is this what you want?=IIf(Parameters!SummaryBy3.Value = "Vendor" AND Fields!VendorId.Value = 7, Fields!VendorName.Value, "")Peter LarssonHelsingborg, Sweden |
 |
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2006-12-22 : 11:20:59
|
| Hello Peso,Yes that is just about it. It is not displaying the name also in that same row I want it to perform calculations based on that VendorId value.I have a row of calculations that need to be executed for instance this one which is Lead Count = =Count( Fields!ProviderId.Value) and many others on the same row. I am sorry if I am not being clear enough.Again many thanks!I think we are almost there!Kurt |
|
|
|
|
|
|
IIf Condition how to print only this condition