Help on access to SQL Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bradley L - 09 Aug 2007 20:52 GMT

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?

Reply to this Message

JohnE - 12 Aug 2007 03:50 GMT

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

> I have an IP2007 Status report form containing a secondary data
> connection to a SQL Server db. The db contains ticketing information
[quoted text clipped - 12 lines]
>
> How's that done?

Reply to this Message