I'm using SSRS 2008 R2 , MOSS 2007 and report Builder 3.0 To generate cascading reports with sharepoint 2007 lists.
I'm able to filter and see the data correctly within report builder .
But if i upload the same RDL file to Sharepoint library and then tries to view the report,i'm not getting any data.(absolutely zero records)
I'm using Report builder 3.0 and sharepoint list as connection string.
Interestingly, if i'm ising XML as a connection string to pull sharepoint list data and then publish the report to sharepoint, i'm able to see the data within sharepoint correctly and i'm able to use the cascading filter and can view the correct data.
Please advice on why i'm not able to see the data if i'm using the connection string" sharepoint list "
This issue is same even if i'm using BIDS 2008 and sharepoint list as connection string.
i would like to use sharepoint list as connection string because of the ease of using it.
Thanks in advance!!
Best Regards, Ashok Yadala | Senior SharePoint Consultant
View Complete Post