Solved

Best way to create reports in wss 3.0 ?

Posted on 2011-03-14
6
813 Views
Last Modified: 2012-06-21
Hi All,

 I have wss 3.0 and i have some requirement to create some reports from some sharepoint list with good design. i can attach it if you interested. I need to know which tool developer use for reporting.  I can also use C#, but not sure how to design template for reporting.

Can you guide to create reports for wss 3.0??

Thank you.
0
Comment
Question by:guessdip
  • 4
  • 2
6 Comments
 
LVL 6

Accepted Solution

by:
ThatSharepointGuy earned 500 total points
ID: 35131279
Here's how to do it in Access 2007, which is the only way I've ever run reports before, on Lists.

1

In Access 2007, add the List as a Table (it syncs both ways).

2

Then for a single List, use the Report Wizard in Access 2007.  

3

You can save the Report, and every time the Table/List is updated (either in Access or in the SharePoint List), any new Reports that you run will give an updated report on the list data.
Note:  If you are combining several lists, don't use the Wizard.  Use the Reporting Editor to manually create the reports.
0
 
LVL 6

Expert Comment

by:ThatSharepointGuy
ID: 35131291
Also, here's a quick rundown on how to link the two together if you weren't already familiar with it (Access/SharePoint) : http://sharepoint.microsoft.com/Blogs/GetThePoint/Lists/Posts/Post.aspx?List=8d9e2a99-f288-47c2-916b-2f32864f7b82&ID=68&RootFolder=*&Web=5e4647a0-e7d0-4626-b71c-b1ff06402465

0
 

Author Comment

by:guessdip
ID: 35131623
Hi,
 Thanks for your replay. I can use access 2007 but you know all user does not have Access 2007 so we can get problem. I need to make report so i can display in sharepoint with live data.

Hope you understand my situatuion. Is it possible to make report in Access 2007 and display in sharepoint with live data.
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 6

Expert Comment

by:ThatSharepointGuy
ID: 35131900
By "live data" are you meaning that it would update the report by itself, every time someone updates the list, without you having to click something?  If so, then no, there is nothing that is going to update a report like that, at least not that I know of.

Then again, running reports doesn't take much time (just a few seconds, possibly a little bit more if the lists is extremely large), so I don't see why you couldn't just run the Access report wizard whenever you needed to submit a report to your supervisors (or whomever).
0
 

Author Comment

by:guessdip
ID: 35132087
Hi,
 you mean to say i can make report in Access 2007 and then copy that report to sharepoint. I want all user to see that report so i have to put report link or report in sharepoint anyhow.

Is it possible that we can copy that report to Sharepoint?
0
 
LVL 6

Expert Comment

by:ThatSharepointGuy
ID: 35132244
guessdip,

I believe that I have misunderstood your original question.

You mean to say that you want to make a "Report List" in SharePoint, that reports on data from other lists?

So

ListA ====>
ListB   ====> ReportList
ListC ====>

Like that?  ListA, ListB, and ListC report to the "ReportList", so that you can view just one list for the report?  What sort of data do you want to be in the ReportList?

I was thinking that you could possibly create a workflow to do it, and have the workflow update the ReportList when someone updates ListA, ListB, or ListC.  I have very little experience with workflows, though...so I wouldn't be able to help out much on that point.

The workflow can be automatically started when a new item created or updated in any of the lists, so the update action will update the list item in the ReportList one at a time.  If you want to update list item more than one record, you can create a custom workflow using code, it will traverse all the list items using loop, check the conditions and update all the items that accord with the conditions.

You might have to create some custom code for this, but like I said - I don't have much experience with Workflows, unfortunately.  

You could check out the following links to see if they help you out any on that end.  I hope they do!

http://www.documentmanagementworkflowinfo.com/workflow/use-update-list-item-action-sharepoint-designer-workflow.htm

http://msdn.microsoft.com/en-us/library/ms564355.aspx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question