quinta-feira, 23 de agosto de 2012 22:28
I'm going to try to get this question answered in the abstract, because I believe it is much more of a conceptual problem than a code problem.
I have two reports, 1 and 2, both based on MDX queries that have parameters set using the format: STRTOMEMBER ( @DateParameter, CONSTRAINED)
Report 1 is the top level report that has the parameter visible to the end user for selection. Report 2 is a detail report that receives the param input from a hyperlink sent over from Report 1.
In SSRS, this is easy enough to achieve (when using SQL, anyway). In the textbox properties of Report 1 under Action, I choose to link to Report 2. I then add a param to the link that is set as: Name -> DateParameter (same name in both reports), Value -> Parameters!DateParameter.value
Needless to say, I get an error message when I click on the hyperlink. It started as a problem with the Constrained clause, so I removed it. Now I get "The STRTOMEMBER function expects a member expression for the 1 argument. A string or numberic expression was used."
So, obviously SSRS is not passing a value that is understood by the MDX query in Report 2. Though, when I look at the param boxes at the top of Report 2 (once run via Report 1), they all seem to be in the correct format ( [Clinic].[Clinic].& for example).
Any advice on what to do to get these two reports talking?
Todas as Respostas
sexta-feira, 24 de agosto de 2012 03:57
We have three options
1. Passing parent parameter values to childs
2. Passiong parent uniquekey values to childs
3. Construct the MDX members using parent values to childs
1. @Paramers t0 @ChildParameters -- It depends on report requirement
2. At actions tab, we can select Parameter!X.uniquekey to @ChildParameter
3. At actions tab, construct the member "[Clinic].[Clinic].[" Parameter!X.value "]" to ChildParameter
Please use the logic suitable to your requirement.
quarta-feira, 29 de agosto de 2012 17:25
Please see if the following threads help: