• OK, here's the tables:

    CREATE TABLE [dbo].[APPLICATIONS](

    [APPLICATIONS_ID] [varchar](10) NOT NULL,

    [APPL_APPLICANT] [varchar](10) NULL,

    [APPL_START_TERM] [varchar](7) NULL,

    CONSTRAINT [PK_APPLICATIONS] PRIMARY KEY CLUSTERED

    (

    [APPLICATIONS_ID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [IDX]

    ) ON [IDX] TEXTIMAGE_ON [PRIMARY]

    GO

    CREATE TABLE [dbo].[APPL_STATUSES](

    [APPLICATIONS_ID] [varchar](10) NOT NULL,

    [APPL_STATUS] [varchar](5) NULL,

    [APPL_STATUS_DATE] [datetime] NULL,

    CONSTRAINT [PK_APPL_STATUSES] PRIMARY KEY CLUSTERED

    (

    [APPLICATIONS_ID] ASC,

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [IDX]

    ) ON [IDX]

    GO

    The APPLICATIONS table relates to the APPL_STATUSES table by the APPLICATIONS_ID. Whenever a status of an application changes a record is written in APPL_STATUSES along with the status and the date. That is considered the active status until another one comes along with a new date.

    The users want a dashboard to display all this and we are looking at some combination of SSRS/Sharepoint 2010/PerformancePoint.