Re: Single Summary &#38; Drilldown builder to show the graph with many sql's

Hi,
From the doc you attached, I guess you're going to create a chart with multiple columns on x-axis, but every of these columns is from separate SQL calls. If I'm right on understanding your question, I think the general solution for your request is as following:
1. Invoke all the SQL calls to get data from database
2. Composite the results of SQL calls into a single XML data
3. Create a variable and schema for the new XML generated in last step
4. Specify the XML data in the Summary&Drilldown builder

There is also another possibility that in the chart the number of columns on x-axis is changing, that means, sometime there are 5 columns, and sometimes 6. In such case, creating schema for the composite XML data is not a good way. If you're facing such case, you'd better user "WebCharts - Enhanced" builder with which you need not minding about the schema which the Summary Drilldown builder needs.