?
Solved

Best way to create reports in wss 3.0 ?

Posted on 2011-03-14
6
Medium Priority
?
833 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 6

Accepted Solution

by:
ThatSharepointGuy earned 2000 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
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.

 
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying 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

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

752 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