How Can I Split The Rows In 2 Textboxes - Urgent
Hi,
I have a report and its been populating from a sproc. and i have 2 text boxes called both of them are poplulated by Fields!Investment Names, but right i can display the data left to right but i want to display the Data starting top to bottom and then towards the right.
I tried grouping the data in this way for one text box = CountRows()/2 > 10 . and this shows all the records one below the other, so is there a way that i can display half the records in one text box and the other half in the other text box.
I am going kinda nuts over this. Can someone please help me.
Regards
Karen
View Complete Forum Thread with Replies
Related Forum Messages:
Split Rows
not sure if this is possible... but lets say i make a select like select products, stock from table and my rs is chair | 1 couch | 3 lamp | 2 is there anyway in the select to make any row that has stock of more than 1 to make a new row... so my rs would come back as chair couch couch couch lamp lamp Any info would be helpful... Thanks, ~ moe
View Replies !
Urgent! Split Results By Two Conditionals
hi im using sql server 2005 i have a table called download_transactions which contains wallpaper and video downloads. videos have a download_type of 110 and wallpapers 104. i need to pull out a count of these transactions where download_type is 110 and 104. so one results column is count of 110 downloads and the other column is count of 104. thing is, one canned do; .. where download_type 110 And 104 where download_type in (110, 104) because this just confuses SQLserver. two conditionals. how to do this, any ideas. must i use a cursor to go through results once for 110, then again for 104? at the moment, i select to pull out the count, and it gives two rows for each download type e.g. clientID date count 50015 2007-03-06 00:00:00.000922 50015 2007-03-06 00:00:00.0001430 50020 2007-03-06 00:00:00.000486 50020 2007-03-06 00:00:00.000872 two rows for each clientID, one is count of 110, and one is count of 104. i just need the 2nd row count to be in a 4th column next, like this: clientID date 104/count 110/count 50015 2007-03-06 00:00:00.000922 1430 this is the sql i am using: declare @start_date datetime declare @end_date datetime declare @start_timeshift int declare @end_timeshift int declare @client_id int select@start_timeshift =0, @end_timeshift =23, @start_date = (dateadd(hh,@start_timeshift,'2007-03-06')), @end_date = (dateadd(hh,@end_timeshift,'2007-03-06')) select c.client_id, @start_date[date], count(txn.download_transaction_id) + '' + count(txn.download_transaction_id) from[main_tbl].dbo.download_transactions txn with ( nolock ) inner join [main_tbl].dbo.billing_partners as b with ( nolock ) on ( ( b.billing_partner_id = txn.billing_partner_id ) and ( b.is_active = 1 ) and ( b.is_development <> 1 ) ) inner join [main_tbl].dbo.suppliers s with ( nolock ) on ( ( s.supplier_id = txn.supplier_id ) and ( s.is_active = 1 ) and ( s.is_development <> 1 ) ) inner join [main_tbl].dbo.clients c with ( nolock ) on ( ( c.client_id = txn.client_id ) and ( c.is_active = 1 ) and ( c.is_development <> 1 ) ) inner join [main_tbl].dbo.downloads d with ( nolock ) on ( ( d.download_id = txn.download_id ) ) inner join [main_tbl].dbo.download_types dt with ( nolock ) on ( ( dt.download_type_id = d.download_type_id ) ) --inner join [LOGGING].dbo.wap_sessions wp with (nolock)on ( ( wp.client_id = txn.client_id ) ) where (txn.client_id in (50025,50015,50030,50020)) and (txn.date_created between @start_date AND @end_date) --between '2007-01-01' And '2007-01-10') and(txn.billing_successful = 1) and (txn.PORTAL_CAMPAIGN_ID is null) --and (dt.download_type_id = '104' + '110') --choose downloadtype --and (dt.download_type_id = 110) --ch+oose downloadtype --and (dt.download_type_id = 104) --ch+oose downloadtype group by c.client_ID, datepart(day,txn.date_created), dt.download_type_id, dt.download_type_id order by c.client_ID, dt.download_type_id any help will be VERY VERY VERY appreciated. Thanks James
View Replies !
How To Split Data Into Two Rows
I have a query that returns a table similar to: State Status Count CA Complete 10 CA Incomplete 200 NC Complete 20 NC Incomplete 205 SC Incomplete 50 What sort of query will allow me to reformat the table into: State Complete Incomplete CA 10 200 NC 20 205 SC NULL 50
View Replies !
Can I Split Matrix Into 2 Or 3 Rows?
Hi All I have a matrix with single row. The no. of column varies and sometimes goes to 10-15. So it goes to next page and while exporting it inserts blank pages when exported to PDF. I need the column width at least 2.5cm. I need to break the matrix to next row instead of it going to next page say after 6th or 8th column. I tried to work with the example given in the site http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx by Chris Hays. But it is showing matrix for each Row Group, which doesn't meet my requirement. I had a work around which worked by putting two matrix one below the other and filtering the columns to be shown in each matrix. If anybody faced this issue or anybody solved the issue kindy reply which will be very helpful for me. One more doubt, Can I get the Column number of the matrix? Thanks in advance Dileep
View Replies !
How To Split Out Table Rows Into 3 Tables
I imported all rows of my txt file using SSIS 2005 into a table. I am now trying to figure out how to split out the header, payment rows, and maintenance rows. First, some information. An example of table results is here: http://www.webfound.net/split.txt The table has just one field of type varcha(100) because the incoming file is a fixed length file at 100 bytes per row The header rows are the rows with HD in them...then followed by detail rows for that header (see here http://www.webfound.net/rows.jpg). I need to 1) Split out the header into a header table 2) Split out the maintenance rows (related to the header) into a maint table 3) Split out the payment rows (related to the header) into a payment table I'll need to maintain a PK/FK relationship between each Header and it's corresponding maint and payment rows in the other 2 tables. To determine if it's a payment vs. maintenance row, I need to compare chars 30 - 31. If it contains 'MT' then you know it's a maintenance row, else it's a payment row. How in the hell do I do this???
View Replies !
Split One Field In Multiple New Rows
HiHo, just a beginners question: I have the following row with 2 fields: Field 1: Task A Field 2:´ 1;2;3;4 The number of semicolon divided elements in Field 2 is variabel. I would like to create new rows like: Row 1 Field 1: A Field 2: 1 Row 2 Field 1: A Field 2: 2 Row 3 Field 1: A Field 2: 3 Row 4 Field 1: A Field 2: 4 I think I should use a Foreach Loop. But I don't exactly how to do it? best regards Chris
View Replies !
One For The SQL Gurus: Split A Delimited Field Into Rows
Hi. I'm trying to write an SQL Query that will take a delimited field and return each item as a row. Example Take the AuthorizedRoles and TabID fields from the Tabs table AuthorizedRoles TabID 0;11;__________1 0; 15 ;17;______6 -2;____________7 I would like to return a unique record for each Authorized Role AuthorizedRole TabID 0____________1 11___________1 0____________6 15___________6 17___________6 -2___________7 Any ideas? Cheers Dave
View Replies !
SQL View To Split Rows In Single Table...
I've been searching the forums and Google for some help splitting up rows in a table without any luck. I'm not quite sure what to even look for I have a table is MSSQL 2000 that looks as follows: Code: id custnum b1_email b2_email b1_sub b2_sub ------------------------------------------------------------------------ 1 123456 b1@host1.com b2@host1.com 0 0 2 654321 b1@host2.com b2@host2.com 1 0 3 321654 b1@host3.com b2@host3.com 0 1 Now... I am hoping create a view that splits these rows up so that only a single email address is on each row. I'd like to split it up as follows: Code: custnum email sub ---------------------------------- 123456 b1@host1.com 0 123456 b2@host1.com 0 654321 b1@host2.com 1 654321 b2@host2.com 0 321654 b1@host3.com 0 321654 b2@host3.com 1 Any help would be great! I imagine some sort of join command can be constructed using a single table?
View Replies !
How To Assign Unique PKs And FKs On Split Of Txt Rows Into DB Tables
SSIS 2005 Ok, I have a task in SSIS that does the following and works: 1) Brings in a txt file 2) Using a conditional component, checks for a value in the row. 3) Based on the value, splits the row into one of 3 tables (Header, Maintenance, or Payment) Here is a print screen of what I have so far which splits Header rows into it's own table, Maintenance rows into its own table, and Payment Rows into its own table: http://www.webfound.net/qst_how_to_add_header_PK_and_FKs.JPG Here is a print screen of the conditional split: http://www.webfound.net/conditional_split.jpg Please take a look at the txt file here before it's processed: http://www.webfound.net/split.txt http://www.webfound.net/rows.jpg Notice that the pattern is a header row, followed by it's corresponding detail rows. The detail rows are either Maintenance or Payment rows. I need to somehow during the Script component or some other way, to assign a unique HeaderID (PK) to each of the header rows and add that ID to it's corresponding Maintenance and Payment detail rows in their corresponding tables as a PK. The problem is 1) I don't know how to do this in the flow of the components as I have it now 2) How do I tell it to create a new Header ID and Header FKs for the detail rows based off of each new Header row? In the end (much later on in my entire package), the goal is to be able to run a stored proc to join and select the Header and Details rows back into a final table so I can then do more processing such as split each header and detail rows into their own txt files, etc....I don't need to go into details why but just know that this is the goal, therefore I need to relate each header row with their corresponding detail rows that are split off into a MaintenanceRow and PaymentRowTable
View Replies !
Split One Row Into Multiple Rows Based On Time Elements
I'm dealing with a problem. The record information example DateTimeStart , DateTimeEnd , action , duration (seconds) 2007-02-02 10:30:22 , 2007-02-02 11:30:22 action1 , 600 what i want is for every half hour between start and end a record 10.30 action1 11.00 action1 11.30 action1 how can i create this, i'm a little stuck on this
View Replies !
How To Split A Delimited Column Into Mulitple Rows In The Dataflow?
I'm sure there is probably a very easy solution that I am just not seeing or can't Google... I have a DataFlow that includes a column of Delimited values (i.e. Value1,Value2,etc..). As this DataFlow is populating a parent table, I need split the values into their own dataflow and populate a child table. I've tried a script transformation and couldn't figure out how to accept 1 delimited input row and output multiple rows after a split. Any ideas? TIA, Matthew
View Replies !
URGENT! Rows Disappearing
Hello together, strange things going on: 1. The table statistic shows for example 67 rows in a table, select count(*) only returns 63 rows. 2. Table statistic shows 50 rows, select count(*) returns 55 rows. In both cases if you do an insert the newly inserted row sometimes can be retrieved by a select statement sometimes not. Row statistics sometimes is updated correctly, sometimes not. Integrity check for these databases says everything is fine. DBCC CHECKDB, DBREINDEX, UPDATESTATISTICS, ... does not help or says everything is fine. Already opened a case at HP's Microsoft support and they involved Microsoft itself but all are a little bit clueless at the moment. As this is our main DB cluster and several databases are affected we had to stop most of our applications since last Thursday and now we are getting a little bit in trouble so any hint is very welcome. Thanks in advance PS: Restore is not an option - as all tools say everything is fine all of our backups from the last months include the error. Don't ask why nobody recognized the lost data earlier, seems they were stored but not required for some time.
View Replies !
Urgent - Deleting Duplicate Rows
Hi folks, I need to delete the duplicate rows from a table. How to do that in SQL server 7.0 ? If possible write an example, so that it will be much useful for me.. Thanks for ur help.. rgds, vJ
View Replies !
Urgent Help!-how To Format After Getting Rows? For Newline
while(@@FETCH_STATUS=0) begin print 'inside while' set @BodyContents = @BodyContents+@gotclientName+@gotproductName set @Body= @Body + @BodyContents + ',' fetch next from resultcursor into @gotclientName,@gotproductName print 'going outside of while' end --while end Client Name Product Name aaa test1 bbb test4 how to format row like above. currently i am getting aaa,test1,bbb,test4
View Replies !
How To Group 2 Table Rows (urgent)
Hi How do i group 2 table rows? I have a report with a table and it has 58 rows, in some of the rows i am displaying the data like this Roth contribution (Heading) data for the roth contribution. So depending on the options checked sometimes the heading Roth contribution is at the end of the page and the data is the next page. so how can i group 2 table rows together. I have tried clicking on the 2 rows and grouping it, but nothing seems to appear in the report.. any help will be appreciated. Regards, Karen
View Replies !
Convert Columns To Rows - Urgent
Hi, I have a table with 5 columns, from that I need only 3 columns , but the columns should be rows in the output Ex Table 1 col1 col2 col3 Now I want col1 as one row n col2 as 2nd row and col3 as 3rd row What query should I write to get this? Will union work Thank You
View Replies !
ELIMINATING DUPLICATE ROWS URGENT
Hi i have a table value which contains value ----- a a a b b b c c c Now i need to have the results as a 1 b 1 c 1 I tried using distinct.But OLEDB returns error that invalid syntax.It doesn't support distinct keyword.Actually i read these table from a file thru OLEDB.Not from a database.Any idea ? Thanks in Advance
View Replies !
Missing 1 Million Rows During BCP PROCESS!! Urgent Help
Hi, I used the /e in my bcp code. yet did not get all the rows from the main frame into the sql talbes... here is the case I have 11 million rows in an ftp server I use this code to bcp into sql server can anyonecheck if this code is good for the process, I am missing one million row in the bcp process and do not know why??? I put the /e to see if there is any error but could not see any error file in my hard drive? Please check it out and let me know regards Ali Exec master..xp_cmdshell "bcp dbname..tablename in c:ftprootNbtorder.txt /fd:ftprootformatfileablename.fmt /Servername /Usa /Password /b250000 /a8000 /eerrfileORD"
View Replies !
(URGENT) Getting The Number Of Rows From List Control
Ok here is what I have Department:A Line 1 Name: George Addresss date raise 125254 Test 10 125254 Test 10 125254 Test 10 125254 Test 10 Total: 80% 40 Name: Mik Addresss date raise 125254 Test 10 125254 Test 10 125254 Test 10 Total: 70% 30 Name: Jonathan Addresss date raise 125254 Test 10 125254 Test 10 125254 Test 10 Total: 70% 30 Line 10 Line 15 Total for this division: 33% ((100 )/3) 100 Department:B €¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦.. Here is what I did I have a list control that is grouped by department. this will get me the info from Line 1 to Line 10 then this list control is actually under another list control that is grouped by department to get the info from Line 15. I used this example for simplicity and what I am doing is fairly similar to this situation. My problem is, I need to find away to know how many totals I have to count the total for the entire department. In other words : from the example above how can I know I have to divide by 3 to get 33%. I can get the 100 without any problem but I can€™t tell what number I need to divided by. I tried to use Count(Name.Field) I was hoping this will give me 3 which indicates the divided number. But I was getting 7 for some reason. How can I get the number of times the list control was implemented for one department which is in this case 3? thanks
View Replies !
URGENT Plz ! Pivot Rows To Columns In SQL Server 2000
Hi, I have the following data in a table called "Products" : Product Qty LHinging RHinging -------- ----- -------- -------- Panel_1 1 R Panel_1 1 L Panel_1 1 R Panel_1 1 R Panel_2 1 Panel_2 1 L I need to group this data like this : Product Qty LHinging RHinging -------- ----- -------- -------- Panel_1 3 L R Panel_2 1 Panel_2 1 L How can I do that ??? Thanks !
View Replies !
URGENT Merge Replication: Missing Rows At Publisher And Subscriber: No Conflicts
We have SQL Server 2000 with merge replication at a Publisher and subscriber. We have some records getting deleted at Publisher and Subscriber and no conflicts are logged. We have tried the compensate_for_errors setting and this has had no effect. This is causing serious data corruption and has now become an URGENT issue. Out tech team are almost out of ideas. Has anyone experienced this or have any ideas as to what to check next?
View Replies !
Grid And Textboxes
hi, now theres something i want to achieve but, again dont know how :-( In a grid of my site it needs to be able to select an item, ( not with checkboxes) but maybe when you click on the item in the FromName column then the data in the column in my database messageTEXT needs to be able to show in a textbox.( textbox is outside of grid) now i was thinking that maybe it is need to be done with datareaders or something? Greetz Roy
View Replies !
Paragrahs In Textboxes
Hi, Can anyone advise me how to force paragraph breaks in a textbox in Reporting Services 2000? I've tried Shift + Enter and in layout view it forces a paragraph break, but as soon as the report is rendered, the breaks disappear. Thanks.
View Replies !
Referencing Textboxes
Is there a way to reference textboxes in an SSRS table like one would for cells in Excel? For example, something like =textbox1/textbox2? I am trying to replace a spreadsheet by turning it into an automated report and need to do some horizontal formulas and when I put in the grouped total, it always defaults to averaging percetages from the rows above, which isnt a true summary in my case.
View Replies !
Hide Textboxes
Hello Everyone. I need help again. I have a reports made in VS business intelligence project with a lot of parameters. So it means it automatically creates textboxes of that parameters. I want to hide those textboxes. Pls help. Thanks -Ron-
View Replies !
Update Database With Textboxes
Hi I'm new to all of this. I have a database that holds customer information (fictitious) and i can select that data and display it in a set of textboxes. I also have an SQL command "UPDATE" that is designed to update the text field that i want to edit. However the problem i'm having is that it'll let me write the info in the textbox but as soon as i click my update button it just flashses and goes back to what it says before e.g. FIRST NAME: LEE i enter TOM and then it reverts it back to LEE 1 2 Partial Class Update 3 Inherits System.Web.UI.Page 4 5 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 6 custIDTextBox.Text = Session("Label2") 7 8 Dim updatepage As System.Data.DataView = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), System.Data.DataView) 9 10 For Each update As Data.DataRow In updatepage.Table.Rows 11 12 firstnameTextbox.Text = update.Item("First Name").ToString 13 lastnameTextBox.Text = update.Item("Last Name").ToString 14 addressTextBox.Text = update.Item("Address Line 1").ToString 15 townTextBox.Text = update.Item("Town").ToString 16 postcodeTextBox.Text = update.Item("Postcode").ToString 17 telephoneTextBox.Text = update.Item("Tel Number").ToString 18 19 Next 20 21 End Sub 22 23 Protected Sub updatebutton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles updatebutton.Click 24 25 'Dim parameters firstnameTextBox, lastnameTextBox, addressTextBox, townTextBox, postcodeTextBox, telephoneTextBox 26 'Dim UpdateParameters As QueryStringParameter 27 28 SqlDataSource1.Update() 29 SqlDataSource1.UpdateParameters.Add("@CustomerDetails", System.TypeCode.String) 30 'SqlDataSource1.UpdateParameters.Add("@Last Name", System.TypeCode.String) 31 'SqlDataSource1.UpdateParameters.Add("@Address line 1", System.TypeCode.String) 32 'SqlDataSource1.UpdateParameters.Add("@Town", System.TypeCode.String) 33 'SqlDataSource1.UpdateParameters.Add("@Postcode", System.TypeCode.String) 34 'SqlDataSource1.UpdateParameters.Add("@Tel Number", System.TypeCode.String) 35 36 'Label2.Text = ("Update successful") 37 End Sub 38 End Class 39 This is my SQL UPDATE command statement: UPDATE CustomerDetails SET [First Name] = @firstnameTextBox, [Last Name] = @lastnameTextBox, [Address line 1] = @addressTextBox, Town = @townTextBox, Postcode = '@postcodeTextBox', [Tel Number] = '@telephoneTextBox'
View Replies !
How To Count The Number Of Textboxes
Hi all, In the report I am working on, I have a "textbox39" in a table which has groups. I want to have another "textbox29" outside the table to count the number of "textbox39"s that are actually displayed and also the number of "textbox1"s that have a certain value (e.g. "1") in the final report. I tried to use "Sum(ReportItems!textbox39.Value)" but the compiler complains Error 1 [rsAggregateReportItemInBody] The Value expression for the textbox 'textbox29' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers. d:perfperfreportingprojectPerformanceTestDetails v.3.rdl 0 0 Error 7 [rsReportItemReference] The Value expression for the textbox €˜textbox29€™ refers to the report item €˜textbox39€™. Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope. d:perfperfreportingprojectPerformanceTestDetails v.3.rdl 0 0 Anybody has any idea how to solve it? Thanks so much, Zhiyan
View Replies !
How To Relate Fields In Different Textboxes
Hi, When we drag and drop different fields to sepesrate textboxes, how do we make the relationship. As an example, lets say I drag and drop cumtomer name, loan amount, reimberment amount and loan officer in to different textboxes which are resided in a list report. loan officer is grouped by. now how do we make sure each field is related to other. Thanks
View Replies !
Help Passing Values From Textboxes
I need help passing values from textboxes to other textboxes. I am using expressions in the textboxes. and what i want is a Iif statement in a way where if its one value then its one result and its changes for each one of them. There is 4 total. I have been told a switch or a choose statement will work. Can anyone help me?
View Replies !
Displaying Data From Database In Textboxes
Im trying to display data from a database based on an input value. The value in the Label12.Text which is("hotmail") is the input value thats stored in the database, this value is been searched for in the strSQL. Dim strSQL As String = "SELECT Name FROM Jobseeker WHERE Email='" & Label12.Text & "' " strSQL = Label5.Text the code builds successfully, but Label5.Text appears blank.
View Replies !
How Do I Populate Textboxes In A Form With A Dataset?
I have successfully built a form page to enter customer info into sqlserver 2000. I would now like to be able to pull up the customer info and edit it in a Windows form format rather than a datagrid or datalist. Dell computer is doing what I want to do on there customer checkout page. I have been looking for examples of VB code to do this with no luck. Here is the dataset I use to display customrer info,with my feeble attempt to convert it to a form that populates from the database. (The datalist works fine.) Can someone get me started or send me to good code examples please? <%@ Page Language="VB" Debug="true" ContentType="text/html" ResponseEncoding="iso-8859-1" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <script language="VB" runat="server"> sub Page_Load(Sender as Object, e as EventArgs) Dim objConn As SqlConnection = New SqlConnection("Data Source=localhost;" & _ "Integrated Security=true;UID=Newlogin;PWD=cool147;Initial Catalog=PLF") dim objCmd as SqlDataAdapter = new SqlDataAdapter _ ("select * from Customers where CustomerID like 28", objConn) dim ds as dataset = new Dataset() objCmd.Fill(ds, "Customers") firstname.datasource=ds.tables(0).defaultview 'select data view and bind to server control 'MyDataList.DataSource = ds.Tables("Customers"). _ 'DefaultView 'MyDataList.Databind() objConn.close() end sub </Script> <html> <head> </head> <body> <link REL="stylesheet" HREF="css/maincss.css" TYPE="text/css"> <form runat="server <asp:TextBox size="12" id="FirstName" runat="server" Font-Size="10pt" Font-Name="tahoma" /> <asp:RequiredFieldValidator ControlToValidate="FirstName" Display="dynamic" Font-Name="verdana" Font-Size="9pt" ErrorMessage="'Firstname' must not be left blank." runat="server"></asp:RequiredFieldValidator </Form> </body> </html>
View Replies !
Pulling 2 Values From 2 Textboxes Displayed In A Third
I have a problem trying to get a value from textbox 1 and textbox 2.If those two values match the data in the database then it has toreturn a third corresponding value to a third textbox (or label) aftera user clicks a submit button. Basically, I am trying to allow usersto enter a value of weight in pounds in textbox 1 and a zip code intextbox 2 then pulling the shipping amount from a courier's databaseand returning that dollar amount to a third textbox or label afterthey click submit. How would I write this code in vb.NET?Thanks,TG
View Replies !
Using A Textbox's Value For Format Expression Of Other Textboxes
I'm calculating the format string for currency values based upon what's selected as a report currency parameter value. Just to mention, it's a call to a .net dll. Because this call is in every textbox in the details section of the report,I believe it's getting called for every textbox that is displayed on the report - but I really don't need to calculate it at this level. The format string will only be one way per report execution. Is it possible to only call this function once, stuff the format expression in a textbox (or some method that's similar) and then reference that ReportItems!textbox3.Value for the format string of other textboxes? I threw the calculation in a textbox in the report header and also body, but I get an issue either way: Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope I understand that it doesn't seem possible, but can anyone help me think out of the box? I see that a database call and another dataset holding the FormatString might work... I'll try this out, but in the meantime, is there a solution to not do this?
View Replies !
Blank Space When Hiding Textboxes
Hello, Ik have a problem with the free space if I'am hiding textboxes. I put 2 textboxes in a rectangle and when I hide the rectangle then the textboxes are gone but the space that the rectangle needed is now blank. Can I suppress the blank space? Mvg, Hans
View Replies !
Placing Textboxes In Headers Of Reports
Hi, After exporting the report the column headers in the rreport should not scroll, it has to fix with report headers. If i move the column headers to report header the columns are merging in excel, some columns are hiding. For ex: I have 10 columns, it has to take from A to K but it is taking A to P. one column is occupying two columns. how to avoid this merging and how to place the column headers in the report header. Thanks Dinesh
View Replies !
Overlay Of Textboxes Are Not Rendering Properly
In the page header I have a rectangle that has 2 textboxes on the same line and both are the full length of the page. One textbox has text centered and the other has text right justified. When I render report in Studio or print it, the text appears on the same line and justified like I want, but when the report is rendered when I call the report by URL, the textboxes wrap, like it's taking the width of each textbox in account. Has anyone seen this? Any suggestions on how to overlay text on the same line and the text keep their own individual characteristics?
View Replies !
Using Textboxes And Dropdownboxes To Update Database Table
ASP 3.5 VB: Visual Studio 2008, 2005 Developer Server I'm new to web development so my question may seem basic. I created a stored procedure:CREATE PROCEDURE [dbo].[CaseDataInsert] @ReportType varchar(50), @CreatedBy varchar(50), @OpenDate smalldatetime, @Territory varchar(10), @Region varchar(10), @StoreNumber varchar(10), @StoreAddress varchar(200), @TiplineID varchar(50), @Status varchar(50), @CaseType varchar(200), @Offense varchar(200) AS BEGININSERT CaseData(ReportType, CreatedBy,OpenDate,Territory,Region,StoreNumber,StoreAddress,TiplineID, Status,CaseType,Offense) VALUES(@ReportType,@CreatedBy,@OpenDate,@Territory,@Region,@StoreNumber,@StoreAddress,@TiplineID, @Status,@CaseType,@Offense) END I created textboxes and dropdownboxes on my asp page, and with a button put the following code behind it:Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click Dim cs As String = "Data Source=localhost;Initial Catalog=Database1.mdf;Integrated Security=True;"Using con As New System.Data.SqlClient.SqlConnection(cs) con.Open()Dim cmd As New System.Data.SqlClient.SqlCommand cmd.Connection = con cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "CaseDataInsert"cmd.Parameters.AddWithValue("@ReportType", DropDownList1.SelectedItem) cmd.Parameters.AddWithValue("@CreatedBy", DropDownList2.SelectedItem)cmd.Parameters.AddWithValue("@OpenDate", TextBox1.Text) cmd.Parameters.AddWithValue("@Territory", TextBox2.Text)cmd.Parameters.AddWithValue("@Region", DropDownList3.SelectedItem) cmd.Parameters.AddWithValue("@StoreNumber", TextBox3.Text)cmd.Parameters.AddWithValue("@StoreAddress", TextBox4.Text) cmd.Parameters.AddWithValue("@TiplineID", TextBox5.Text)cmd.Parameters.AddWithValue("@Status", DropDownList4.SelectedItem) cmd.Parameters.AddWithValue("@CaseType", DropDownList5.SelectedItem)cmd.Parameters.AddWithValue("@Offense", DropDownList6.SelectedItem) End Using End Sub On the web page I can enter the data, click the button, and no data is entered into the database? I believe that I may have problems with the datasource? Any help would be appreciated. losssoc
View Replies !
Selecting And Placing Values From Sql Query Into Textboxes
Hi. I have an sql query that i use to insert articles to a sql databse table and for that i use addWithValue to select witch textboxes etc goes where in the database. Now i need to retrive these values and place them back into some other textboxes (some of them multiline) ,and i wonder if there are any similar ways to retrive values like AddWithparameter so i can easily do textBox.text = //whatever goes here ?
View Replies !
Ca't Insert Textboxes Values Into A Database Table
Hello, my problem is that I have 2 textboxes and when the user writes somthing and clicks the submit button I want these values to be stored in a database table. I am using the following code but nothing seems to hapen. Do I have a problem with the Query (Insert)??? Or do I miss something else. Please respond as I can't find this. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Manufacturer2.aspx.cs" Inherits="Manufacturer2" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"><title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <asp:Label ID="Label1" runat="server" Text="Name"></asp:Label> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br /> <asp:Label ID="Label2" runat="server" Text="Password"></asp:Label> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> <br /> <br /> <asp:Button ID="Button1" runat="server" Text="Submit" OnClick="Button1_Click" /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="INSERT INTO Manufacturer(Name, Password) VALUES (@TextBox1, @TextBox2)"> <SelectParameters> <asp:ControlParameter ControlID="TextBox1" Name="TextBox1" PropertyName="Text" /> <asp:ControlParameter ControlID="TextBox2" Name="TextBox2" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> </div></form> </body></html>
View Replies !
Setting Navigation Properties On Multiple Textboxes
Hello all... Is there a simple way to set the navigation properties on multiple textboxes simultaneously, without messing with the XML? For example... For each row, the user wants to be able to drill down to the same report. The row has 12 columns. I have not found a way to affect the entire row at once. Thanks! BobP
View Replies !
Handling Large Data Values In Textboxes
Hi, Ive got a report using a List item that is vertically displaying the columns from a table. The problem I run into, is that some of the fields in this table contain large blocks of text where the users have entered comments and such. I am using Textboxes to display this data. So my report will look something like ----- Field label 1 Field value 1 Field label 2 Field value 2 Field label 3 <white space> <page break> Field value 3 ---> this is a big block of text Field label 4 Field value 4 etc ------ It appears as though the report attempts to keep the contents of each textbox together even if that means breaking onto an entirely new page to do this. I would prefer for the data to flow more natrually instead where the page breaks in the middle of the data being displayed should it be too large to fit on the page it started on. ----- Field label 1 Field value 1 Field label 2 Field value 2 Field label 3 Field value 3 --- As much as can fit on this page <page break> Field value 3 ---> remaining data that broke over the page Field label 4 Field value 4 etc ------ Any suggestions would be apprecaited.
View Replies !
Summing Textboxes With Values From Diff. Datasets
hello, I have the following and what to do SUM the valueS in each in another textbox, what is the proper method? =count(Fields!Month_Submitted.Value, "SALES") =count(Fields!Month_Submitted_1.Value, "SALESDIR") =count(Fields!Month_Submitted_2.Value, "SALESVP") =count(Fields!Month_Submitted_3.Value, "CREDIT") Thanks, Rhonda
View Replies !
Garbled Text In TextBoxes Containing VbCrLf When Exported To PDF
Hi I am using SSRS 2005 on a development server. The access is over https. Whenever a TextBox of a report contains a vbCrLf and this report is exported to PDF this text is garbled. Text not containing CR LF is ok. The text is still latin characters but has nothing to do with the text intended to show. Character spacing is broken. Sometimes more than one character are rendered over each other. I do not have the same problem on a production SSRS box. The only difference is that the development box has .NET framework 3.5 installed and production is still on 2.0 Is this a known issue? Maybe there is already a patch? orbit
View Replies !
Bind A Variable To A SQL Data Source For Labels, Textboxes, Etc.
I am trying to set a variable to be passed to my asp page but the value is not carrying over. I don't even know if this is supposed to work or not below: <td colspan="3" style="font-size: 10pt; vertical-align: top; color: <%=Div7fontcolor%>; background-color: <%=Div7bgcolor%>; text-align: center; width: 0px;" id="TopBox" runat="server"> The above Div7fontcolor and Div7bgcolor are variables that I set in the VB file as shown below: Dim obConnection As SqlConnection = New SqlConnection("Data Source=localhostsqlexpress;Initial Catalog=OrgBoard;Integrated Security=True")Dim obCommand As SqlCommand = New SqlCommand("SELECT Divisions.*, Dept19.*, Dept20.*, Dept21.*, ConfigDisplay.* FROM Divisions CROSS JOIN Dept19 CROSS JOIN Dept20 CROSS JOIN Dept21 CROSS JOIN ConfigDisplay", obConnection) obConnection.Open()Dim dr As SqlDataReader = obCommand.ExecuteReader() dr.Read() Dim Div7bgcolor As String = dr("Div7color").ToString().Trim()Dim Div7fontcolor As String = dr("Div7textcolor").ToString().Trim() dr.Close() obConnection.Close() The web page runs fine with no errors but the value does not carry over and change the property correctly. I am able to set the bgColor value of the TopBox within the VB file if I use "TopBox.BgColor = Div7bgcolor" but I can't set other values on my web page like the font color. If I can do this from the VB file then please correct me. Using variables within the page will allow me to set almost any value but I don't even know if what I want is possible. Any help is greatly apprectiated. Thank you, Kris
View Replies !
Calculating Textboxes Values Grouped In Diferent Lists
I have to Lists filtered by the same field. One List shows all records with the field IsClokedIn value = TRUE and the other list =FALSE. I have only one dataset that retrieve the ClockIn and Clock out for one user. In a perfect world, the user MUST clock in and always clock out. So, when i created my dataset i ordered by UserClockingID (whick is primary key). So, this MUST retrieve a dataset with alternate records IN / OUT (TRUE or FALSE) Ex. UserClokingID UserID Time IsClockedIN 2323 34 8:32:03 TRUE 2324 34 12:07:02 FALSE 2325 34 13:05:03 TRUE 2326 34 14:53:02 FALSE 2327 34 15:10:03 TRUE 2328 34 17:32:02 FALSE All i need is to calculate (sum then divide by 60) the minutes returned by the method DateDiff between the first row in my TRUE filtered list and the first row in my FALSE filetered list... and so on for the 2nd, 3rd ..... I can get the minutes by taking the values directly from the Fields!IsClockedIn.Value and using a condition to "grab" the previous record if the current record ClockedIn.Value=FALSE. I already did that. my problem is that when i try to perform a calculation of textboxes values(those with the ammount of minutes for every pair of records from the datalist) out of the group. It says you can only do that inside the group or dataregion. Is there any work around? I really need to get this solved.
View Replies !
|
TRACKER
