Dynamically add columns to dataset

JonnyL

Hi,

I have a report with an XML data source containing columns; Department, count of members, date. The report produces a stacked bar chart showing date value on the Y axis and the count of members for each department on the X axis with Department values stacked.

As the stacked bar chart requires a column for each department to be stacked, I thought the best approach is to dynamically create columns in the table for each department in the data source. Can anyone advise how to dynamically create columns in the report table for each Department in the XML source using Javascript scripting or an alternative approach?

Thanks

mwilliams

Can you show a small sample of XML data? Or just a sample of what the data looks like in your dataSet. Either way works.