This is a migrated thread and some comments may be shown as answers.

Help With Chart (Progress / Workflow Indicator)

0 Answers 35 Views
Chart (Obsolete)
This is a migrated thread and some comments may be shown as answers.
Mick
Top achievements
Rank 1
Mick asked on 03 Dec 2008, 04:03 PM
Hi All,
I have the following SQL Table, which represents the number of steps required (in order) to complete an application (Simplified):
CREATE TABLE [dbo].[tblWorkflowSteps](  
    [WFID] [int] IDENTITY(1,1) NOT NULL,  
    [Description] [varchar](500) COLLATE Latin1_General_CI_AS NOT NULL,  
    CONSTRAINT [PK_tblWorkflowSteps] PRIMARY KEY CLUSTERED   
(  
    [WFID] ASC 
)WITH (IGNORE_DUP_KEY = OFFON [PRIMARY]  
ON [PRIMARY]  
 
GO  
SET ANSI_PADDING OFF 

I also have the following table, which records application details (again simplified):
CREATE TABLE [dbo].[tblApplications](  
    [AppID] [int] IDENTITY(1,1) NOT NULL,  
    [Completed] [bitNULL,  
    [Stage] int NOT NULL,  
 CONSTRAINT [PK_tblApplications] PRIMARY KEY CLUSTERED   
(  
    [AppID] ASC 
)WITH (IGNORE_DUP_KEY = OFFON [PRIMARY]  
ON [PRIMARY]  
 
GO  
SET ANSI_PADDING OFF 
(stage is actually a foreign key referencing the the workflowID WFID of the first table)
Basically what I am looking for is a really simple char, which will list the workflow steps descriptions along the bottom, and then a single (horiz) bar, showing the current progress of the application out of all steps.
If anyone could help me with the SQL for this, I would be grateful

Regards
Mick

No answers yet. Maybe you can help?

Tags
Chart (Obsolete)
Asked by
Mick
Top achievements
Rank 1
Share this question
or