[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

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?
0
guessdip
Asked:
guessdip
  • 4
  • 3
  • 2
  • +1
1 Solution
 
Bill RossCommented:
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
0
 
guessdipAuthor Commented:
Hii,
  I like it approach, i will try, but all user must require access 2007. am i right??

 
0
 
guessdipAuthor Commented:
Hii,
How to publish Access report to Sharepoint? how user can see the report? is there any feature ??
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Bill RossCommented:
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
0
 
RameshSCommented:
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)

0
 
zephyr_hex (Megan)DeveloperCommented:
here is another tool that can be used to access sharepoint list data in SQL:
http://slam.codeplex.com/

SSRS is the next step up from Access or Excel reporting.  and, SSRS can be integrated with sharepoint.
0
 
guessdipAuthor Commented:
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.
0
 
zephyr_hex (Megan)DeveloperCommented:
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.
0
 
guessdipAuthor Commented:
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

0
 
zephyr_hex (Megan)DeveloperCommented:
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.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now