I have a problem when I am exporting my report to Excel.
When exported to excel, I could see the table header on only the first page but not on all the pages. I have also checked the option "Repeat Header rows on New Page", but that didnt work.
I am new to using ASP.NET and I am using a datalist to represent the data obtained from querying a database.However,I am facing 2 issues:
1) If the string returned after querying the database is too long,the datalist is displaying the long string as it is which is not looking good.I am using Eval to fetch the data from the database for the sake of displaying.I need to have some page breaks so that the information fetched is presentable.
2) While repeating the datalist I want to hide all the columns except for 1 column whose value are unique.Upon searching I found this link: http://www.programmingknowledge.com/DataList.aspx but the code is in VB and I am not familiar with it.I am familiar with C#.
I am inserting the front end code for my datalist.I also want to know if datalist is the best control to present the data from the database.
May i use the collapse and expand feature (like tree menu) at Report iam using the Report viewer Control for displaying the Report on my Asp.net Page .
I have number records and each record have detail as i clicked or expand the record then details will be shown is it possible with report viewer control as.
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
I need to break this text on commas in asp:GridView:aaaaaaaaaa,aaaaa,aaaaaaaaaa,asdsad,aasfasfa,sfasfasfsfasfasfa,afasf.This text is stretching field too much.I have tried with css and with label control as field but has no result.
I am using ssrs 2005 .My text field contains the following data As follow : Database is as:i am getting value as :Total Population (in 1000s)but in ssrs it is displaying as like this : (Total Population (in 1000sBut i want as like in Database.Please let me know what is to be done at the earliest
I have a ReportViewer control on my aspx page that displays a report defined in an rdlc file. The rdlc has a textbox on a table control that displays the number of rows on the report.
I am looking for a way to retrieve the value of this textbox in my code-behind.
I have a column in a table that contains a message and I want this message to be displayed in a label. Here is my code which currently doesn't populate the label.
Protected conString As String = ConfigurationManager.AppSettings("sqldirectory") Dim cnn As New SqlConnection(conString) Dim cmd As New SqlCommand("select message from [database].[dbo].[table]") Dim dr As SqlDataReader Try cnn.Open() dr = cmd.ExecuteReader() lblMsg.Text = dr(0).ToString Catch ex As Exception dr = Nothing Finally cnn.Close() End Try
Have an asp.net app with a local rdlc report based off an xsd dataset. Was working fine, but i needed to add another field, so I added it to the dataset through the designer (right click, add column) and then added the field to the rdlc report.
My problem is it won't compile - keep getting the error:
The Value expression for the textbox 'Description' refers to the field 'ShortDesc'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
I've cleared the cache, deleted temporary internet files without luck.
So how do i get the new field to show up for the report?
I have got a label that displays the result of the last action (ie "Success - Record Upload") I also have a Validation Summary and when validation fails i want to clear the label so it no longer displays the result of the last action.
Is it possible to put a column of checkboxes in the ReportViewer so that a user can select multiple records and then click a button to have those records processed as a group?
How do I bound a Label to a datasource and its field?I got set up the datasource to a gridview, but don't know how to bind a label to the same datasource.