.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how to generate reports weekly and monthly in sharepoint

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :SharePoint
Hi, Please help me i have requirment like : i have to create dashboard then in that dashboard generate some reports, based on the requirment few reports are weekly and few reports are monthly.Give some idea how to generate reports like taht(data from excel shheets).

View Complete Post

More Related Resource Links

Viewing Reports with SharePoint 2.0 Web Parts

Reporting Services provides several Web Parts that work with specific versions of a report server and in particular deployment modes. If you want to access report server content on a SharePoint site from a native mode report server, use the SharePoint 2.0 Web Parts that are included with Reporting Services. Instructions for installing and using the 2.0 Web Parts are provided in this topic.

Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration


The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

Ed Hild

MSDN Magazine March 2006

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




Building Reports in SharePoint Integration Mode

 I configured and connected SSRS to my SharePoint farm, but how do I go about creating reports?  The usual <my server>/reports url is disabled in SharePoint integrated mode.  Can someone point me in the right direction? Thanks, Eric

Integrate Crystal reports with sharepoint?

Hello!Has anyone worked on crystalreports in sharepoint?I am a begginer and i need a good reporting methodcan anyone help me?thanksmona

Building SSRS reports based on SharePoint 2007 lists

Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

Proper Approach for Monthly PDF Reports for Small Business?

Hello, all. Previously, our environment included an installation of WSS 2.0.  One of our most widely-used "features" was a page of links to reports on network file shares.  No one liked or trusted the Document Libraries, so we continued to store our weekly & monthly reports at places like \\fileserver\r-drive\MonthlyReports\2010\08\Sales\LicenseActivationReport.pdf and then created a bird's nest of links on our WSS "Reports" page to allow folks to find the information they were looking for more easily.  I'm not talking about a Links List, but a page of text with about 30 links to individual reports whose locations changed at least monthly.  These reports are roughly 70% PDF (exported from Crystal Reports), 25% Excel, and 5% Word. Today, we have an installation of MOSS 2007 Standard.  The collaboration and document management features are taking off quite nicely, but the staff is understandably itching to migrate the above-described "Reports Page" from WSS 2.0 to MOSS 2007. I can think of a few different approaches to this situation: We could reproduce a text page with 30 links to places like file:\\server\share\report.xls, but this seems contrary to SharePoint's mission.  It's certainly contrary to what I told the staff during training:  "Don't turn SharePoint into a bird's nest of links to ext

Publishing reports from Business Intelligence to Sharepoint Services 2007

We currently have sharepoint services 2007 and SQL server 2005 installed (with reporting services) and Sharepoint SQl web part on a single box named 'king-sharepoint'.   We have sucessfully setup the reporting services from Native to integrated sharepoint with a db name of 'spkingsdb'. We are trying to publish reports to the sharepoint database using Visual Studio, as we are new to sharepoint we are confused as to how to achieve this.  We understand to publish it we need to know the path of the database (reportserver(spkingsdb)), the folder in which the reports will be published to (do we create this? If so then how?), and the server name (http://king-sharepoint/reportserver).  thanks

[Sharepoint 2007] How to send a task from calendar on a weekly basis ?

Hi all, I have created a sharepoint calendar. I would like to create a task every week. This task should show the details of a meeting. Also a document should be uploaded every week to this meeting by the adminsitrator.   Every week a user should receive a new weekly remainder in the tasks list at 9 am.   I have been using the workflow but it is sending just one task for all the series. I would like to trigger a new task every week based on the calendar.   How can i achieve that ?   Thanks

Infopath cannot generate a form template for the sharepoint list


Dear All,

For Sharepoint 2010, Infopath 2010

When I trying to login Infopath by link Customize Form that available in the List tool bar I found the following error:

Infopath cannot generate a form template for the sharepoint list

The SOAP response indicates that an error occurred on the server

Can anybody help me figure out what is causing this error?

Error occuring while exporting larger reports to Excel from SharePoint



I have SSRS configured in SharePoint integration mode. I have reports deployed. if a user wants to export the report to an excel file works fine for smaller reports. But, in the case of larger reports it is throwing me an error while doing export to Excel. I am getting message like

An unexpected error has occured.

Example: Monthly reports are exporting to excel file fine. Where as, Yearly report has more data than the monthly reports. If I try to export these reports, I am getting above error. I must sure, this is something to do with the IIS time out or application time out(setting in web.config file of web application). Please some one guide me where is best place to do this.

Viewing works fine for both the reports.

I appreciate your help.



Sharepoint - Webpart doesnt deploy - stsadm reports deployment 'successful'


MOSS 2007 :)

I am having problems deploying a webpart..
This webpart was successfully installed and deployed on a similar environment with no problems. However when trying to deploy it in its intended site it's having some strange problems..

1. I installed the webpart to the server (through stsadm) - return message "Operation completed successfully."
2. I deployed the webpart to the intended site - return message "Operation completed successfully."
3. I performed an IIS reset and navigated to the 'site features' area to find no trace of the webpart to activate.

I ran the 'stsadm -o enumsolutions' command to view the solutions that are deployed, and I see my webpart here:
  <Solution Name="solutionname.wsp">

Win server 2003+ Sharepoint 2007+SQL Server 2008 ,reports view issue?


I hope someone may shed some light on a serious obstacle encountered on a client site:

We have implemented a SharePoint integrated report services solution for the client on a single server

Server = Windows 2003

SQL = 2008

MOSS 2007

Web application = servername:8888 (default) - windows auth

Web application extension 1 servername:8889 (extranet) forms auth

Web application extension 2 servername:8887 (intranet) forms auth

Reports are visible and can be run (renders) on internal sites

However, there is an external site which allows users to access the reports - the issue is, the reports then dont run and I get this:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

Though I have not actually seen the firewall config of the AAM, the client assures me it has been setup properly.

If the AAM is setup correctly, what could be the problem? The server is clearly available and confgured in SharePoint integrated mode.


has anyone experienced the scenario where clients want to publish their reports on an external site? What can one do to see any errors other than the one line message (tried enabling custom errors, but no good)

reports published to SharePoint not refreshing in "sharepoint 2007"


Hello All,

My Issue: SSRS reports published to SharePoint not refreshing in “sharepoint 2007”.

The reports have the ‘Auto refresh’ property set to 15 sec. When the reports are viewed in the report manager the reports refresh and update with the new data entered in the Transactional system.

I now want to publish these reports to SharePoint in a dashboard format.

My first attempt to do this was with Performance point server. I added the report to the Performance point dashboard designer and then created a dashboard with these reports. I then published the rep

SSRS Reports Not updating in Sharepoint 2007


Hello All,

I created some reports in SSRS 2008, The reports data source is a live transactional data source. The reports are to auto refresh every minute displaying any new info that  was put on to the system in the last minute. The auto refresh property on each report is set to 60 sec. to trigger the refreshing of the reports.

The problem: when i run the reports in the report manager the every thing works fine, the report runs, refreshes, and the figures are updated.

I am now displaying these reports in Sharepoint 2007 via the "report viewer" facilitated by the RSWebPart that i installed on the Sharepoint instance. 

The reports are displayed fine in the viewer, but my problem is that it does not auto refresh with the updated info.


I figure it is a caching issue but how to get around? HELP!

Authenticated, when deploying the reports(SSRS 2008) to a sharepoint site

I created reports in SSRS 2008 for a sharepoint list. But when I tried to deploy it to the report library I used to get an authentication pop-up box again and again. I used all the username and password. But no luck. Does any one knows how to overcome this situation.

Submitting Infopath forms to a Sharepoint Library - how can I generate a unique name for each record


I have published an Infopath form to a Sharepoint Library. What is the best way to ensure the following:

1. have a name per saved form (I do have a name field which has a set certain amount of available names in it which I am currently using as the form name - coming from an XML file)
2. users can edit already submitted forms without changing the name of the saved form
3. Ensure that users who may create a new form which happens to have more or less the same data as a previously saved form don't end up overwriting the existing one and hence I end up loosing saved data?

Using the name field + allow overwrite will allow me to have a unique name for the form and allow it to be overwritten but if I create a new form with the same name and maybe just a few small differences I will overwrite the existing form which is what I don't want - someone may not realise that an existing form with the relevant information already exists and we could loose already saved information

Any advice would be greatly appreciated.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend