.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

SQL Reporting - Merging fields into document

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Currently, we have a process setup that has a user create a merge in the application, then that merge is dropped into a .csv file onto the root of the c: drive of the individual's PC... they then take the .csv file and use macros within Word and run a merge process into a document template... (these are documents that are sent to the court for renewal of an expired legal process)..  I'd like to know if there is a better way of doing this? Is there a way of eliminating the .csv file and the merge process of Word, and keep everything within SQL and the Reporting services?  Any help in pointing me to the right resources for this would be appreciated. Thanks! jill

View Complete Post

More Related Resource Links

SharePoint makes Office Document custom fields unreadable


We're using WSS 3.0SP2 with a Document Library that has document-level columns (fields) added. The columns (fields) are defined as single-line text; nothing fancy. In SharePoint we can set the field values no problem. When we pull the documents back out of SharePoint to the file systsem, and look at the Custom Fields, the values are unreadable gibberish. They look like graphics lines and boxes and the Type is set to Unknown.

Any ideas why this is happening and how to fix it?

Changing fields while updating an InfoPath Form to a SharePoint 2010 Document library

My document library has following EventReceiver: <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <Receivers ListTemplateId="101"> <Receiver> <Name>EventReceiverDocumentLibraryItemUpdating</Name> <Type>ItemUpdating</Type> <Assembly>$SharePoint.Project.AssemblyFullName$</Assembly> <Class>EventHandling.EventReceiverDocumentLibrary</Class> <SequenceNumber>10000</SequenceNumber> </Receiver> </Receivers> </Elements> Updating a browser enabled InfoPath form in the document library fires following event: Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties) Try Me.EventFiringEnabled = False properties.ListItem("Lastname") = "Testperson" properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = True properties.ListItem.SystemUpdate(False) ' solution 1 properties.ListItem.Update() ' solution 2 properties.ListItem.UpdateOverwriteVersion() ' solution 3 properties.ListItem.ParentList.ParentWeb.AllowUnsafeUpdates = False Me.EventFiringEnabled = True MyBase.ItemUpdated(properties) Catch ex As Exception Me.EventFiringEnabled = True E

Exception occurs when checking in document with missing required fields

I have a document library with required fields. When the user uploads a document and closes the Properties window without entering the required fields, the document is still uploaded, but is left checked out. If the user subsequently attempts to check in the document without first editing the properties to supply values for those required fields, an exception is thrown and the user sees the following: Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed. The Event Log shows the following: Exception message: You must fill out all required properties before checking in this document. Request path: /_layouts/checkin.aspx Stack trace: at Microsoft.SharePoint.ApplicationPages.Checkin.OnLoad(EventArgs e) ... I would like to trap this error and present it to the user or somehow prevent the check-in event from getting far enough to cause this exception. I have tried coding something like this: public override void ItemCheckingIn(SPItemEventProperties properties) {     try     {         base.ItemCheckingIn(properties);     }     catch (SPException ex)     {         properties.Cancel = true;      &n

Cannot choose language of word exporting document with Reporting

I am creating report (in word) with Reporting Services 2008. I can't find a way to specify the language of the document. It is always in english.

Windows Sharepoint Foundation 2010 - Document Library Settings with Reporting Services 2008 R2 in in

I have a client who has recently upgraded their SharePoint system to Windows Sharepoint Foundation 2010 with Reporting Services 2008 R2 in integrated mode. I have configured reporting services and am able to deploy reports to SharePoint. The client created a document library before the upgrade to WSF 2010. I need to add Report Builder 3.0 to the New Document menu and found the following article. http://technet.microsoft.com/en-us/library/bb326289.aspx "Allow management of content types?" is set to yes under the advanced document library settings. The problem is that when I try to "add from existing site content types" the reporting services content types are not in the list. I appreciate any help you can give me.

Excel fields linked to files in the document library do not update


We are having an issue with an Excel spreadsheet that is linked to several Excel documents in a document library.  Mutliple staff members update several "sub" spreadsheets with information that is rolled up to the "master" spreadsheet.  Excel appears to behave correctly in that if I open both the sub and master spreadsheets in my Excel window at the same time, the data in master gets updated.  If I just open the master, I have stale data.  I'm not sure SharePoint is to blame here, so I'll post this in the Excel forums as well, but any information or experience anyone has had with this would be fantastic.

Thanks in advance for any help/advice!

URGENT: Document Library Content Type not inheriting some fields from parent Site Content Type


I have a situation that has foxed me!! I have a site level content type that has 8 fields... I use this to create more content types at the site level and use these in multiple Document Libraries (I have 40 doc libs).  This works fine for 38 of the libraries.  But for 2 of them... 2 of the columns are not showing up on the document libraries.  These are user lookups fields.  I am not sure why it's not working in these libraries only!  When I use the same content type in another library... the inheritance does not break for these fields!

Anyone please provide some guidance on this?  I am using WSS 3.0 and SPD to do workflows.

On another note... the content type has a template (in excel) attached to it.  When I create the content manually using the content type from the New menu option, the template is used... however, when I try to add it using an SPD workflow, it creates a blank template... the content type template is not being used.

Please help... I am in a fix and need to release this application today!!!

Merging Multiple Excel files (exports from Reporting Services)


So we have Office 2007 on our system and I'm trying to use Excel Interop to take a number of Excel files, which are exports from Reporting Services, and combine them into one large workbook.  I'm using the code below which works fine to get all the information from all the files into one workbook but the colors of things goes absolutely haywire.  Anyone know why my colors are getting all out of wack?

protected void MergeFiles(string destinationFile, string[] sourceFiles, string guid)
                //1. Validate folder,  
                //2. Instantiate excel object  
                //3. Loop through the files  
                //4. Add sheets  
                //5. Save and enjoy!  


How to show a "document map" in reporting services 2005 report viewer


Hi there,

I am wondering how to show a "document map" in reporting services 2005 report viewer. Under


it is stated that there should be a document map icon that I can click on to show my report map but this icon does not exist. Is there anything I have to do to enable it?

Best wishes



SharePoint 2010 Documents inside Document set is no inheriting shared fields (lookup fields)


I have a situation that is making me crazy !! I have a content type that inherits from Document set. I have set some fields (metadata) in the document set and configured the document set to share it with documents inside it.

All the fields are being shared (inherited) to the documents inside the document set except for the lookup fields

I have 2 lookup fields that looks for information from a SharePoint list.

I'm using SharePoint 2010.



Thanks ..


External Data Fields in a Word Template saved as a content type in a document library with multiple


I have created a Word Template for a Document Library that has an External Data Column in it of Client Name which also adds Client Address1, Client Address2, Client City, Client State, & Client Zip.  Now this works fine for a Document library with that template as the Template.dotx file. 

I want to be able to make a bunch of Templates and have them all as Content Types in one Library.  When I do this I cannot get the External Data Quick Parts to work.

Anyone have any ideas?

Content Type Properties/Fields on Document Template


I have created a content type and added some custom site columns to it.  I have also created a document template (.dotx) where I have added some of the columns as fields that appear in the footer and header of the document template.  In the Advanced Settings of my Content Type I have added the .dotx template as the template for the Content Type.

In a document library I added the content type.  When I create a document from the content type in that document library the fields on the new document do not get updated when I select different data for any of the columns in the Document Information Panel.

Even when I save the document and reopen it the data in the columns on the Header or Footer does not get updated so there is a discrepancy between the data selected on the DIP and what is shown in the Header or Footer.

What am I doing wrong?

Change the order of fields in the 'edit properties' screen in a document library?


How can I change the order of the fields in the 'edit properties' screen on a document library?

In a standard list there is an option for 'column ordering'. This option does not exist in a document library! In my document library I have added some site columns to be used for filtering of documents in the library. But I'm not happy with the order they are being added into the 'edit properties' screen. The order looks different to the order that is shown in SharePoint Designer in the doc library when I click the 'edit list columns' link.

Any help much appreciated.


Create a pdf document from win form application by fetching fields from database


Assuming i have a winform that has a button called "Create a Quote". Once user clicks it, a PDF File gets created on desktop. The PDF File has a fixed design/structure e.g. the logo is at the top left corner, the headers are fixed, etc. However, the data it self is pulled from a database.

As you see above, Quotation #, Description, Qty, U.P (USD), T.P (USD) records should be fetched from the db and dumped in the pdf template then create the pdf for user.

I haven't done this before. I hope my question is clear enough. Feel free to put useful web links that help me achieve it.

Any help will be appreciated.

How to Connect SQL Reporting Services to a SharePoint Document Library (Shared Documents)


Hi experts,

I've read 1 article and already tested it, and it works for me to connect reporting services with SharePoint List



But my concern now with the same approach how can i connect to SharePoint Document Library (Shared Documents)



I've 1 shared document link, inside there we store all the pdf image that we scan. and each image created we define field/attribute at Edit Properties. Meaning we just not store the pdf image but also information input.


I've contact the owner of blog for long time but no response. Please advise Thanks in advanced.


Im using : SharePoint 2007, SQL 2005 & Visual Studio 2005

validation of fields in document library in sharepoint 2007


i have a secenario like ,when the user uploads an document in sharepoint 2007 document library he need to enter the metadata or values for the fields in edit form.aspx .Now if there is say FieldX which is a chioce field(Drop down list) ,if the user select option
"YES" then FieldY which is a simpletextfield should be mandatory ,if the user selects Option "NO" then FieldY should be non-mandatory.can u pls provide the solution at the earliest

Thanks in advance



Customize Document Library EditForm with Additional Fields


Hi Friends,

I've read through a few threads about customizing editform of doc library, but I still have question about adding custom fields which are not property of the list item, these fields shall be collected and directly written into the document associated.

I know that FormField as "ID" "Name" "Title" are all part of the property of item, so they can be saved after clicking the "OK" button, but how can I override the existing OK button logic to save my custom fields to the document?


EaTing Shan
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