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

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

What is the best way to Create Ageing Report in SharePoint 2007?

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

Hi Experts,

I need your point of view about this and please advise,

My client have made a request to generate Ageing Report thru their SharePoint 2007, FYI all invoice was scan and upload to sharepoint and save as PDF file under Document Library. During the scan, certain information will capture automatically and save it into field that we defined inside the Web Form.   

Below is the basic input we capture:

Vendor Code, Vendor Name, Invoice Number, Invoice Date, Currency, Invoice Amount

Report Requirement (display list and group of:)

- Vendor Code, Vendor Name, No. Of Invoice, Total Payable, Ageing 0-30, Ageing 30-60, Ageing 60-90, Ageing>90 

So my question is, what is the best platform to create this Ageing Report??

because when i try to design the report thru Visual Studio (Reporting Services), i can't identified which database should i connect and which table is store all the invoice information in SharePoint.

Any idea guys?? anybody have implemented it before??


View Complete Post

More Related Resource Links

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

How to get "Current Date" on SharePoint Designer for Invoice Ageing Data View Report??

Hi Experts, I would like to know how can i get/show "Current Date" in SharePoint Designer ?? Any good tutorial ? FYI, I need this "Current Date" for my Ageing Data View Report, Purpose To offset with "Invoice Receive Date" to get total days of payment payable for the invoice. Please assists, Thanks

Access Denied while using Sharepoint designer 2007 to create a work flow

I am using Sharepoint Designer 2007 to create a work flow that sends emails to different people in a group depending on status of a record. For example, when some one reports a problem, an email is posted to concerned person and as soon as he/she checks the problem and updates the status an email is sent to next department and so on. Starting the work flow creation wizard is no problem but as soon as I press 'Finish' to create workflow I get 'Access Denied' message box. Any Ideas? I am using WSS 3.0 on 2003 Server.

Problem create a web application on SharePoint 2007 (Project Server 2007)

I installed a Project Server 2007 in a 3 server structure (all Win 2003 sp2; one for App server hosting Central Admin, Project Server service & Search service; one for web server; one for database server).  They are only in the same domain and I use the same network account for the installation as well as the WSS service account.  The same network are local admin for those 3 servers. All installation & patches seem ok (at least I don't get error messages) until I attempt to create my first Web Application.  After I filled out the web appliction and try to click OK, the page does not change and i saw the java error at the right bottom corner from my IE browser (version 6). The message is .... Line: 1686 Char: 1 Error: 'WebForm_PostBackOptions' is undefined Code: 0 URL: http://myservername:28804/_admin/extendvs.aspx On my SP log, below are the portion of the log when the error happen. 09/09/2010 12:28:29  1  INF        Entering function UserInterface.ShowCentralAdmin 09/09/2010 12:28:29  1  INF          The show central admin command has been chosen 09/09/2010 12:28:29  1  INF          Searching for registry key Software\Microsoft\Shared Tools\Web Server Extensions\12.0\WSS\CentralAdministrati

i want to create sharepoint 2007 workflow with E-mail notification in sharepoint designer ?


i want to create sharepoint 2007 workflow with E-mail notificationin sharepoint Designer .

my Workflow Scenario is :


Step-1 employer send document for approval to manager .

step-2 When manager will approve or reject . status will send to the emloyer through mail.

step-3 when manager will approve than document is going for approval by main manager.

step-4 if approve or reject status will send it to employer and manager.


plz help me .. for this. how i create in sharepoint designer . plz send me any exmaple of this.



Cannot Publish Excel 2007 workbook to Report library on MOSS 2007 Sharepoint



I use Windows 7, trying to Publish an excel workbook to MOSS 2007 Report Library. When I type the location in the "Save As.." dialogue, It disappear & file is not saved.

If I do the same from Windows XP OS with Office 2007, I get the Report Library content (the sp folderrs), so I can navigate & file is published succesfuly

Please help :-)


Sharepoint Designer 2007 - Workflows stopped and can't create custom NewForm or custom EditForm


Everything was working great until the last few days when I made the SP site more robust. I am now ready to create a custom New Form so that my "requestor" doesn't have to deal with all of the fields. I want to create a custom Edit List so that I can hide all of the flags that get tripped while completing workflows. This morning I tried to create the NewForm (as I have done in the past) but nothing loads. I tried creating it with a different list, and it loaded fine so I know it has something to do with my list. I tried executing workflows so that I might be able to narrow down the problem, but now no workflows work even though they did a couple of days ago.

One of the items added as a "pause until" workflow. I don't know if that has anything to do with it or not. I also have roughly 85 fields. I haven't seen anywhere on the blogs that the number of fields is an issue but you never know.

Can anyone help? Please?

SharePoint 2007 Designer, create a meaningful subject


Hi all,

I am trying to create a custom workflow to send an email based on certain criteria.  I would like the subject of the email to be [Item Title]+"has been modified", or something like that.  I can choose the field in the Function, but I can't add any wording before or after the field name.  I also tried to use every syntax I can think of in the subject line to create it, but all I get is my code I entered not want I wanted to see.

Can this be done?



Required Summerised "MySite" Usage Report using Sharepoint 2007 object model


Hi All,

I have a requirement like I need one report which will provides the MySite Usage Report

In detail: One report having information about MySite User,Total Hits since created, Average No of requests per day over past 30 days, Distinct users over past 30 days, Size (KB) on "MySite" in Sharepoint.

Please let me know any solution or thoughts either using content database queries  or object model.

Advance Thanks

Ashok Gamini

Create PDF Report in Microsoft Sharepoint 2010

Morning Community

Need support from the community to develop a component for Microsoft Sharepoint 2010 for exporting reports to PDF, there is already something ready that can reuse or must I create?

I wanted something like the options already available for export to Microsoft Office.

I thank you,

Leandro Figueira

Create PDF Report in Microsoft Sharepoint 2010

Morning Community

Need support from the community to develop a component for Microsoft Sharepoint 2010 for exporting reports to PDF, there is already something ready that can reuse or must I create?

I wanted something like the options already available for export to Microsoft Office.

I thank you,

Leandro Figueira

how to change the layout of the blog or create custom blog in visual studio for sharepoint 2007


i want to change the layout of the blog display in the following  layout of display

<TABLE border=0 rules=none cellspacing=0 cellpadding=2>

    <TR vAlign=top>

      <TD height=95 rowspan=2 width=95 align=middle><A href="<SOURCE URL>" target=”_blank”><IMG border=0 src="<PICTURE URL>"></A></TD>

      <TD><STRONG>Source: <A href="<SOURCE URL>" target=”_blank”><SOURCE NAME></A> | </strong><A href="<SOURCE URL>" target=”_blank”>Rea

How to create a multi-stage workflow in SharePoint Designer 2007


Hello everyone,

I'm new at creating workflows and have only created a very basic one. I was handed a task and creating the following workflow and I have no ideal on what to do.

Here is what they want to happen.

 The user submitts the form and depending on what he chooses in the Segement Report Access field will determine on who it goes too. The user can choose multiple options. The options are our 4 divisons. Each division has one approver assigned to it. We created a list for this and then in the form it's a look up value.


The user choose two of the four options. (Sheet and Color) So the workflow needs to send and e-mail to the Sheet user to approve the request and it needs to send another e-mail to the Color user to approve the request. Now if they both reject it, the workflow would stop and send a message to the user saying your request has been rejected. But if one user approves it and the other one rejects it, it needs to go to the next step, which would be sending an e-mail to the user who sets up the account. They want him to be able to see which parts were approved and which parts were not approved.

Once he's setup then we need to send an e-mail to the requester saying that it's been approved.

Sorry if they is long, I just have no ideal where to start or how to start this.



Can't see any data after publish SSRS report to Sharepoint 2007



I'm using SSRS 2008 R2 , MOSS 2007 and report Builder 3.0 To generate cascading reports with sharepoint 2007 lists.

I'm able to filter and see the data correctly within report builder .

But if i upload the same RDL file to Sharepoint library and then tries to view the report,i'm not getting any data.(absolutely zero records) 

I'm using Report builder 3.0 and sharepoint list as connection string.

Interestingly, if i'm ising XML as a connection string to pull sharepoint list data and then publish the report to sharepoint, i'm able to see the data within sharepoint correctly and i'm able to use the cascading filter and can view the correct data.

Please advice on why i'm not able to see the data if i'm using the connection string" sharepoint list "

This issue is same even if i'm using BIDS 2008 and sharepoint list as connection string.

i would like to use sharepoint list as connection string because of the ease of using it.

Thanks in advance!!


Best Regards, Ashok Yadala | Senior SharePoint Consultant

How to create a shared schedule for a report in sharepoint?


Hi there,

I've a reporting service that's integrate within sharepoint, and I want to create shared schedule for my report/subscription, but I can't find anywhere how to create the shared schedule like the report manager.. any advice?


Thank you,

Can you create a report from a sharepoint list using BDC?


I have a list that has a bunch of useful meta data, but management wants more of a detail and total area type of report from the data. I am at a loss for the best way to come up with a report like this from the list data in a fairly automated manner.

Has anyone done this? If so what do you recommend? I thought maybe excel services but that doesn't seem like it is quite what I need. I considered SSRS but my manager suggested I explore BDC. No idea if it can consume SharePoint itself though.

How to create a Blog using code in Sharepoint 2007


Hi All,

  I have a requirement to create a Blog in Sharepoint 2007, how to create one using C# code. any help is 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