Sunday, February 12, 2012

Are there example for cascading parameters

I want to use cascading parameters for my report.
Are there example for cascading parameters?Yes you can find an example here:
http://www.databasejournal.com/features/mssql/article.php/10894_3386441_5
Im sure that if u search on google you will find more.
regards.
"ad" wrote:
> I want to use cascading parameters for my report.
> Are there example for cascading parameters?
>
>|||Yes, you can find an example here:
http://www.databasejournal.com/features/mssql/article.php/10894_3386441_5
I'm sure there are more if you do a search on google.
regards,
KS
"ad" wrote:
> I want to use cascading parameters for my report.
> Are there example for cascading parameters?
>
>|||Thank,
I had read the article, but the example can run correctly.
I thought maybe the author forget to modify the mdx for ProductData dataset:
----
--
SELECT { [Measures].[Store Sales], [Measures].[Store Cost] } ON COLUMNS,
{ Descendants([Product].[All Products], [Product].[Brand Name], LEAVES) }
ON ROWS,
{ Time.[1997].[Q1],Time.[1997].[Q2],Time.[1997].[Q3],Time.[1997].[Q4] } ON
PAGES
FROM Sales
WHERE ([Store].[All Stores].[USA].[OR].[Portland].[Store 11])
----
--
How can I modify the mdx for ProductData, so that it can link to the
cascading parameters?
"saleek" <saleek@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:9224052F-9E41-4C1B-8791-DF46A7054FCD@.microsoft.com...
> Yes, you can find an example here:
> http://www.databasejournal.com/features/mssql/article.php/10894_3386441_5
> I'm sure there are more if you do a search on google.
> regards,
> KS
> "ad" wrote:
> > I want to use cascading parameters for my report.
> > Are there example for cascading parameters?
> >
> >
> >|||Thank,
I can't find any other example aobut cascading parameters of Reporting
Servicing.
What are the keywords to serach that?
"saleek" <saleek@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:D3CB4C75-8FD7-4864-BFBD-6F299721A7F7@.microsoft.com...
> Yes you can find an example here:
> http://www.databasejournal.com/features/mssql/article.php/10894_3386441_5
> Im sure that if u search on google you will find more.
> regards.
> "ad" wrote:
> > I want to use cascading parameters for my report.
> > Are there example for cascading parameters?
> >
> >
> >|||An explanation of usage is aslo here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_interactive_v1_50fn.asp
"ad" wrote:
> Thank,
> I can't find any other example aobut cascading parameters of Reporting
> Servicing.
> What are the keywords to serach that?
> "saleek" <saleek@.discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> :D3CB4C75-8FD7-4864-BFBD-6F299721A7F7@.microsoft.com...
> > Yes you can find an example here:
> > http://www.databasejournal.com/features/mssql/article.php/10894_3386441_5
> >
> > Im sure that if u search on google you will find more.
> >
> > regards.
> >
> > "ad" wrote:
> >
> > > I want to use cascading parameters for my report.
> > > Are there example for cascading parameters?
> > >
> > >
> > >
>
>

No comments:

Post a Comment