Reporting Services Connection to SharePoint
I need to create reports on SQL Server Reporting Services 2005 (SSRS) on data coming from SharePoint Lists,

i was searching for ways to do that and i found,

 1. connecting to SharePoint web service
    out put XML, the problem here is it
    sometimes work and sometimes don't,
    and also i couldn't do inner join
    between different lists may be it is
    there but it will be trouble to do
    it i think (if there is easy way
    tell me please)
 2. Creating a link table in MS Access
    2007 that links to sharepoint lists,
    and then connect to the MS ACCESS
    link tables from SSRS 2005 : this
    will work but i am kind of scared of
    having ACCESS in the middle i always
    want to avoid using access
 3. connecting to the views provided in
    the sharepoints backend database
    (there is a view for all lists and
    another view for all list items) :
    here column names will be troublsome
    to create the query the clounm names
    are like
    (float1,float2,...,date1,date2,date3,....)
    , also i am not sure if it is good
    thing to make SSRS talk directly to
    sharepoints backend database views

can you tell me which of these ways is best (or if there is a better way plz tell me)

i kind of like the third way but not sure if i should use it


Reporting Services Connection to SharePoint
===

I need to create reports on SQL Server Reporting Services 2005 (SSRS) on data coming from SharePoint Lists,

i was searching for ways to do that and i found,

 1. connecting to SharePoint web service
    out put XML, the problem here is it
    sometimes work and sometimes don't,
    and also i couldn't do inner join
    between different lists may be it is
    there but it will be trouble to do
    it i think (if there is easy way
    tell me please)
 2. Creating a link table in MS Access
    2007 that links to sharepoint lists,
    and then connect to the MS ACCESS
    link tables from SSRS 2005 : this
    will work but i am kind of scared of
    having ACCESS in the middle i always
    want to avoid using access
 3. connecting to the views provided in
    the sharepoints backend database
    (there is a view for all lists and
    another view for all list items) :
    here column names will be troublsome
    to create the query the clounm names
    are like
    (float1,float2,...,date1,date2,date3,....)
    , also i am not sure if it is good
    thing to make SSRS talk directly to
    sharepoints backend database views

can you tell me which of these ways is best (or if there is a better way plz tell me)

i kind of like the third way but not sure if i should use it

