I have several repeaters on the same page. They are not nested. Because of design and database issues I had to keep them independent. I need to total the amount in a particular column for all repeaters. Is there a common approach to this or do I have to hack something?
View 1 Repliesi am using sql server reporting service, in My report i have a Salaray column in which i have to show the page wise totals in every page and grand total in last page..
example : first page salary total - 10000
second page salary total - first page total(10000) + second page total and so on I did use the =sum(ReportItem("Salary").value) but it does not consider the previous page value..
i have gridview as below...
i just want to add in a totals column at the end of this? that counts the figures from 8,9,10....17,18 etc:
ID
User
Type
Department
Date
Count
8
9
10
11
12
13
14
15
16
17
18
3207
BRADFORDAmyWh
Invoice
Mass Market
08/11/2010 00:00:00
0
23
21
0
0
0
0
0
0
0
0
3208
BRADFORDDominikaP
Tickets
Mass Market
08/11/2010 00:00:00
0
30
20
0
37
18
10
14
26
0
0
BRADFORDDominikaP
Team Brief
Mass Market
08/11/2010 00:00:00
0
0
15
0
0
0
0
0
0
0
0
I have a Gridview that shows records from a table of punch times.
PunchID,PunchTime,PunchType
1 , 8:00 AM , start
2 , 11:00 AM , end
3 , 12:00 PM , start
4 , 16:25 PM , end
I would like to get a total time. (ie in this case 7:25 )
I have implemented column tolals in the footer of my gridview using the technicque described in this article [URL] .
Now I would like to have a total of the 7 column totals that are displayed in the footer. Can anyone tell me how to do this. I would like to display this in a label or an addition row in the footer if that is possible.
I am having problems with displaying the totals in the footer of a gridview. I am writing a page whereby users can enter comments and marks for an online photo competition.
The page has a details view to enter the comment and mark. Its has a details view where the photo is displayed. It has a gridview where the comments and marks that have been entered are displayed.
It works well - the details view allows comment and mark entry and the gridview show the comments and marks as they are entered. The problems are twofold. Firstly the total shows double the marks that should be displayed. Secondly, when you leave the page and then return later, you have to refresh the page before it will show the latest comment and mark even though it shows this immediately after entering the data.
Ive provided my code below:
[code]....
i ve googled this and admitly there is a lot of information out there but it all seems so complex just to add a "totals" column basically, i have a gridview as below
[code]....
Basically i want to add a column at the end that adds the totals of the columns 8,9,10,11,12 etc etc
i know theres a lot of blogs out there but they seem to complicate this more then it should ...
am developing web application using csharp using visual studio 2005.I have the records that are being displayed on gridview. Now I want two columns to have a culumativetotals.How can I achieve this? data is as follows: How can I achieve Comulative totals as in Column 4.
View 2 RepliesI have a table with articles. Every article has a column named category which value is either 1 or 2 On my landingpage the article headers are displayed as hyperlinks. All the articles with category 1 will be displayed in a repeater control on the left side of page and all the articles with category 2 will be displayed in another repeater control on right side of page. I know I can bind the repeaters to two different sqldatasource controls with different SELECT statements. But I wonder if I can do this by only using one sqldatasource control, and if this is better and proper way of doing it. If so, do I create a (datatable?) and do the sorting there?
View 5 RepliesI have a gridview with the following in the code behind file. Every once in a while when I open the page the totals in my grid footer are 3 times what they should be. Should I be doing something in this code that I'm not currently doing, in order to prevent this? The count of rows is always correct, but the sum of the amounts is where the issue is.
These are my variables that are at the top of the code behind file.
[code]....
I have developed my application using ASP.NET with Visual Basic. I have a table that contains 3 fields. The name of the table is "Customer" and the names of the fields are "Name", "Address", and "Amount". I have a gridview that displays these three columns. I want to summarize the value in the "Amount" column for each record and display the summarize value in the footer of the "Amount" column.
I added some code to the "ItemTemplate" and "FooterTemplate" of the template for the "Amount" field and wrote two functions One function adds the value of the "Amount" field to a variable called "TotalAmount" and the second function 'gets' the value stored in the "TotalAmount" variable.
I am not getting any error messages and all of the items are displayed in the gridview but I am not displaying anything at the bottom of the "Amount" column. What more do I need to do?
This is my code for the "Amount" template:
<asp:TemplateField
HeaderText="Amount"
SortExpression="Amount">
<EditItemTemplate>
<asp:TextBox
ID="TextBox1"
runat="server"
Text='<%# Bind("Amount") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label
ID="Label1"
runat="server"
Text='<%# Bind("Amount", "{0:c}") %>'>
<%#SumAmount(Eval("Amount")) %></asp:Label>
</ItemTemplate>
<FooterTemplate>
<%#GetTotalAmount() %></FooterTemplate>
<FooterStyle
BorderColor="Black"
BorderStyle="Solid"
/>
</asp:TemplateField>
This is the code in my .vp file
Dim TotalAmount as decimal 0.0
Function SumAmount(ByVal Amount
As
Decimal)
As
Decimal
TotalAmount = TotalAmount + TotalAmount
End
Function
Function GetTotalAmount()
As
Decimal
Return TotalAmount
End
Function
I can add a row to the bottom of a listivew by inserting a table after the layouttemplate in a listview. It works fine for me to call the added controls from code-behind and chane the control values. Since my listview changes width dynamically depending on the contents of the data, my added table columns don't match up.
I have tried to access the width property of the table and then match the new ones with codebhind, but it doesn't seem to work.
I am simply trying to add a row to the bottom of the listview to provide for totals of the columnts. What is the best way to to that?
I have a set of records that will go into a repeater, however, the query being used has a grouping on it and i need to apply this to the repeater i.e.
GROUP NAME
Record 1
Record 3
GROUP NAME
Record 2
Can this be done?
First, I'm needing to report info from a database (currently an Access database that will be migrated to a SQL database shortly). There are too many fields in the database to just let them go on and on across the page. I've got the first repeater working GREAT! but none of the other repeaters populate at all.
[Code]....
[Code]....
I use if(! Page.postback) to fill those two repeaters I want to get the data related to checked checkboxes when using the below code it get only the data of the first checked box how to make it brign all the data
private void Btn_Confirm_Click(object sender, System.EventArgs e)
{
//CheckBox checkedButton = null;
foreach (RepeaterItem item in ParentRepeater.Items)
{
CheckBox control=(CheckBox)item.FindControl("CheckBox1");
if (control.Checked)
{
//checkedButton = control;
foreach(DataRow r in GetInnerData(control.Text).Rows ) // GetInnerData is used to pring datarelated to the selected check box
{
if(r["DESCRIPTION"].ToString() == control.Text)
{
Response.Write(r["DESCRIPTION"].ToString() + r["Date" ].ToString() + r[ "Trx" ].ToString() + r[ "GL" ].ToString() + r["Amount" ].ToString() +"
");
}
}
control.Dispose();
//checkedButton.Dispose();
break;
}
}
}
}
I am having trouble getting the following code to display side by side in a table. At the moment it displays next to each other in different cells but the cell on the right stretches further down than i would like, the opening item in the cell - <%#Eval("Product_ID") %> - is level with the end of the image in the cell on the left and everything else continues on new lines below it, when what i was hoping would happen would be for the product id to be directly across from the top of the image and the rest of the items to go below that. I have tried datalists and detailsview but they do not give me what i want either
[Code]....
i did like all instruction in this link
[URL]
but i have a problem,this erer arise "Can not find tabel1"
In my gridview, I want to count the number of times each value (based of course on a field in my gridview) occurs. For example, if I have a field called Dept, in my result there is the following:
Dept A
Dept A
Dept A
Dept B
Dept B
Dept C
What I am trying to do is to show that for each Dept A, the count is 3, and for Dept B, the count is 2 and for Dept C the count is 1. When I have my count, I want to save them into my hidden field, which I am going to use else where in my code.
I know I need to do this in my rowdatabound event, and I have had ago, but the results I am getting back are not correct.
I am have created the link in the gridview datarow and have redirected the querystring to a new page, however how do I make the count of the new page based on the querystring? Essentially, I would like to count and display in a textbox the number of times a user has clicked on the selected row.
View 3 RepliesI have 3 nested repeaters and in my code behind I can't seem to lock onto the second level repeater. I have written code for the third level but I will once I figure out how to get to the second level. My code is written below.
[Code]....
CODE-BEHIND
[Code]....
For the solution, I cannot use any event handling methods, because my webapp is fully ajax based and no complete postback is possible. So here's the problem.I have a `List<WebPage>` that contains a list of Links `(List<Link>)` and I need for all the links to bind repetitive information such as page title, id, url. Here is my current repeater.
<div id="result">
<asp:Repeater runat="server" id="results">
<Itemtemplate> [code]....
i'm using paging in gridview(page size is 10).my problem is when i get the row count it says row count is 10. how can i solve it
[Code]....
I have a rather large formview that asks for a variety of input values (physical totals vs pos report totals). I have created vb code to calculate the differences and subtotals of various types prior to inserting the data so people can check for entry errors.
Its a closing reconciliation form. Here's the problem: If they forget to enter 0 in a field that doesn't have any totals, a big ugly error message displays. I would like to avoid this. I can tell them until I am blue in the face to remember to enter 0 and not leave any blank fields, but realistically its going to happen and I need to handle it in the programming.
I have been struggling to either default the values to zero to start with, replace a null textbox with 0 before the calculate runs...but I can't get anything to really work. What is the best way to handle this?
Here is the aspx page:
[Code]....
And the code behind page with working "Calculate" as long as fields are not left blank (I took out all the test code that made it not work at all)
[Code]....
Finally, the error message I am getting is the following:
[Code]....
I can't seem to find the right combination of programming to account for the "" string to be 0 so that it will add or subtract values in my calculate. I have my sql table setup with default values of 0 so if a field is left blank it will be entered into the database as 0 and not null. It is really just for my inserting of a reconciliation and the running of Calculate Totals to double check their work prior to inserting into the database.
I am using nested repeaters and wanted to access a value from my parent repeater within the child...is this possible?
View 3 RepliesI would like to count the number of page views. I am able to use the global.asax file and a label to obtain this. However, this gives me the total count of the page. That is great, however I like to count the number of users accessing the page when the user clicks on a particular gridview row value from the previous page.
I have a gridview in the gridview a value that links to a new page. This new page contains the row values. I would like to count the number of users who have accessed this new page based on the gridview row value. As such the page count will be different based on each row.