Having XML and SQL both at the same time in a single report.

[Former Member]

I know that its not possible to have multiple data source in a crystal report (they must have single end points, in some cases that worked, based on the requirement).

But, then comes a question, if I can have both XML as data source in some sections and SQL stored procedures in other sections of the same report?

If, Yes, any link would be appreciated.

[former_member188030 · Accepted solution]

Use subreport and point it to a different datasource than the main report.

Apart from this, I could only think of using datasets but then it would be assigned to the entire report and not to a specific section.

Thanks,

Bhushan

[Former Member · Accepted solution]

OK, so this means we can have multiple data source when main report has one kind, and sub reports have similar, or different then the main report.

Thank you so much.