?
Solved

Best way to create reports in wss 3.0 ?

Posted on 2011-03-14
6
Medium Priority
?
841 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 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses

569 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