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 |
|
Les.61
Starting Member
49 Posts |
 Posted - 2010-05-11 : 01:19:09
|
| I have a report where i want to report all accounts but want to also place a symbol in a column if a date in a cloumn is gretare then the report parameter date.The report would be run and the operator selects the date is 1st April 2010. If the date in 'Tag' column is greater then or equal to that date the report should place '***' in the column.I have tried using the expression =iif(tag > @date_entered, "***", " ") but it does not work.Any suggestions? |
|
|
Les.61
Starting Member
49 Posts |
Posted - 2010-05-18 : 21:19:34
|
| I have used a work around with a 'case' in the initial query. |
 |
|
|
|
|
|
Using Report Parameter in IIF in SSIS