Sum of the time base by date

Hi all,

Please suggest us.

My xml file is

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="Y:\02-Thomson\Users\APT\xsl\vinoth-new.xsl"?>
<report>
<production>
<dept></dept>
<etype>Break</etype>
<user>thiyagu</user>
<date>2/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
<production>
<etype>job</etype>
<user>thiyagu</user>
<date>2/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>XML QC</comment>
</production>
<production>
<etype>Break</etype>
<user>thiyagu</user>
<date>3/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
<production>
<etype>Job</etype>
<user>thiyagu</user>
<date>3/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>XMl QC</comment>
</production>
</report>

I want the sum of the total time of the user based by date.

Advance thanks for ur help

Mar 10 '08 #1

Subscribe Post Reply

1306

saran3b2

Hi,

I got the result for this. Please ignore it.

Any way solution is

<xsl:value-of select="sum($report[date=$date][user=$user]/totaltime)"/>

QUOTE=saran3b2]Hi all,

Please suggest us.

My xml file is

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="Y:\02-Thomson\Users\APT\xsl\vinoth-new.xsl"?>
<report>
<production>
<dept></dept>
<etype>Break</etype>
<user>thiyagu</user>
<date>2/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
<production>
<etype>job</etype>
<user>thiyagu</user>
<date>2/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>XML QC</comment>
</production>
<production>
<etype>Break</etype>
<user>thiyagu</user>
<date>3/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
<production>
<etype>Job</etype>
<user>thiyagu</user>
<date>3/5/2008</date>
<book>Traning</book>
<file>Programming</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:24:23 PM</starttime>
<endtime>11:46:21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>XMl QC</comment>
</production>
</report>

I want the sum of the total time of the user based by date.

Advance thanks for ur help[/quote]

Mar 10 '08 #2

Similar topics

Adding a time column to a date column

by: Lauren Quantrell | last post by:

I have two columns in a table: StartDate DateTime and StartTime DateTime. The StartDate column holds a value such as 07/16/2004 The StartTime column holds a value such as 3:00:00 PM I want to...

Microsoft SQL Server

Unix Time

by: Tom | last post by:

A field in a data set I want to import into Access is in Unix time (seconds from a certain time on a certain date). Does anyone know the precise date and the precise time on that date that Unix is...

Microsoft Access / VBA

Adding Time

by: Nicolas Mejia | last post by:

Hello: I´m not a professional programer in Access. I´m working in a proyect that will permit me add my flight time, but I have been having problems with the time adding. Please can some one...

Microsoft Access / VBA

DataSet Textbox Time

by: Steve B. | last post by:

Using: VS dB: MS-Access Although the the DataGrid displays the proper date from an Access file (Date/Time DataType) an adjacent bound textbox for that same DataGrid field displays the date and...

C# / C Sharp

Managing files by Create time/date

by: Bob Achgill | last post by:

I would like to use the timestamp on files to manage the currency of support files for my VB windows application. In this case I would only put the timestamp of the file in the management database...

Visual Basic .NET

Q: Time and Date

by: Geoff Jones | last post by:

Hi I have question regarding times and dates in a datatable. I have one table with one column having the date e.g.03/09/04, and another column other the time 08:03:05. The other table has one...

Visual Basic .NET

Time Conversion

by: moni | last post by:

Hi, I wanted to convert a time value in the form of time_t into a readable form in C# or vice versa, in order to be able to subtract two time values and give the result in msecs. eg. I...

C# / C Sharp

Time Zone and DateTime voes.

by: Satish Itty | last post by:

Hi all, I have a big problem in my hands and not sure how I can fix this. Any suggestions would be greatly appreciated. I have a .NET 3 tier app developed in VS2003 and .NET 1.1. the client is a...

.NET Framework

Essential SQL Server Date, Time and DateTime Functions

by: yasirmturk | last post by:

Standard Date and Time Functions The essential date and time functions that every SQL Server database should have to ensure that you can easily manipulate dates and times without the need for any...

Microsoft SQL Server

Time comparison problem in a query

by: Jim Mandala | last post by:

Using MS Access 2003 with SQL Server 2005 as a backend: I am trying to automatically check for collisions in a table of appointments with an appointment currenlty being saved from the form...

Microsoft Access / VBA

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server