Reports from Lists

All:

I would like to create a report based on a list. Take for instance a simple issue log: How do i create a report in SharePoint and organize the list by "Entered By"

I have created reports in Access that use the data from SharePoint via linked tables and I would like to 'duplicate' these reports in SharePoint.

Thank you

ps. i have looked at "Microsoft SharePoint Products and Technologies Resource Kit" but with out any luck.

Answer this question

Reports from Lists

vijayalakshmi
p.s. You might also be able to use InfoPath 2007/Forms Services. InfoParh 2007 forms support using a SharePoint list as a data source.
gkostel

You can save the Access report as a snap-shot, post it back to a SharePoint Document library. Anyone can then view this (there is a free viewer) or you can display it in a web part

Demo http://www.wssdemo.com:8080/pages/access.aspx

Regards,

Ian
R.Tutus
Thank you Mike, that is NOT the answer I wanted!! As you inferred, I need good looking reports which are easy to make in Access and the list views in SharePoint are not the best.

We have not yet moved to SQL Server 2005 and Office 2007 yet, but i will definitely be researching those for our needs.

Thank you for your help.
Nate Garvey
I need good looking reports which are easy to make in Access and the list views in SharePoint are not the best.
montechristo

Another approach is to write a SQL Server 2005 Table Valued Functon (TVF) that allows SQL Server to present a SharePoint list as if it was a plain old SQL table ...and use it with Reporting Services.

Checkout http://msdn2.microsoft.com/en-us/library/bb293147.aspx
Philippe Stancu
Hi,
You may be interested in our Reporting Services Data Processing extension that lets you build report from SharePoint Lists data.
A free community edition is available on our site .

Frederic Latour
Enesys
shahidferoz
Assuming that by good looking reports, you mean when printed, not much can touch Access for ease of use and functionality. You can do some very nice work with the DataView web part, but it is a lot harder to do things like snaking columns, multiple-group subtotals, calculations etc.
Z.Z.C
The main reason (imo) why Microsoft created the link between Sharepoint 2007 Lists and Access 2007 was for the two SharePoint 2007 products to be able to use Access 2007 to produce reports of SharePoint 2007 Lists !

Otherwise the only way using the UI is to try to create a List format (by perhaps amending the .aspx page produced by a List in SharePoint Designer 2007 to make it more report friendly) but this will produce simple (and frankly, bad) reports compared with those you can produce in Access 2007 (where you can use both Report and Report Design - the latter of which will combine the contents of two lists).

The only other main reporting option is to use SQL Server 2005 Reporting Services.

Mike Walsh
Reports from Lists

Answer this question