All,
I am using the report designer API to generation the report design file dynamically based on use input. When I am working with groupings and aggregates I am creating a Table Structure for the information. In this case, I am generating the 1st and 2nd structure, but a 3rd is being created (i think by the system). Therefore, I am unclear on how to resolve this issue because I need to be able to have verbiage out by the aggregate value for example "SUM: " + row["Color"]; as seen in the 2nd structure. However, when my report is generated i have no data just headings. However, if i do not generate the 2nd structure and just use the 3rd i get data, but i cannot specify the custom text since it is generated. I basically using a report design generated in eclipse and then using that as my mockup to generate the report design xml using the API.
Any direction would be appreciated or any good sites besides the standard sites.
Thanks
<structure>
<property name="name">Color_SUM</property>
<property name="dataType">float</property>
<simple-property-list name="aggregateOn">
<value>groupByColor</value>
</simple-property-list>
<property name="aggregateFunction">SUM</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value" type="string">row["Color"]</expression>
</structure>
</list-property>
</structure>
<structure>
<property name="name">Color_structure</property>
<expression name="expression">"SUM: " + row["Color_SUM"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Color_1</property>
<expression name="expression">dataSetRow["Color"]</expression>
<simple-property-list name="aggregateOn">
<value>groupByColor</value>
</simple-property-list>
</structure>
