Custom Reports with multiple data sets

[mencio_vidal]

Hi,

I am trying to build a custom report merging multiple data sets into one chart but am only able to merge 2 data sets using the mergeDataSets method as showed in the example in the wiki http://wiki.servicenow.com/index.php?title=Custom_Chart_Rendering .

Does anyone know how to do that?

I have found one article in this forum (Charting woes) where someone mentions a solution but I wasn't able to make that work. If anyone knows how to make the solution above work I would appreciate if you could share a working example.

Thanks in advance!

[amiharia]

You can use database views in order to combine data from multiple tables and then use that for your report if that helps.
https://wiki.servicenow.com/index.php?title=Database_Views

[mencio_vidal]

Thanks for your suggestion.

But what I was really trying to do was to show multiple lines (sets) in the chart, each one from a different summary set to track different trends.

I actually managed to do that using 'getChartGenerator().getLineRenderer' and adding multiple ones to the main chart.

Thanks anyway.

[arunkumardharma]

Hi Menico,

I need a help from you. Actually my requirment is like,

We need to merge multiple reports in a single file.

These are the reports

1) Incident report based on SLA

2) Incident report based on Priority

3) Incident report based on Created date

4) Incident report based on assignment group

Can you pls explain me the procedure to achieve this one. Thanks in advance

Thanks

Arun