.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

Can I use Infopath to combine info currently submitted via excel into consolidated reports

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :SharePoint

I am taking over a project where many internal users submit information on 3 separate excel worksheets - on a workbook they get from Sharepoint - to one person (soon to be me) and then that person compiles and transfers that data into 3 excel reports and 1 word document with very specific requirements and distinct formats (this is the government, so the output formats cannot change too much).  It's all manual, including adding or subtracting lines, and tallying the numbers from all users.  I'm thinking that an application like Infopath would work here from what little I know about it.  Some of the info that is input is included on all 4 reports.  Where do I begin?

View Complete Post

More Related Resource Links

Infopath Brower enabled form not visible in the sharepoint library after being submitted

Hi, I have created a infopath browser enabled form to submit to a sharepoint form library, however the submitted forms are not visible in the sharepoint link structure.   I'm able to see them in the SPD structure.  I'm using infopath 2007 and MOSS. I actually created a SPD workflow which retrieves specific values from the submitted form and saves it to another sharepoint list. This works fine even if the forms are not visible. Appreciate any help. Thanks

Creating report from Infopath library/submitted forms

Hi, I got a form that has repeating table containg data. The form is submitted to a form library on MOSS 2007 site. Some of the key fields from the form has been promoted to the library, which allows creating views and gives the user a quick report based on the filter. Now, the user wants similar function, however the data is stored in the repeating table. I can use double eval function to combine data from each columns and promote them to the library. But obviously, it doesn't give the user accurate/the kind of report he is looking for using the views. Do you have any suggestion? The only option I can think of is storing each row from repeating table into an Access database or sharepoint list. But that'll also involve making sure correct data is being updated in these secondary data source when updating the form.  Pman http://www.pmansLab.com/

Get user info in infopath using data connection

hi,  i want to use the absence request template form and connect the employee section and manager section to an existing database. what i want to create now in this template is this (i'm going to explain my scenario): - when the user open the infopath absence request form and insert his name, id number etc (employee section), the approver's name and mail addres (manager section) filled automatically. the approver name must be corresponding to the user name. in the existing database there is a table with the approvers name filled for each user, but from there i dont know how to apllicate this table to use for the auto fill. and after the form is ready can i publish it to my wss 3 site collection? is there a tutorial that explain a scenario like this? thnx

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.



Client need to open auditing reports in excel application not in browser


Good day,
I encountered with this issue in MOSS 2007. Auditing reports was opened from common SharePoint auditing page.
This page contains hyperlinks to auditing reports.
When any user tries to open this hyperlink, "open file" dialog does not appear, instead of this a IE browser silently open in text XML format.
I suppose that common behaviour is when user open a hyperlink, report will open with excel application through "open file" dialog.
For example, hyperlink in SharePoint contains URL:

Password protected PDF/Excel reports using SQL Reporting services


I am generating a reports using SQL Reporting services 2005. I need to protect the protect the reports(pdf and excel) with the password while the user is exporting the report to to excel or pdf.

Is there any way to protect the report.

Thanks in advance...


InfoPath Pulling incorrect account info from SharePoint

I am new to the world of Sharepoint developing and I'm having a slight problem. I have 3 different accounts that I use for sharepoint for myself. A low end account, a high end account, and a sharepoint system account. I almost always use the system account as it has full priveledges for me to do everything I need to. I have developed an InfoPath form that pulls the sharepoint user info using the getuserprofilebyname function and it seems to work fine for everyone who opens the form except for me. When I am logged into sharepoint under my low end account on my computer and I open the form it autopopulates the user name text box with "Share Point" which I imagine is the user name for the sharepoint system account. I really need it to pull up my own name for testing purposes so that I can avoid having to use another pc to open the form or having my co-workers open the form on their pc's. Any ideas on why I can't get it to pull my account info?

Retrieve the list ID of a programmatically-submitted infopath form

I'm using the DataConnections["SUBMIT"].Execute() method to submit my InfoPath form to a document library.  However, later in the custom code I need to reference back to the submitted form (I need the ID and the title).  Is there a way to gather this information while submitting?

Sharepoint 2010 List from Excel Spreadsheet to Display as Options in Infopath 2010


I have an Infopath 2010 form where I want the users to be able to display the cost of something based on the results of the data in an excel spreadsheet.

This spreadsheet does not have to stay a spreadsheet, I can import it into a List if that will make this work. So the spreadsheet has types of appraisals along the "X" axis and then individual States along the "Y" axis.

So if I am filling out the form - I want a "residential" appraisal and it is going to be in "California" - that should return the cost.

Any help woudl be appreciated. I am not sure exactly where to start.

How to convert InfoPath form from sharepoint form library (xml format) to Excel format?


I've read about Document Converters in Sharepoint, and using xslt and xml mapping. 

What is the best way to convert InfoPath form with data in sharepoint form library (in xml format) to Excel format?

And how to do it?


Values from Excel sheet in Infopath?



I am trying to find a way to get values from an Excel sheet in my drop down field for exchange rates.
Without any success.
Can this somehow be done?


best book on Sharepoint designer, Infopath, Excel services, bdc, search


Please suggest me the best book on

  • SharePoint Designer
  • Sharepoint Infopath
  • Sharepoint Serach (MOSS 2007)
  • Shaprepoint Excel services
  • BDC

Please suggest me the best separate book on all above topics through I can achieve  from beginner to advance level understanding.

Combine multiple Excel Files Into 1 Excel File


We have 7 excel files formatted with colors and data. What we want to do is after the 7 excel files are created we want to merge ALL 7 files into just one excel file.

-Using C#/Asp.net we are creating reports using Reporting Services and then exporting them to Excel.

-Anyhelp is appreciated.

InfoPath Calculated Field doesn't Post to SharePoint List when form is submitted


I have a nice InfoPath form that includes a calculated total field.  That works great.   The form is published to a SharePoint list and when users of the form Submit the form to the list the form information neatly populates to the list.   Well, all of the fields populate to the list except for the calculated total field, that one is just blank.  Naturally, I've noodled around to figure out why and therefore I'm here now asking for guidance.   What should I be focusing on to resolve this issue?


SSRS reports using Excel work book as the data source


HI All,

I have to create the Dashboard for which the the source data is in Excel work books .WE do not want to buy the license for Excel services . I was trying using SSRS integrating with share point .When i was creating reports using source as Excel works by creating DSN for the ODBC connection I was getting the following error

I wrote  the the following query to get the report from Excel work book

select * from [Activity $] where Activity is my work sheet name

An errrror Occured while executingthe quesry

ERROR[42000] [Microsoft] [ODBC Excel Driver ]Invalid Bracketing of name 'Activity $'


Moderator Note: NEVER ask for quick; asap help or say your question is urgent. Wait your turn.

ItemAdded Event not always returning SharePoint field information when InfoPath form submitted


 (SharePoint 2007)

I am struggling with an issue related to InfoPath and use of the ItemAdded event handler.  I have created an InfoPath form that contains several fields that are being published to SharePoint fields in a Forms Library.  When I submit a new form, the SharePoint data is being correctly updated.  ian see it in the list.  However, I am trying to write an ItemAdded event handler that performs specific logic based on the value of one of the InfoPath/SharePoint fields for the form being added to the library.  The logic appears to work correctly the first time through.  I can sucessfully read the value from the field and then execute my logic.  However, subsequent submissions appear to not be able to read the values.  It is like they don't exist or are null.  I am thinking that it has something to do with threading but I cannot find a work around for this problem.  The interesting thing is that the same exact logic works correctly when the ItemAdded event handler is tied to a standard Document Library.  Any word documents that are being added always read the values correctly. 


Does anybody know what might be causing this or a possible way around this issue? 



SharePoint 2007 - Import from User Info List into InfoPath 2007

We are using Sharepoint 2007 with InfoPath 2007 and are trying to pull names from the UIL and display the name last name first.  Such as Smith, John.  It seems to pull and display first-name first.  Any way of displaying last name first? Thanks for the assist.
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