Dropdown List Issue

Dec 26, 2007

Hi All,

I am having the following issue with one of my reports using Reporting Services 2005. When you chose a value from dropdown list , the page reloads but the dropdown list does not keep the value selected. It always display the first item from the dropdown list.

Any idea?

Thanks!
Gonzalo

View 1 Replies


ADVERTISEMENT

Dropdown List Values

Apr 28, 2007

Dear Readers of this post,
 
I have a dropdownlist that is populated with an sqldatasource as follows:
 
SELECT [Project_ID], [Title] FROM [Projects] WHERE [Username] = @Username AND Hide ='false'
 
The Datavalue vield of the DDL is populated with the [Title].
 
When the user submits the form [including the value of the of the drop down list] i want to be able to add the Project ID and the Title Values into another database table.
 
any ideas
 
Sat

View 3 Replies View Related

DropDown List Values

Nov 22, 2005

For a controlParameter in the ASP code, how do I retreive the selectedValue of the drop down list?Would this work?
<asp:controlParameter Name="InvoiceNumber" Type="String" ControlID="ddAdSize.Value" />

View 1 Replies View Related

Dropdown List Width

May 11, 2007

Hi everybody,

I created a multivalue parameter in SSRS 2005 SP2, but the problem is that the width of the dropdown list is too small to fit my data (I'd like to avoid scrolling horizontally).

Is there any way to configure this?

Thanks in advance for your help.
Zoz

View 3 Replies View Related

Dropdown List And Data From A Table

Feb 2, 2004

Hi masters

well got a SQL server 7 and a table

and got drop down list in my asp page

what I want to do is that the content and value of the drop down list will be grabbed from the database, when page loads.

can you please guide me

many thanks

S

View 1 Replies View Related

How To Populate Table From Dropdown List?

Oct 18, 2005

Hi,I have table (tbl_a) that get it values form three Dropdown List and the PK of this table is FK in different table(tbl_b).Since tbl_a get its values from three Dropdown List the number of rows in this table is limited to the number of combinations the three Dropdown List is offer (in any case the number of raws in that table will be final).Assuming tbl_a and tbl_b are both empty.
The problem is that if i want to insert row to tbl_b i have to check first if there is a row that holds the values (or combination of values) i am getting from the Dropdown List in tbl_a .Then, if such row is exist i have to get the PK of that raw and insert it to tbl_b (as FK),if such row does not exist, i have to insert it and then get the PK of this row and insert it to tbl_b (as FK).
In the end, tbl_a will have all the combination the three Dropdown List can offer so checking if raw exist in this table will not be necessary.
In my opinion this is not effective way to do that.Can someone offer me better way to do it?
Thanks

View 6 Replies View Related

Select Statement For Dropdown List

Apr 4, 2006

I have a dropdown list that is populated by two columns in a database.select (firstname+surname) AS Fullname from table where id = 'id';
It works fine but i want to know how i would get a space between the firstname and the surname because at the moment all the values come back as JoeBloggs....without any spaces

View 1 Replies View Related

How To Populate Table From Dropdown List?

Oct 18, 2005

Hi,
I have table (tbl_a) that get it values form three Dropdown List and the PK of this table is FK in different table(tbl_b).
Since tbl_a get its values from three Dropdown List the number of rows in this table
is limited to the number of combinations the three Dropdown List is offer (in any case the number of raws in that table will be final).
Assuming tbl_a and tbl_b are both empty.

The problem is that if i want to insert row to tbl_b i have to check first if there is a row that holds the
values (or combination of values) i am getting from the Dropdown List in tbl_a .
Then, if such row is exist i have to get the PK of that raw and insert it to tbl_b (as FK),
if such row does not exist, i have to insert it and then get the PK of this row and insert it to tbl_b (as FK).

In the end, tbl_a will have all the combination the three Dropdown List can offer so checking if raw exist in this table will not be necessary.

In my opinion this is not effective way to do that.
Can someone offer me better way to do it?

Thanks

View 5 Replies View Related

Parameter DropDown List Grayed-out

Dec 12, 2007



I am building a report with several search parameters; three of which are dropdown boxes each populated by a data set. I wanted something more user-friendly than the default "(Null)" in the dropdown, so for each data set, it returns a result set UNIONed with " N/A" to show up first as the default.

For some reason, when the report loads, the first dropdown populates just fine and does indeed have the default value " N/A" but the other two dropdowns are grayed-out. Until you change the first dropdown (to anything, apparently it doesn't matter what you change it to) the other two stay grayed-out. When the first is changed, the other two are populated and default to the desired " N/A" default value.

Why would it do this, when it didn't do it before; i.e. when the default for all of them was simply null. The dropdowns are not dependent on each other; they don't depend on other parameters for their values. Any help would be appreciated.

View 2 Replies View Related

Special Characters In A Dropdown List

Nov 2, 2006

I have a web form that needs to be bilingual. It contains several dropdown lists. The "text" and "value" for each item in the dropdown list is retrieved from a database. The logic reads the database and then populates the various dropdowns with logic such as:

dim newItem as new ListItem(textString, valueString)

theDropDown.items.add(newItem)

The problem that I am having occurs when the textString needs to contains special characters such as accented vowels or an "n" with a tilde. I have tried populating the database with HTML-formatted strings such as "Avi&oacute;n", hoping that this would display "Avion" with an accute accent over the "o". Unfortunately it displays "Avi&oacute;n".

How do I get dynamically-created dropdowns to display special characters? If the answer is to simply store the special characters directly in the database, then the question becomes how do I get the special characters into the database? I tried to figure out how to write a T-SQL command such as

update tablex set SpanishName = 'Avion' where id=999

but I can't figure out the syntax to insert an accented 'o' into the string.

Thanks.

View 4 Replies View Related

Separate Dropdown List Selectedvalue Into Two Fields

Aug 1, 2006

i have two columns in a "release" table that i concatenate on my aspx page into one value for my dropdown list.  for example, my database columns might look likeMajor: 3 | 3 | 4 | 4 | 5Minor: 1 | 2 | 1 | 2 | 1and my drop down list text like3.1 | 3.2 | 4.1 | 4.2 | 5.1my question comes when trying to take the drop down list's selected value and splitting it back into two fields so that i can use it for another query.  how can i split my "major" and "minor" version numbers back up so that i can run a query similar to:SELECT * FROM [Version] WHERE (([Major] = @Major) AND ([Minor] = @Minor))but only having the one parameter of: <asp:ControlParameter ControlID="ddlVersion" Name="Version" PropertyName="Text" Type="String" /> where the selected value has a string of "<major>.<minor>" (where the numbers are separated by a period)?

View 6 Replies View Related

Trying To Populate Dropdown List From SQL Data Source

Apr 8, 2008

I am trying to populate a dropdownlist from a sql data source in my codebehind using c#.  I thought I had the code correct but I keep getting the following error and I am stuck:  "Only assignment, call, increment, decrement,  and new object expressions can be used as a statement"
 Here is the code:protected void populateOppNameList(){
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);SqlCommand cmd = new SqlCommand("SELECT empname FROM opportunity WHERE (username = " + userName + ")", conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
try
{
conn.Open();DataSet ds = new DataSet();DropDownList ddl_OppNames = (DropDownList)FormView1.FindControl("dropdownlist1");
ddl_OppNames.DataSource = ds;
ddl_OppNames.DataBind;}catch (Exception e)
{
}
finally
{if (conn != null) { conn.Close(); }
}
 
}

View 11 Replies View Related

Oleddb Dropdown List Is Empty In Excel

Sep 27, 2006

Hello,

I have an issue with connecting Excel to an analysis Services 2005 database. The computer is running Windows XP Sp2 and Office XP. I installed the oledb driver 9.0 but when I tried to connect with the pivot table and I want to create the connection, the dropdown list of the data provider is empty. I tried on another computer with Excel XP and the system is working fine.
Is there somebody that could help?

Thank you

View 2 Replies View Related

Populate Dropdown List With Dimension Hierarchies

Dec 17, 2006

Hi,

I am currently trying to develop an application which would help in retrieving data from cubes (Microsoft Analysis Services)! The user would not be accessing the Business Intelligence Studio, etc. but would be viewing the data from a custom made application developed in VB.Net2005.

While implementing this, I want to populate the drop-down-list in the VB(.Net) Form, by retrieving the various hierarchies in the dimensions of the cubes (along with dimensions if possible). This should be done dynamically and in real-time!

Can you please help in implementing this? Any code/method, etc would be highly appreciated!

Thanks in advance.

Best wishes!

(Software : SQL Server 2005 Enterprise Edition (with Analysis Services and BI Studio), VS.Net 2005 Enterprise Edition, ADOMD.Net)

View 1 Replies View Related

Without Checkbox Leftside Of The Dropdown Value List Of The Parameter

Feb 5, 2007

Hi,

I believe somebody know the reason. Please help me on it!

I plan to pass a multivalued parameter from my web application to the server report, and let user select the value(s) from the value set. But when I run the report, there's no checkbox leftside of the values, that means user has no choice on this parameter.

Is there any way to do it?

Thanks,

Jone

View 2 Replies View Related

ForEach File In Folder - Missing From Dropdown List

Jun 28, 2007

I'm working through the SSIS tutorial, and am on lesson 2.
This says
"Double-click Foreach File in Folder to reopen the Foreach Loop Editor.

Click Collection.

On the Collection page, select Foreach File Enumerator."

The drop down only contains

foreach ado enumerator
foreach ado.net schema_rowset.enumerator
foreach from variable.enumerator
foreach nodelist.enumerator
foreach smo.enumerator


How do I get the "foreach file in folder" to appear in the drop down list?

Gary

View 3 Replies View Related

Transact SQL :: Get Query By Selecting Month From Dropdown List And Display Records?

Oct 8, 2015

Im trying to get query by selecting the month from dropdownlist and display the records .by using the below query I need to enter the date in tecxtboc then it will show the output

select Standard, Total, MonthName
from (SELECT Standard, COUNT(Standard) AS Total,
datename(month, ReportDate) as [MonthName]
FROM CPTable where
ReportDate >= @ReportDate

[Code] .....

View 5 Replies View Related

Firefox In Mac Fails To Render Scrollbar In The Multi-value Parameter Dropdown List Generated By ReportViewer.

Mar 10, 2008

Our clients working with the Firefox browser on a Mac are unable to use the Multi-Value parameter drop down lists that the Report Viewer control generates. Of course I realize that the multi-select dropdown lists are not really dropdown option lists using the standard HTML select tag, but are rather tables within div tags with cells that contain spans, inputs, and labels.

Originally the report viewer displayed these lists in the wrong position within Firefox on any platform (Mac or PC). Furthermore, there were other visibility problems with those lists that made it virtually impossible to select a checkbox within the list. Fortunately, Microsoft fixed this problem with the latest version of Report Viewer, which we downloaded from the following link:
http://207.46.19.190/downloads/details.aspx?FamilyID=cc96c246-61e5-4d9e-bb5f-416d75a1b9ef&displaylang=en

So currently we have SQL Reporting Services Report Viewer 9.0.21022.8 installed on our web server. And the dropdown lists do appear as expected, and they work properly in Firefox on a PC.

But, when the control is rendered in Firefox on a Mac, the list is not scrollable. The scroll bar that should appear on the right-hand side of the dropdown list, which would enable users to select values toward the bottom of the list, does not appear. That scrollbar is missing in Firefox.

This is likely related to a Firefox rendering issue with the overflow:auto style. There are numerous entries on the web that indicate Firefox for Mac has a problem with overflow:auto. For example:
http://www.webdeveloper.com/forum/archive/index.php/t-96958.html
http://www.daniweb.com/forums/thread44144.html
http://iamthewalr.us/blog/2007/04/20/firefox-on-the-mac/#comment-2321
http://www.errorforum.com/mozilla-firefox-error/3503-will-float-mac-firefox-scrollbars-floating-pop-up-windows.html
https://bugzilla.mozilla.org/show_bug.cgi?query_format=specific&order=relevance+desc&bug_status=__open__&id=187435


That being the case, it seems that there should be some workaround to address this, either via a style or through some alternate control. Or perhaps there is a property that we can apply to the ReportViewer control that I'm unaware of which addresses this.

If you know of a workaround, or can suggest an alternate approach that we could implement quickly, please respond. Thanks.

View 1 Replies View Related

Selected Value Of Dropdown

Feb 20, 2007

How would I reference the selected value of a dropdown parameter in SSRS using VS2005?

For instance, the city Miami is selected I want to find out if both dropdowns match eachother...

iif(dropdown1.selected.value = dropdown2.selected.value,false,true)

View 9 Replies View Related

Ndinakar - Third Dropdown Has Me Beat

Oct 23, 2007

Hi Folks,
 Trying to setup a Third dropdownlist now to feed from the selection of my second dropdownlist which feeds off my first dropdown if that makes sense
 Do i need to somehow put in some code to add the first and second dropdownlist values to make the third
 How do i add two Dropdownlists values to create the third?
I'm new to all of this so please go easy. Much appreciated.
Thanks,
Sully
 

View 1 Replies View Related

Populate Dropdown Box From SQL In Web Matrix?

Jan 22, 2004

I have been attempting to populate a dropdown (combo) box from a SQL query (SQLConnector) in Web Matrix and I have so far been unsuccessful. I have been able to populate a DataGrid just fine from the query, so then I limited it down to one colum (so itd be in the dropdown box) and set all the properties I could find (DataSource, DataMember, DataTextField, DataValueField) (and in all possible combinations) for that dropdown box to the SQL stuff (SQLConnector for the DataSource and then used the dropdowns for the others), and nothing shows up in my dropdown box. How can I make this populate off of my SQL query properly?

Additionally I will need to do the same thing for a Checkbox List so if it is the same and you know how to do that and could let me know for that too that'd be great.

Thanks a million in advance!

View 1 Replies View Related

Dropdown Other Options..how To Store?

Jun 2, 2005

Hi
Often we come across a form with a dropdown list (populated from a lookup table) with "Other" option as well. When user selected "Other" option a textbox appears where he can specify new option(This option is not to be added to master lookup table).

What is the best way to store it in database?
I have 2 columns (A and B). 'A' contains Lookup ID if some option other than "Other" is selected, else 'A' has NULL and 'B' field contains the text of Textbox.

But while reporting I face problems as in a report the selected option text (either 'A' or 'B') has to be shown under one column only but SELECT A,B results in 2 columns.

View 1 Replies View Related

Dropdown Menu In Sql Reporting

Jan 22, 2007

Is it possible in SQL Reporting 2005 to have dropdown menu(eg..on mouseover list of static menu appears from which i can navigate to other rdl files while passing all parameters) ..



View 4 Replies View Related

What Does Data Region Dropdown Do?

Jan 30, 2008

Hi,

I have a table1 which points to a dataset1

I was wondering how I use the 'data region' dropdown selection which is present when i click the properties of a cell in table1, it always appear to be blank.

I would like to know how this works as i feel it will be useful in specifying various data regions within a table, I cant seem to find any relevant information on it, can someone tell me how this works ?



View 3 Replies View Related

If Textbox Is Null Post From Dropdown Box

Jul 21, 2007

I've got two tables, the first is a list of locations and the second is where i would enter new information (ie name and chosen location).  Could some help me straighten out my code so that when button is clicked name and either the location text box is stored or if the location text box is empty the chosen location from the drop down box is stored.  Here is my code and thanks for the help.
 
<%@ Page Language="VB" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">Protected Sub submit_Button_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Try
'declare a connection to database
Dim sqlCn As New Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True") 'connection string for sql server 2005
'open connection
sqlCn.Open()
'declare a command to fire against databaseDim sqlCmd As New Data.SqlClient.SqlCommand("Insert Into Locations (Locations) VALUES (@Locations)", sqlCn)
Dim sqlCmd2 As New Data.SqlClient.SqlCommand("Insert Into Results (Results) VALUES (@Results)", sqlCn)
'add the parameters to sql commandsqlCmd.Parameters.Add(New Data.SqlClient.SqlParameter("@Locations", newlocation_TextBox.Text.Trim))sqlCmd2.Parameters.Add(New Data.SqlClient.SqlParameter("@Results", name_TextBox.Text.Trim))
 
'execute the command
sqlCmd.ExecuteNonQuery()Catch ex As Exception
'error occured
Response.Write(ex.Message)
Exit Sub
End TryEnd Sub
</script><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server"><title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
Please choose a location <asp:DropDownList ID="locationDropDownList" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="Locations"
DataValueField="Locations">
</asp:DropDownList>
 
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>"
SelectCommand="SELECT DISTINCT [Locations] FROM [Locations] ORDER BY [Locations]">
</asp:SqlDataSource>
..or add a new one:
<asp:TextBox ID="newlocation_TextBox" runat="server"></asp:TextBox>
<br />
Enter your name:
<asp:TextBox ID="name_TextBox" runat="server"></asp:TextBox>
<br />
<asp:Button ID="submit_Button" runat="server" Text="Submit" OnClick="submit_Button_Click" /></div></form>
</body>
</html>

View 3 Replies View Related

How To Populate A Dropdown Box Based On SQL Data?

Dec 16, 2003

How can I populate options in a dropdown (combo?) box based on data pulled from a SQL database compared against certain paramaters (if it is not equal to x, equal to y, etc)?

Thanks.

View 2 Replies View Related

US / CANADA States Organized For DropDown--HELP????

Oct 30, 2004

I feel real bad asking this...but I have a state table...ordered by State ASC
and it mixes US and Canada, of course. I want to set up a table and a
stproc to produce a dropdownlist that looks like this (as I've seen in many
websites' state tables):

United States --
Alabama
Arizona
...
Canada --
Alberta
...

...and so on, so that the country is listed as a heading with no state code value
and the states each appear in asc order under the country heading. I don't know
how to do this. Does anyone have a good example of how to do this?

Thx much,
reid C.

View 2 Replies View Related

DBs Not Appearing In Query Analyer Dropdown

Jul 23, 2005

A couple of databases on one of our SQL Servers is missing in the dbdropdown in query analyzer.Does anyone know what I need to update to sync this with the actualdatabases?Thanks,Burt

View 1 Replies View Related

Adjusting Parameter Dropdown Width

Oct 25, 2007

Hi there,
May be a kind of dumb question, but I have a multi-value parameter that I would like to give users the ability to select from in a SSRS 2005 Report and I was wondering if there was a way to adjust the width of the drop down so the user wouldn't have to scroll horizontally to see a full parameter item. It looks like it cuts off after about 30 characters.

Any help here would be appreciated.

Thanks!
Rich

View 1 Replies View Related

DropDown Filter In Report Builder

Jan 10, 2008



Guys,
In my report builder when I drag the SKU in the filter area, its doesnt give me the dropdown and show me the distinct values, it just gives me a text box and expects me to type in the SKU.
I have other attributes whcih have the same property as SKU but they all work fine when I drag them into Filter area.

Is there a limitation in reporting svcs where if the Field has more than "n" number of distinct records it will not populate the dropdown, instead just present you with a text box?

My DataModel Table has around 110K records and roughly 7K distinct SKU's

I compared the SKU field to other fields in the Report Model Designer and also DataSource View and nothing seems to be out of normal to not show the dropdown with distinct values except for the # of distinct records.

Appreciate your help in advance



View 4 Replies View Related

Width On Multivalued Dropdown Menu

Nov 28, 2007

I have a multivalued drop down menu that isn't wide enough to display the entire label. It only displays about half of the label. The text it is trying to display should look like "Global Zone 1 - Global Zone 2 - Global Zone 3 - Global Zone 4", and the only visible text is "Global Zone 1 - Global Zone2". It does have a scroll bar at the bottom, but it is ridiculous.

When I set it to not be multivalued, the drop down menu grows to the size of my label. The menu has plenty of space to grow, it is only taking up a very small amount of the screen.

Is there any way to correct this issue?

Thanks

View 1 Replies View Related

Analysis :: Dimension Errors In Dropdown

Sep 1, 2015

I am getting the dropdown of the dimension folder twice, as i took printshot from client tool. In SSMS/bids also its showing this error. How to resolve it.

View 9 Replies View Related

Updating Grid View That Has Dropdown Lists

Jun 28, 2007

I have gridview bound with SqlDataSource control. One of the grid columns is a dropdown list which is populated programatically, (the gridview has template column with edittemplate field with dropdown list), dropdown Value contains of course collection of IDs.Please tell me how to declare UpdateCommand which will update the row with the dropdown list. The problem is with parameter regarding the column with dropdown list. When i declare this parameter and bind it to SelectedValue property of the dropdownlist from edittemplate tag - it doesnt work, because datasource control cannot see this dropdown list. So, how am i supposed to declare the ID of the row being updated in <updateParameters>? Thanks in advance!  

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved