Hello, Is this query for the Match Parameter? Change the query as Select matchid,matchname,username from match where username = (@username) And Make sure that the username parameter name is username
If you are using SSAS for your datasource, you need to add a dataset for your parameter. In the Report Parameters prompt of your reporting project, check the "From query" radio button, choose the DataSet you created for the parameter values, and assign the
value field, Label field with the fields exposed by the Dataset.
For Dataset, you need to use MDX expression. For example,
WITH MEMBER [Measures].[ParameterValue] AS '[Dimension].[YourField].CURRENTMEMBER.UNIQUENAME' SELECT {[Measures].[ParameterValue]} ON COLUMNS , [Dimension].[YourField].LASTCHILD.lag(6) ON ROWS FROM [User State]
chandumadhav...
Member
316 Points
77 Posts
Re: how to retrive selected parameter label of SSRS using .net
Jan 29, 2009 03:24 AM|LINK
Hi shilpa
Still its not working. the match dimension query is not recogizing the "where" condition. i have writen as follows
Select matchid,matchname,username from match where username = ''' + @username + '''
Any help
Regards,
Madhavi
ShilpaReddyA
Participant
1084 Points
137 Posts
Re: how to retrive selected parameter label of SSRS using .net
Jan 29, 2009 04:41 AM|LINK
http://www.gmail.com
chandumadhav...
Member
316 Points
77 Posts
Re: how to retrive selected parameter label of SSRS using .net
Jan 29, 2009 11:22 AM|LINK
hi, the dimension (in SSAS) is not accepting Select matchid,matchname,username from match where username = (@username) this format of query.
Am i not understanding your approach. please let me know.
Nai-Dong Jin...
All-Star
41630 Points
3558 Posts
Re: how to retrive selected parameter label of SSRS using .net
Feb 02, 2009 06:46 AM|LINK
Hi,
If you are using SSAS for your datasource, you need to add a dataset for your parameter. In the Report Parameters prompt of your reporting project, check the "From query" radio button, choose the DataSet you created for the parameter values, and assign the value field, Label field with the fields exposed by the Dataset.
For Dataset, you need to use MDX expression. For example,
WITH MEMBER [Measures].[ParameterValue] AS '[Dimension].[YourField].CURRENTMEMBER.UNIQUENAME'
SELECT {[Measures].[ParameterValue]} ON COLUMNS , [Dimension].[YourField].LASTCHILD.lag(6) ON ROWS FROM [User State]
Thanks.