Jason,
I'm not familiar with how to attach files here, but below are some
snippets of the (sample) report file and data.
In the Cross Tab I want to show the Due Date and Division dimensions as
rows. And in the "summarized" section of the CrossTab I want to show a
stacked bar chart with the total number of bugs, stacked by their
priority. I can do this in excel but cannot in BIRT as far as I can
tell. It looks like it might work if I could specify priority as the
Optional Y series for the chart data definition, but that is "greyed" out.
With the data below the crosstab should look something like the
following, the [] indicating how many of each priority (color coded, eg.
priority 1 is red, 2 is yellow, 3 is blue).
-Jim
** Sample CrossTab
11/6/2008
Central [-][---------]
East [-][-]
West [-----][-][------------]
11/7/2008
Central [-------][---------]
East [----][-----]
West [------------][----------][--------------]
** Sample Data
Due Date,Division,Priority,Bug Count
11/6/2008,West,1,5
11/6/2008,West,2,1
11/6/2008,West,3,12
11/6/2008,Central,1,1
11/6/2008,Central,3,9
11/6/2008,East,1,1
11/6/2008,East,2,1
11/7/2008,West,1,3
11/7/2008,West,2,6
11/7/2008,West,3,8
11/7/2008,Central,1,4
11/7/2008,Central,3,7
11/7/2008,East,1,2
11/7/2008,East,2,1
11/7/2008,West,1,9
11/7/2008,West,2,4
11/7/2008,West,3,6
11/7/2008,Central,1,3
11/7/2008,Central,3,2
11/7/2008,East,1,2
11/7/2008,East,2,4
** Cube definition
<cubes>
<tabular-cube name="Data Cube" id="8">
<property name="dimensions">
<tabular-dimension name="Group" id="9">
<property
name="defaultHierarchy">NewTabularHierarchy</property>
<property name="hierarchies">
<tabular-hierarchy name="NewTabularHierarchy"
id="10">
<property name="levels">
<tabular-level name="Due Date" id="11">
<property
name="dataType">string</property>
<property name="columnName">Due
Date</property>
</tabular-level>
<tabular-level name="Division" id="12">
<property
name="dataType">string</property>
<property
name="columnName">Division</property>
</tabular-level>
<tabular-level name="Priority" id="13">
<property
name="dataType">string</property>
<property
name="columnName">Priority</property>
</tabular-level>
</property>
</tabular-hierarchy>
</property>
</tabular-dimension>
</property>
<property name="measureGroups">
<tabular-measure-group name="Summary Field" id="14">
<property name="measures">
<tabular-measure name="Bug Count" id="15">
<property name="function">count</property>
<expression
name="measureExpression">dataSetRow["Bug Count"]</expression>
<property name="dataType">integer</property>
</tabular-measure>
</property>
</tabular-measure-group>
</property>
<property name="dataSet">Data Set</property>
</tabular-cube>
</cubes>