How to get records from two different lists of a sharepoint site in SQL reporting

i have 2 sharepoint lists policy acknowledgment , policy type. in both list, have policy name common field. have create report using 2 dataset on same report page. if have 1 of suggestion or other idea
1) there way combine 2 sharepoint lists single dataset using caml query
2) there way combine 2 dataset single report using common field inner join in sql server?

 

otherwise if have other idea, please suggest..

thanks.

hi estoysol,

by design, getlistitems method sharepoint lists web service can return 1 list 1 time.

in case, suggest using sub report work around issue:
 1. show first list in main report.
 2. show second list in sub report using subreport control.

for more information, please see:
how to: add subreport , parameters (reporting services): http://technet.microsoft.com/en-us/library/ms160348.aspx

if have more questions, please feel free ask.

thanks,
jin chen

---

jin chen - msft

SQL Server  >  SQL Server Reporting Services, Power View