Last post Aug 08, 2011 11:26 PM by You-Hu Fu
Aug 04, 2011 03:07 AM|manohar.k|LINK
Iam new to this (ssrs report generation)application.Iam feeling trouble in the dropdown.
1) Actually In dropdown the values are not getting. How to get the values into the dropdown.If there is any process PLZ tell me. iam using Visual studio of 2008 and sql server of 2008.
2) And If the value is selected in the drop down how we can those particular fields only.
Aug 04, 2011 03:17 AM|MayankArora|LINK
<asp:DropDownList ID="valueList" runat="server">
<asp:ListItem Value="1" Text="abc"></asp:ListItem>
<asp:ListItem Value="2" Text="xyz"></asp:ListItem>
I think you wants the selected value of drop down list.
use valueList.SelectedItem.Value for geting value
or use valueList.SelectedItem.Text for geting text.
Let me know incase.
Aug 04, 2011 04:35 AM|manohar.k|LINK
Hi Mayank Arora,
Thank u for giving me reply. Actually in the ssrs report They wont like that, there will be some process.
Aug 04, 2011 04:39 AM|Nishantg|LINK
I think you are talking about the parameters, for this you need to follow the below given steps.
1. Take a new data set and fill it with the probable value for your dataset.
2. Goto your parameter, which you want to display as a dropdown, there select the Available Value property, and then select Value from Query. This will give you option to choose the Dataset, select the dataset and then your display field and value field.
3. Now, when you run the Report, the parameter will display like a dropdown.
4. It will work like normal parameters. Like in query you can write like the following
Where Value = @YourDropDownParameterName.Value
I hope this will help you. Fell free to ask if you have any doubts.
Aug 04, 2011 05:13 AM|manohar.k|LINK
Iam new to this application. iam sending screen shot ,PLZ find the attachment. In the below screen u find the dropdown,but i dont know the procedure
plz find the screen shot.
Aug 08, 2011 03:48 AM|Nishantg|LINK
I seen the screen shot, and it seems that you are not supplying any value for this parameter. You need to follow the steps I discussed in my earlier post.
Please do that and then let me know if you are able to get the value or not.
Aug 08, 2011 11:26 PM|You-Hu Fu|LINK
You can see this link to see how to create dataset parameter