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 |
|
martino
Starting Member
2 Posts |
 Posted - 2011-08-05 : 05:26:28
|
| Hi,I am using SSRS 2008 and design reports in Visual Studio based on SSAS cube. I often use following expression to drill-down data from cells using "Go to report":for ParameterDBCountry in another report expression: =iif(inscope("matrix2_DB_Country"),Fields!DB_Country.UniqueName,Parameters!DBCountry.Value)That works ok. There are usually many parameters like that in one "Go to report" action. Once set for one cell I would like to copy the set of parameters to others cells. Usually in matrix all cells can contain the same set of parameters. And re-entering all parameters is very time cosuming. Now 2 issues I met and cannot find a right way:1. Is it possible to copy and paste only Action property from one cell to another not to loose other settings like expression or format? I mean in design view.2. When I copy and paste the whole cell the expression in parameters is corrupted - actually the string defining scope in inscope() function ("matrix2_DB_Country") is always lost. So that the expressions is transferred to:=iif(inscope(),Fields!DB_Country.UniqueName,Parameters!DBCountry.Value)I know I can modify the report on code level, but it is also not too convenient.Any clue how to solve that? |
|
|
martino
Starting Member
2 Posts |
Posted - 2011-08-17 : 02:59:55
|
| ad2) I found quite a usefull workaround:If a string in the inscope function is complex then it is not lost after cell is copied to another cell.=iif(inscope("matrix2_DB_Country" & ""),Fields!DB_Country.UniqueName,Parameters!DBCountry.Value)Another input concerning ad1) ? |
 |
|
|
|
|
|
SSRS 2008 - copy and paste action "Go To Report"