Link to home
Start Free TrialLog in
Avatar of guessdip
guessdip

asked on

Best tool for reporting for sharepoint

Hii All,
 I have one site A and it has lots of lists. all list has one common column Projectname. i did not use lookup column. Now my company need some report based on these lists. i have to dispaly some records from one list and some from another. So i also jhave to filter some column from one list and display related records from another list.

So i am looking for any third party tool or need some suggetion from you guys, i have embedded sql server. can i use sql server reporting?? can i use access 2007?
Avatar of Bill Ross
Bill Ross
Flag of United States of America image

Hi,

Access 2007 is a wonderful tool for SHarePoint reporting and is actually your best choice in this scenario.  Here are the steps:

1.  Create a new access database and link to the tables.
2.  Create a query that joins the tables on the ProjectName (click Create, Query design) selecting the desired fields
3.  View the query to make sure the data is OK
4.  Click Create, Report.

This is the short version - there are many Wizards in MS Access 2007 to help get what you want.

Bill
Avatar of guessdip
guessdip

ASKER

Hii,
  I like it approach, i will try, but all user must require access 2007. am i right??

 
Hii,
How to publish Access report to Sharepoint? how user can see the report? is there any feature ??
Hi,

No - users do not need access.  What we do is us the Save As PDF option for the reports and put them in a SharePoint folder.

Bill
The Access Report Designer has the ability to link to  SharePoint data. So you can create a report using MS Access Report designer and display it in SharePoint. Please refer this link for more details.

Displaying an Access Report in a Web Part

Also you can use SQL Server Reporting Services(SSRS) to create report from SharePoint list data and deploy it in SharePoint.  But you need to use a third part tool such as Enesys RS Data Extension to access SharePoint list data. Please refer the following links.

Enesys RS Data Extension
Reporting on List Data in SharePoint
Creating Reports From SharePoint Lists Using SQL Server Reporting Services (SSRS)

ASKER CERTIFIED SOLUTION
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hii,
 
 Thanks for helping me, i will try all method and i will let you know, and in report i also need current data, report must me updated automatically when we update sharepoint list.
SSRS will do that.

and by the way, you can run SSRS in native mode (which means it's not in sharepoint integration mode), and still do reporting on sharepoint data.
zephyr_hex: :
i installed SLAM, but i have some problem with slam.config file. i have embeded sql database. so my server name is : \\.\pipe\mssql$microsoft##ssee\Sql\query.. So in config file i wrote this server name and i used WSS_Content databse and my username and password, but i got error to connect database.

I want to join two list for testing then i will use  for multiple list. One more thing i did not use lookup column, but every list has one common column so can i use this SLAM for connect??

Can i have Slam.config for join two list without lookup column?
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
  <ConnectionStrings Default="SLAM">
    <add Name="SLAM" ConnectionString="Database=WSS_Content80;Data Source=\\.\pipe\mssql$microsoft##ssee\Sql\query;User Id=sa;Password=sa" />
  </ConnectionStrings>

  <DataMapping DataSchema="SLAM">
    <List Site="Master LIst" Name="ListA" ActivationOrder="1">
      <Fields>
        <Field Name="Title" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
        <Field Name="project" SPType="Lookup" AssociatedList="ListB" AssociationName="Project"></Field>
      </Fields>
    </List>
    
  </DataMapping>
</Configuration>

Open in new window

i haven't had the chance to use SLAM myself, so i'm not going to be able to answer your questions directly related to it.  however, i know it has many good reviews, and is mentioned in several blogs as a good sharepoint tool.  perhaps you can contact the author of SLAM with your questions.