I have a GridView with a SQL query bound to it. The query uses "Group By" to group together rows which have a particular "person" in the "Tech" column. E.g.
Fred - 01/12/10 - Rebooted machine
Fred - 02/12/10 - Cleared printer jam
Fred - 03/12/10 - Reset password
Susan - 02/12/10 - Changed permissions
Susan - 02/12/10 - Restarted machine
I'm trying to use a ListView to display product specs. I also want to display the group headings such as "Dimensions", "Input Ports", etc.
How do I display these group headers? My code below lists the specs but doesn't show me the header. If I put some static text however, that shows up. What am I doing wrong?
[Code]....
I am trying to figure out the best way to dynamically map time retrieved from a stored procedure with the report headers. For example, if my ReportViewer Headers are the following:
[code].....
I am trying to find a way to have the data dynamically map on the page in the correct location. 7:15 should be placed below the 7 header and between the 15 and 30 numbers as an example. Does any know how this might be coded using tables in the ReportViewer?
I have a table with a field "item id" that I am joining to two other tables that have multiple records for each item id. In other words, I have 1 item id, 5 records in another table tied to this item and 5 records in another table tied to this item. I am trying to build a report that shows the item and then follow the item with two groupings. Each group would of course have the 5 records per the other two tables. Here is my problem. I can get the report to show an item and one of the detail group of 5 records but for the life of me I cannot get the second group of 5 to group and print. Both groups of 5 get either lumped together or it will print them 1 record at a time switching back and forth. How do you do this? Do I have to do something special in the Sql query or something.
View 1 RepliesHow to make group tree wider in crystal report viewer?
I used code below to set CrystalReportViewer (CRV1):
[code]....
I have created one crystal report which has one Group name field too. My Crystal report has 3 pages. But the Group Name field is displayed only in the first page. I want to display the Group Name field in the next pages also.I am using Crystal Reports 2008.
View 1 RepliesI am using latest crystal report version but not getting the option to hide Group Tree and Main Report Tab.
View 1 RepliesI have never work with a repeater and after a lot of research I got to the conclusion that this is the control I need to use for what I have to do. I need display data but I will need 2 headers and after some sort of amount of records the headers will repeat again. In this page you will find an example of what I'm trying to do http://ratings.fide.com/view_source.phtml?code=45276 I don't know if a repeater is the right control but i thin it is.
View 3 Repliesexplain to me the concept of Request.Headers and Response.Headers in ASP.NET? Under what scenarios you use Request.Headers and Response.Headers?
View 1 RepliesThis group section cannot be printed because its condition field is nonexistent or invalid. Format the section to choose another condition field. Error in File Detailed_CrystalReport {9C8154B9-5093-457C-9E6A-2A1D63E7E866}.rpt: Invalid group condition.
without group section report can correctly show report and with group section can correctly show in local computer only with visual studio But with group section has error after deploy to new machine window server 2008 group section is date my crystal report version is 2008, assembly version 12, CRDist x64
try 1: i try to delete the group date and run local, it can correctly show date, but deploy to the new machine date is invisible Group date is wrong the date have only 01/25/2011 however group date become 23/1/2011 why group date is not 01/25/2011?
I have the matrix in the image below. I need to add a total at the bottom of the report to total each column group (total AR,TAK,EU etc).
If i had a subtotal it totals each row separately. I need the grand total. Is this possible?
[code]....
Given all the research I've done, I don't think this is possible - am I correct? I've been all over the web looking for ways to do this. My grid needs to scroll vertically, horizontally, sort, and go into edit mode. I've been able to do the "cheap" solution where a table sits above the grid to hold the column names, but this does not work well with putting the grid into edit mode or scrolling horizontally. In both cases, the columns become out of synch with their headers. My organization will not pay for a grid, so JQGrid is out. So, since the 'expression' capability has been removed from IE8, we are left with no possibilities for fixed column headers?
I'm not advanced enough in JQuery to do this...but wouldn't it be possible to create a JQuery function that copies the grid header row to a div that sits above the grid, so that the headers are always visible? (And hide the original grid header row). Anyone want to take a crack at it? Maybe I'll try but it will probably take me too long.
I changed a gridview's header to ... with
Sub MakeAccessible(ByVal grid As GridView)
If grid.Rows.Count > 0 Then
grid.UseAccessibleHeader = True
grid.HeaderRow.TableSection = TableRowSection.TableHeader
grid.HeaderRow.CssClass = ""
'grid.FooterRow.TableSection = TableRowSection.TableFooter
End If
End Sub
Now I need to add attributes to the th tags like th xyz=boom.
I need to display the column headers to the left within ASP.NET? how to do that?
View 1 RepliesI want the headers of my gridview to be hyperlinks, without the "SortExpression"...I searched the net, but I've been not very succesful.
For example: when clicking on the header of a simple gridview, the site navigates to a webpage. Is it possible?
I need to use a grid that allows for filtering in the column headers. I know there are some third-party components out there that cost money. I am looking for something that is free / open-source that can be used on a project. Is anyone aware of a GridView that can do this?
View 2 RepliesI want to freeze GridView headers.
View 1 RepliesI wanted to have fixed headers in grid view. I came across multiple solutions but none worked with IE 8 and Chrome. One of the best solutions is following:
<style type="text/css">
<!--
.DataGridFixedHeader {background-color: white; position:relative; top:expression(this.offsetParent.scrollTop);}
-->
</style>
I am using the ASP.NET3.5 gridview control in a new project. My problem is that the gridview presents data in basic tabular format, whereas I want a grid with row header / grouping behaviors. An example of this would be Outlook web interface, which can group emails by date, as well as allowing you to select individual emails to display.
My problem: I can't see how this could be easily done with Gridview? I did find a product called Telerik that has a seemingly fancy Gridview, but I am hesitant to spend money on a single components that now also locks me into a third-party framework...
What is the best way to format a grid, (or any other control) in this format?
Header1 Header2
A B C D Header3 Header4 header5
row
row
row
row
row
Header3 Header4
row
eader5 Header6 header7 header8
row
row
row
footer data
is this format even possible?
I have a couple of Textboxes in a Gridview header, mainly used to search for items in the dataset. This works fine; however, on Post Back, the textboxes do not hold the entered text. The View State is enabled for these control items.
View 4 RepliesI have the following output from a SQL Datasource that I would like to separate into the Giant Sets...
Giant Set 1 Exercise 1 10 reps
Giant Set 1 Exercise 2 15 reps
Giant Set 1 Exercise 3 10 reps
Giant Set 2 Exercise 1 15 reps
Giant Set 2 Exercise 2 15 reps
Giant Set 2 Exercise 3 15 reps
So I want it to look like this...
Giant Set 1
Exercise 1 10 reps
Exercise 2 15 reps
Exercise 3 10 reps
Giant Set 2
Exercise 1 15 reps
Exercise 2 15 reps
Exercise 3 15 reps
Is this possible with a gridview?
I want scrollable gridview with fixed header. For that i create belw code
[Code]....
It works fine uptil page loads.I have functionality to delete rows from gridview.Once i click delete button from gridview the width of header columns get decreased then the width od data inside gridview.It means depending on the content of data the size gets variable.HOW to show data inside gridview irrespective of the content of data.
I have written a code from here http://www.aspsnippets.com/Articles/Display-GridView-with-Empty-Message-and-Header-and-Footer-when-no-data-in-ASP.Net.aspx. I just edited this as follows. this is my gridview code:-
<asp:GridView ID="gvCustomers" runat="server" Width="550px" AutoGenerateColumns="false"
Font-Names="Arial" Font-Size="11pt" AlternatingRowStyle-BackColor="#C2D69B" HeaderStyle-BackColor="green"
AllowPaging="true" PageSize="10">
<Columns>
<asp:BoundField HeaderText="State Name" DataField="StateName" FooterText="Footer" />
<asp:BoundField HeaderText="Organizatio Name" DataField="OrganizatioName" FooterText="Footer" />
<asp:BoundField HeaderText="Partner Name" DataField="PartnerName" FooterText="Footer" />
</Columns>
<AlternatingRowStyle BackColor="#C2D69B" />
<EmptyDataTemplate>
<table cellspacing="0" rules="all" style="font-family: Arial;
font-size: 11pt; width: 550px; border-collapse: collapse;">
<tr style="background-color: Green;">
<th scope="col">
State Name
</th>
<th scope="col">
Organization Name
</th>
<th scope="col">
Partner Name
</th>
</tr>
<tr>
<td colspan = "3" align = "center">
No Data found.
</td>
</tr>
</table>
</EmptyDataTemplate>
</asp:GridView>
and my code file code is as follows
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["contest"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind_Grid();
}
}
protected void Bind_Grid()
{
string strSql = "select * from mtblInformation";
SqlCommand com = new SqlCommand(strSql,con);
SqlDataAdapter sda = new SqlDataAdapter(com);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
gvCustomers.DataSource = dt;
gvCustomers.DataBind();
}
}
when in database table have records then gridview binds and its showing records, But when there is no record in DB , instead of showing msgs that "No Data found." gridview doesn't appear.
I would like to create a gridview which has as headers the last 12 months, which would need to change as time progresses... is it possible to do this?
View 24 Replies