I need a stacked bar chart that would simulate inventory status over time. It shows status for one day. The user can choose which day.
1. Silverlight 3 application. (Silverlight 3 beta version is available now).
3. Chart will be on a user control
[url removed, login to view] data source is a web service that reads from an sql server 2008 table:
CREATE TABLE [dbo].[SCS_SKUsimulate](
[Day] [int] NOT NULL,
[scs_sku_id] [int] NOT NULL, -- X-axis Label for each stacked bar
[dDate] [date] NULL,
[Obj] [int] NULL, -- Series 6 This will NOT be a column but will be a line or just points. It is a constant for all x-values.
[CCR] [int] NULL, -- Series 1 (Magenta)
[DI] [int] NULL, -- Series 2 (Cyan)
[DInow] [int] NULL,
[WIPb] [int] NULL, -- Series 3 (Yellow)
[WIPa] [int] NULL, -- Series 4 (YellowGreen)
[OnHand] [int] NULL, -- NetOnhand= [OnHand] - [DO] is Series 5 (Green); if negative, bar should extend downward from zero line of x-axis.
[DO] [int] NULL,
[WIPaNow] [int] NULL,
[WIPbNow] [int] NULL,
CONSTRAINT [PK_SCS_SKUsimulate_1] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
5. User will control the chart by:
- A "next" button that advances data by one day
- A choice of days (e.g. 1-365) that displays data for that day.
- A "recalculate" button that recalculates data and stores it in the source table "SCS_SKUsimulate" based upon these user inputs in text boxes:
- Lead time, WIPb to WIPa
- Lead time, WIPa to NetOnHand
- Lead time, CCR to DI
I will provide a stored procedure that does the above calculation.
6. When the NetOnHand Series value is negative, its bar should start at y-value zero and extend downward. (Unless you can find another good way to show it.)
7. The chart could be built using the Microsoft chart component here:
[url removed, login to view]
This one is almost what I need but it is a bar chart, not a stacked bar.
An advantage of this one is rather direct control by the programmer, compared to other non-Microsoft controls, and fast screen refresh.
Or the chart could be built using another component if it is Telerik or if it is cheap. The Telerik silverlight chart would be OK because I already pay for Telerik controls.
However some controls may not have the features we need or may be too slow. (The Telerik silverlight chart cannot do the negative bar mentioned in #6 above)
8. A Legend should show name & color of each bar.
We can providfe you with a custom charting control meeting your specification for 500 dollars and 5 working days. We are one of the leading providers of Sivlerlight solutions in Idaho.