Help on access to SQL Data

[Bradley L]

I have an IP2007 Status report form containing a secondary data
connection to a SQL Server db. The db contains ticketing information
from an IT service request tool.

The form contains a repeating choice group with fields for the ticket
number, details, estimates, etc. The developer selects the ticket
number that they are reporting against and the form uses C# to pull
most of the pertinent info directly into the form.

I'm having trouble with pulling the actual hours spent, however. The
developer records time against a particular ticket and the design is
such that there may be multiple rows of data for one ticket based on
the ticket id and the developer name. I need to step through the data
and sum the time entries.

How's that done?

 

[JohnE]

Bradley, hi. Unfortunately I am not responding to your dilemma but I am
doing something similiar. I just posted my question. My users select a
supervisor name from a drop down list and a button is used for getting the
associated employees and they (hopefully) are displayed in the repeater
table. I am lost on getting the info (all of it) to display. Are you
willing to share how you did it and the C#?
.... John