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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-11-20 : 17:52:49
|
| In an existing SSRS 2008 report, I have the following "IIF(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", "White")" for the background color for every other detail line row.Basically one detail line is white and the next detail line is a light green color.Now the user wants every other detail line to remain white and light green color when displayed on the report server. However when the report is to be exported to excel,the user wants all lines exported to excel to be completely white.Here are the steps the user will complete:? The user will select ‘Hide’ from the ‘Excel Export_Hide Headers’ dropdown list. ? The user will next select the view button prior to exporting the report to excel.? The user will then select the export to excel option.**The user is basiscally going to hide the header rows when the report is suppose to be exported to excel..When the header rows are are being hidden, the following logic is being used: "iif(Parameters!ExcelToolbar.Value = 0,false,true)".Thus can you tell me how to tie the "iif(Parameters!ExcelToolbar.Value = 0,false,true)", with the "IIF(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", "White")" statement?Would this be nested iif statements? If so, can you tell show me how to setup the applicable nested iif statements? If this is not the solution, would you show me in code, explain to me, and/or point me to a url that will solve my problem? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-21 : 01:07:18
|
| =IIF(Parameters!ExcelToolbar.Value = 0,IIF(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", "White"),"White")------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-11-21 : 11:30:01
|
| Thanks! |
|
|
|
|
|
|
|
|
SSRS 2008 using iif statements together