| Author |
Topic |
|
Ludwig
Starting Member
9 Posts |
 Posted - 2008-11-17 : 16:11:17
|
| Hello,I have two simple reports based on a ssas cube.report 1:Shops as filter and month and revenue as columns within the report.report 2:Month as filter and shops and revenue as columns within the report.Now, I'd like to click on a month in report 1 and jump to report 2.Report 2 should display the selected month value already in the filter.. The user would just execute the report2 and see the revenues for all shops in this selected months.Anybody with the same issue?I did not get it to work. Yes, it jumps to the other report but I still need to select the month value within the filter.If I deploy it to Report Server and execute the reports there it will error with unknown Parameter name.Fun stuff,Ludwig |
|
|
tpoulos
Starting Member
3 Posts |
Posted - 2008-11-17 : 16:57:17
|
| I have a similar report that shows charts of various financial figures and allows the user to jump to the detail by clicking on the appropriate bar column in the chart. The overall report is already filtered to a specific date, so on the 'Jump to report' parameter settings I reference that parameter like this:Parameters!PrintedDate.ValueDoes that answer your question? |
 |
|
|
Ludwig
Starting Member
9 Posts |
Posted - 2008-11-17 : 23:44:09
|
| I'll try...Do you use a cube as a data source?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-18 : 00:19:47
|
| what were navigation expression used? |
|
|
|
Ludwig
Starting Member
9 Posts |
Posted - 2008-11-18 : 14:59:14
|
| Ok, my first approach wasn’t the right one…On report 1 I put the jump action on a textbox to jump to report 2 and pass the parameter.Report 2 has a list as a data region. In the properties of the list field I used a filter to make the dataset dynamic. I also need a report parameter but I activate the hidden check box in the report parameters dialog. This way it’s not going to appear when I call report 2 from report 1.Now the user jumps from report1 to report2 and is right within the detailed data/chart.Take care… |
|
|
|
mvanwyk
Yak Posting Veteran
99 Posts |
Posted - 2009-08-28 : 10:14:13
|
| Can you guys please help me out.I'm also having the same issue.Please post your resolution. |
|
|
|
lover143
Starting Member
2 Posts |
Posted - 2011-11-13 : 02:03:40
|
| Hi Ludwig/Visakh,I have just started to use ssas and creating my first navigation report. I am getting error that "parameter is missing value" when I try to navigate from Report 1 to Report 2 (when I click on the field/link). I did set Available and Default values in the Report Parameters Properties of the Report 2. I also kept these fields hidden in the second report. I am trying to how do I make it dynamic though?FYI: I have 3 columns in the first report. Column 1 and Column 2 are hidden and Column 3 is visible. When I click on Column 3, it should pass Column 1 and Column 2 to the Report 2.On the Report 2's report parameter dataset, it does show the hidden columns too in the drop down, but it doesn't work when I run!Please advice... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-13 : 12:05:06
|
quote:
Originally posted by lover143
Hi Ludwig/Visakh,I have just started to use ssas and creating my first navigation report. I am getting error that "parameter is missing value" when I try to navigate from Report 1 to Report 2 (when I click on the field/link). I did set Available and Default values in the Report Parameters Properties of the Report 2. I also kept these fields hidden in the second report. I am trying to how do I make it dynamic though?FYI: I have 3 columns in the first report. Column 1 and Column 2 are hidden and Column 3 is visible. When I click on Column 3, it should pass Column 1 and Column 2 to the Report 2.On the Report 2's report parameter dataset, it does show the hidden columns too in the drop down, but it doesn't work when I run!Please advice...
is any of parameter in first report of multi valued type?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
lover143
Starting Member
2 Posts |
Posted - 2011-12-11 : 16:08:51
|
| Yes. It is multi-valued. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-12 : 00:01:06
|
quote:
Originally posted by lover143
Yes. It is multi-valued.
if its multi valued the problem is in the way it passes the parameter selected values internally. you need to write a custom code function to transform selected values to correct format as expected by the MDX queryie for dimension Dim with Level 2 if you've selected three values val1,val2,val3 it should go as{[Dim].[Level].[&Val1],[Dim].[Level].[&Val2],[Dim].[Level].[&Val3]}------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Jump to report/ SSRS