Forms Data Controls :: Calculating Percentage Of Scheduled Hours?

Aug 30, 2010

I want to calcultae how many employees are scheduled less 24 hrs for each week,b/w 24 and 48 and greater than 48

In excel file i have weekly wise total hours scheduled for each employee and total no of days scheduled in week(example 6 days and 1 off)which i will upload it to database,based on this i want to display reports in bound controls Result should be like this

Scheduled Hrs 8/1/2010
8/8/2010 8/15/2010 8/22/2010
Less than 24 hrs 5% 5% 5% 5%
Between 24 and 48 hrs 5% 6* 3% 4%
greater tan 48 hrs 90% 89% 92% 91%

can u tell me Which control to use and words in bold are headers and dates should be dyanamic this month it is like shown above, next week it will header should be dynamic.

View 3 Replies

Similar Messages:

How To Calculate The Percentage Of Scheduled Hours

Aug 30, 2010

I have weekly wise scheduled hours of each employee and no of days scheduled for each employee,now i need to calculate no of employees scheduled less than 24 hours,no of emp's scheduled b/w 24 and 48 hrs and emp's scheduled more than 48 hrs in percentage for fisrt week,second week,3rd week and 4th week.

Like this

SCheduled Hrs 8/1/2010 8/8/2010 8/15/2010 8/22/2010

Less tha 24 hrs 5% 5% 5% 5%

b/w 24 and 48 hrs 4% 5% 5% 5%

>48 91% 90% 90% 90%

View 5 Replies

Forms Data Controls :: Calculating Total In Footer And Percentage In Gridview Cell ?

Feb 2, 2010

i have gridview and data is binded during page load ... below Name,Marks,percent are templatefields.. iam able to to calculate total in footer of Marks column.. but can any one tell me how to calculate the percentage depending upon total value for percentage column... iam calculating total in gridview_rowdatabound event

eg: Name Marks percent

abs 50 25% ie (50/200) *100

bpd 25 12.5%

hlkr 75 37.5%

fdh 50 25%

Total 200

View 1 Replies

Calculating Years, Months, Days, Hours, Minutes, Seconds Between Two Dates?

Oct 20, 2010

I'm trying to calculate the yrs, months, days, hours, mins, seconds between two dates with sql server or c# (ive just used sql more).

I have some code below that I started, but I get some negative values for months, values over 31 for months, and there very well could be more issues. Honestly my math is not the greatest and Im just not sure how to fix it. I want the user to be able to enter their birthday and for it to calculate the yrs, months, days, hours, mins, and seconds they have been alive.


View 5 Replies

Forms Data Controls :: Calculating Cells In A Gridview?

Feb 12, 2010

I have a gridview where I placed several item templates with text boxes in them. I want to enter a number in the text boxes and have the total displayed in the footer.

The last footer template is where I want to display the total. I've placed a label there.

Here's my Gridview


View 4 Replies

Forms Data Controls :: Calculating Total In A Gridview?

Mar 28, 2011

I want to calculate total in a gridview and i want to show it in gridview footer below is my code


the problem is when i debug the code im getting null value into the textbox,i dont know why?my price comes from db and i enter quantity into the tetxbox any help on this problem??


View 12 Replies

Forms Data Controls :: Validate Column Where Sum < 100 Percentage?

Jan 8, 2011

I have a gridview in which I have a column for Percentage and I enable footer to display the totol of that columnI have in my grid Edit and Delete template column...I need to validate when user click Edit if he inserts a value inside the textbox of a row in the column Percentagenot to exceed the 100 % ..the sum of all rows should be 100 % but i need to validate by a message to ask user :please insert another value cause sum is exceding 100 % then he can clicks on updateI want to validate the data where sum of values of all rows of "Percentage Column" should not exceed 100. If it exceeds more than 100, a pop up window needs to be shown saying "value exceeds 100, Re-enter" and . All of this validation should happen with out a postback.

View 1 Replies

Forms Data Controls :: Calculating Age And Showing In Gridview Column?

Dec 29, 2010

I have a gridview, which has bound field as "Birth Date", which is coming from the database. I want to show another field in the gridview as "Age", which should calculate age, Which should be Birth date - system date.


How to Calculate the age display the age in gridview columns.

View 3 Replies

Forms Data Controls :: Calculating Total Inside A Gridview?

Mar 26, 2011

I want to calculate total inside a gridview and i want to display in footer row below is my code


But i am unable to get the quantity in the textbox when i enter a quantity it is showing null into the tetxbox and i have different prices for the items when ever i enter quantity for a price i am getting only the starting price of the item.Another problem is when i click button once the page is getting posted back when i click second time the event is getting fired i dont know why?

View 4 Replies

Forms Data Controls :: Chart Label Display (Percentage Of Available Time)

Jul 12, 2010

I have a chart to display the percentage of available time for a machine, but it won't display all the labels. It will only display a select few, spread out evenly apart but I need it to show ALL of them. Here is how it's set up, however, I don't know what I would change in order for it to display all labels:

View 1 Replies

Forms Data Controls :: Calculating Template In GridView Total Using JavaScript?

Mar 10, 2011

I have a gridview with one Tempate field, i want sum the particular template to show result in fodder template textbox, following liks i tried... but not use,


View 10 Replies

Forms Data Controls :: Calculating Total Of Template Textbox Inside Gridview?

Oct 4, 2010

I have been asking this for a long time.But the answer what i get is not want i need.I have a gridview with two template text box (t1 and t2) inside gridview and four textboxes outside the gridview on the form (txt1,txt2,txt3,txt4).All these textboxes allow only integer value to be entered.What i need is to get the total of all these textboxes (ie,template textboxes as well as textboxes outside gridview) in a textbox named Total at the same time we enter values in a textbox.Also if i change the value of a textbox later that too should be reflected in the Total textbox .I know how to calculate the total of the textboxes outside the gridview.But i need the total of all textboxes including template as well as textboxes outside simultaneously

View 4 Replies

Data Controls :: Calculating Values Taken From Different Textboxes And Store In Another

Apr 27, 2016

I want to calculate the service tax on some amount. The value of service tax must be taken from textbox1.text and amount from textbox2.text and then after calculating it must be store in another textbox say,textbox3.text

service tax = textbox1.text - 14.5%amount = textbox2.text - 44000total amount= textbox3.text -((14.5*44000)/100 )+ 44000 ;

The Value of ((14.5*44000)/100 )+ 44000 after calculating will be store in textbox3.text

View 1 Replies

Data Controls :: Show Percentage Progress Bar While Inserting Data

May 7, 2015

I am inserting data from gridview to database with checkbox selected item and my requirement is i need to show progress bar in each checked row..i.e if data is inserting the current row should show as inprogress status after that it should say that the process is completed..and so on for all rows how to achieve this..

View 1 Replies

Gridview Footer / Total Hours In The Footer (sum Of Hours For All Rows)?

Jan 29, 2011

I have a grid view which contains Hours as one of the columns.. now, i need to have a total hours in the footer (sum of hours for all rows).

View 2 Replies

DataSource Controls :: DTS Runs Manually But Not Scheduled?

Nov 15, 2010

I have a DTS package that runs fine manually but gives the follow error when I create a job for it:

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005)
Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0

The package logs into a Teradata source and fill a local SQL table. That's it!

View 4 Replies

Controls :: Send Scheduled SMS Automatically From Website

Jul 18, 2013

I am a .net developer. I am developing an application in which i need to send scheduled sms to users mobile number which is stored in database(SQl Server 2008) automatically.

I have already buy sms gateway. How can I do this. Is there any way to call a page automatically periodically.?

View 1 Replies

DataSource Controls :: Calculating Sum Of A Column?

Mar 31, 2010

i have a button and in click event i want to take the SUM() of a one cloumn and assign it into a integer and if that integer is > 20 display "pass" or something

i've tried many ways but non worked.

View 8 Replies

DataSource Controls :: Calculate Percentage From Table?

Jun 22, 2010

I have a table that contain the votes(publicVotes) against each contestant. Now what i am trying to do is to calculate the percentage of votes each contestant recieved according to the column SchedularID. how i can get it done and would it be easy to user store procedure or view?


View 10 Replies

Web Forms :: How To Run Aspx Code As Scheduled Job

May 19, 2010

I have some code written in a method of an aspx page which I would also like to run as scheduled job on my in Windows Server 2008. How do I accomplish this?

View 5 Replies

AJAX :: Update Progress With Percentage While Data Access From Database?

Dec 20, 2010

How can i use update progress(in with percentage (may be with remaining time span or remaining under process records) while data access from database but that should not be fixed for a fix time period by using like Thread.Sleep(5000). It should show for the actual accessing time period.

View 2 Replies

SQL Server :: Get Data During Last 24 Hours?

Aug 15, 2010

How do I get the data during last 24 hours ?

View 5 Replies

Show Data 24 Hours?

Nov 22, 2010

i have 30 data. i want show 24 hours at 24 hours only a data.

View 11 Replies

Web Forms :: How To Add Task In Windows Scheduled Tasks

Mar 14, 2011

How can I add a Task in Windows Scheduled Tasks using Asp.Net.

View 3 Replies

Creating Data With Hours And Minutes?

Jan 12, 2010

I have a textfield where they can enter a date, a hour drop down and a minute dropdown.

What I would like to do is after i get the values for each to create a DateObject which has all 3. i.e 12/02/2009 15:36

But then also how dismantle the Date Object to get back my 3 individual values

View 4 Replies

Copyrights 2005-15, All rights reserved