all groups > sql server reporting services > may 2006 >
You're in the

sql server reporting services

group:

Parameters


Parameters André Mattos
5/24/2006 1:28:01 PM
sql server reporting services:
Hi !

How come i pass olap parameter to my subreport?

I have two reports and i'd like link these reports by parameters, but when a
put parameter to link the value doen't pass to subreport.

I use SSAS 2005 and my parameters are dimension of my cube.

Help me !!!!

Thanks.
--
Re: Parameters André Mattos
5/26/2006 10:49:02 AM
Tim,

Thanks, now work well.


André Mattos
--
Mattos


[quoted text, click to view]
Re: Parameters Tim Dot NoSpam
5/26/2006 12:21:43 PM
Create a custom member in your "parent" report. Example:

If you had the ReportDate attribute of the [Time] dimension in your report
and it needed to be passed to the sub-report, you'd create a custom member
with the definition

'[Time].[ReportDate].CurrentMember.UniqueName'

This would return something like
'[Time].[ReportDate].&[2006-05-26T00:00:00]'.

When you've added the sub-report, make sure you set up the parameters for it
too. They can be either parameters in the primary report or they can be
field values.


[quoted text, click to view]

AddThis Social Bookmark Button