We are facing an issue while creating a word document through BCP utility of MS SQL Server 2005.
Ours is the Survey application where there could be various Respondents with different languages who can receive a Questionnaire through mail. Now the requirement is to send the Questionnaire in Word Document which would look like a form having Radio buttons, check boxes and images etc. controls.
To achieve this we have written a Stored procudure in MS SQL Server 2005. In this Stored procedure, we are writing an HTML Code in formatted manner and at the end using BCP utility we create a word document in specific folder. Then we attach the document from that folder in mail using sp_sendmail of MS SQL server 2005 and send it to the Respondent of the Survey.
1> The issue we are facing here is when the Respondent receives the mail and opens the word attachment, it opens the document in designer mode where controls(Radio Button and check boxes) are not clickable. Hence Respondent is not able to fill in the document as a form. However Respondent has to click on 'Exit Designer' button in the menu to make it as interactive form. The requirement is when Respondent opens the Word document it should directly open as Interactive form rather that clicking on 'Exit Desinger' button on menu.
2> Secondly when we create a word document, there are some images that need to be shown as seen below. As of now, in HTML code we have given a path of the Web Server as '<http:WebServerIP/images'. However we would like to know whether there is any way to Embed the images directly in the Word Document rather than referancing them from the Web server path.
Hi ,I would like to whether its possible or not.I have stored word document(Resume) in SQL server. Now i want to search for particular key word.for example . I want to list down all details of candidate which have ASP.Net mentioned in their resume. So please provide me any link / or article .
hi i was trying to print a word document from a stored prcedure usingthe following two methods1)cd C:&&"C:Program FilesMicrosoft OfficeOFFICE11winword.exe""c: emp.doc" /mfileprint"/mfileprint" - this macro contains the code to print the word documentand exit the word , this command runs fine when i run it at the commandprompt but when running from query analyzer i can see the job in theprinter queue but it will never finish and i need to kill the wordmanually to stop the query analyzer to finish.2)declare @hr int, @object intExec @hr = sp_OACreate 'Word.Application', @Object OUTPUTexecute sp_OAMethod @Object, 'PrintOut' ,@filename:='C: emp.doc'etc........Thank you
I have a form that has a Word object. I want to save that object to the sql db. The original front and backend was an Access db and this all worked using an ole field. The backend data has been moved to a sql 2000 db. The reading of original Word objects works fine but I can't get any new objects stored. I have seen postings that there is no way to by-pass saving the object to a temp file but really I can't get anything to work. The attached code makes no complaints but when I try to access the new object I either get an empty object or an error that the ole server has a problem.
The code below includes simply saving an exisiting doc but that doc does not come back out of the db. I tried just for grins to store the form object in a temporary Access table and then save that field. Actually I got no complaints but then I got the same results. The use of the external file mimics examples I've seen even on this forum. any suggestions are appreciated.
Rick
'Now save word doc that is contained in the form entity If Not IsNull(Me.oleSubSectionDetail) Then Dim rst As ADODB.Recordset Dim mstream As ADODB.Stream
'Tried to make it happen by essentially moving 'a database field to a db field Dim oleRst As DAO.Recordset Set oleRst = CurrentDb.OpenRecordset("tmpOLE", dbOpenDynaset) oleRst.AddNew 'tempole is an ole defined field oleRst!tempole = Me.oleSubSectionDetail oleRst.Update oleRst.MoveFirst
'Select record I want to update Set rst = New ADODB.Recordset rst.Open "Select * FROM [tbl-SOW Detail] WHERE RecID = " & RecID, ADOConnection.SQLDB_Connect, adOpenKeyset, adLockOptimistic
Set mstream = New ADODB.Stream mstream.Type = adTypeBinary mstream.Open
mstream.LoadFromFile "c:\Documents and Settings burgeMy DocumentsStandard Contracts-Cover Page.doc"
I'm designing a Job Recruitment Website, in which the admin person searches for the right candidate for the job using certain keywords . Each jobseeker will be uploading his CV (ms word doc) during registration .How can i search for keywords in the word documents. I just want the candidate reference once i found keyword match in the word docs.I heard about the indexing and blobs in sql server? But dont know much about it Are these the only solutions ?Is there any better approach for this ?Any help will be greatly appreciated
chapter1 Delegates officially are to nominate Cheney as the GOP's vice presidential candidate before he addresses the group Wednesday night. chapter2 "I think that the vice president's speech tonight is going to be about big issues, the big issues of this campaign -- the war on global terror, the president's education policy, the fact that the economy is turning up again," she told CNN's "American Morning." chapter3 She said she had known her husband since he was 14 and planned to share anecdotes that many people have not heard before in her introduction. Chapter4 Maverick Democratic Sen. Zell Miller of Georgia is scheduled to deliver Wednesday's keynote address -- a role he also played at the 1992 Democratic National Convention, which nominated President Clinton. Chapter5 In the earlier speech, Miller, then governor of Georgia, said that "for 12 dark years, the Republicans have dealt in cynicism and skepticism. They have mastered the art of division and diversion, and they have robbed us of our hope."
I wanted to import the above word doc into my sql server DB. I have two columns in the table 1.Chaptereid 2.chapter_notes chater1,chater2,chapte2,chapter3,chapter4 and chapter5 should go into chaptered column and the text followed by the chapter id should be imported into chapter_notes column.
I have a doubt regarding SSIS data destinations. I have a word document which is stored in the sql database table as varbinary(max). I want to fetch that doument and load it into word document through ssis.Is it possible?If so,how to do it?
One more question regarding data destination..I have created an interface to execute the ssis package from asp.net application.The package will be run by sql server agent.The question is is there any way that the package output will be shown on the local machine rather than host machine(which has interface and package).
Hi all, I have created a word document in my application (.Net). How can I save the word document (containing tables and some HTML formats) in a database and retrieve it for later use? Thank you in advance,
Is it possible to extract rdl template from a given pdf or word document? We are specifically interested in extracting layout information. We want to do it programatically.
The content and layout of pdf or word document are simple.
I've created a report that will print on a pre-printed paper. Is there a way to embed a word document into a report or some other type on document. I'm not able to format the text like in word.
I have a request from the customer to export a report to Word as a read-only document. I am restricted to out-of-the-box SSRS 2008, so I cannot write any custom export functionality.
The customer has the ability to export as PDF, and I suggested that, but before I tell them there's no easy solution, I wanted to get input from other Reporting Services folks.
I am using an invoice image that is preset and a fixed size. I am trying to lay text boxes on top of this image, but the boxes move around differently when you preview and/or print preview. If this is deployed, then the form prints and all of the text box information prints after the invoice image. Has any one experienced this before?
And one more question, is there a way to make a report a fixed length in size, ie, another invoice that might have 1 line or 23 lines and the total always needs to print at the bottom of the report and not move up the page. Is there a way to fix your report to accomodate for that? I have tried list box, matrix, etc and I am unable to find a solution to this.
Any help with either of these questions would be greatly appreciated!!!
I have an exiting excel workbook say master.xls. Now I need to dynamically create and append a new worksheet to the above master.xls every month end using the Reporting services.
Could you please guide me how dynamically creating the worksheets task can be achieved using the reporting services?
Your any guidance or help in this matter will be highly appreciated.
hi! I'm just wondering does anyone know how to create an sql command that can search word by word? what i mean is like I have a product with name 'harry potter broom'. I want an sql command where if i type only 'harry broom' this 'harry potter broom' product will show up. Does anyone have any idea? Here's my sql comand: (I'm using asp.net vb script do develop this system) ------------------------------------------------------------------------- query = "select distinct * from product where " & _ "(pname like '%" & keyword & "%' or " & _ "pdesc like '%" & keyword & "%' ) and " & _ "(price >= " & price1 & " and price <= " & price2 & _ ") and status <> 'out of stock' order by price asc" ------------------------------------------------------------------------- Thank you.
Is the word "Name" a reserved word in SQL? look at line 10 of my stored procedure. When I use the word "Name"it is highlited in blue by SQL Server? Note I only list part of the stored proc 1 CREATE PROCEDURE [dbo].[GetXMLPeopleNames] 23 (4 @Status nvarchar(3)5)6 AS7 SELECT8 PersonId,9 PersonDescription,10 Name,11 UpdateDate,12 UpdateAppUser13 FROM14 Customer WHERE Customer.PersonDescription=@Status15 ORDER BY
I work for a financial company where we send out lots of correspondence to clients on a daily and monthly basis. This would typically be something like a financial report, account statements, etc. We've decided to use PDF as the format which these documents must be in when our clients receive them.
Our marketing and sales departments designs the templates of these documents using Microsoft Word. They can save these MS Word documents in the Word XML format (either 2003 or 2007). We want it in XML format, because it is text based, and we can therefore string replace the content to update the template with a client€™s information. In the same token RTF would also do, but the file size when converted to RTF is a problem.
What I am looking for is a way to convert this XML into PDF using something like XSL-FO - i.e. we do not want to use the Word Interopt on our Production Server, firstly it is a little slow and secondly the production server is unmanned and we cannot allow a WinWord.EXE process to not close successfully for some or other reason.
I've tried a number of companies' evaluation software to try and achieve this (converting the WordML to PDF via XSL-FO), but so far no luck.
Does anybody know of a stylesheet out there with which I will be able to achieve this? Or an alternative method of converting MS Word files into PDF without using Word to do it?
I have a matrix table which has two groups in the columns
I am trying to create a multileveled document map which i have succeed by
1. Edit Group 1 properties and setting the document map properties to the name of the field 2. Edit Group 2 properties and setting the document map properties to the name of this field and making the parent group the name of Group 1
The document map appears with the correct groups and name , however when I click on the values it doesnt take me to any where !!! It refreshes the screen but it doesnt go anywhere !
Can someone please help me troubleshoot this or know what i may be missing
When i publish a report to our reporting services site, it comes with a document map that I cannot seem to get rid of and is really annoyong to users. How do I stop this from happening and appearing?
Hello Everyone and thanks for your help in advance. I am developing a document storage application for an intranet that will store various Word, Excel, and PDF documents. Most of the examples I see utilize SQL Server and an image field rather than the FileSystem Object to store documents. My concern with this method is that some of the documents may be several hundred pages (not exactly sure of the actual file size yet, but they must be fairly large). My question is, where does the use of SQL Server become impractical for this type of application? Any insight would be greatly appreciated. Thanks.
Has anyone seen this white paper below? If yes, can someone point me to the right direction. I can`t find it anywhere in the msdn.microsoft.com/developers. I got this info from the Winnt mag.
------ Microsoft`s Henry Lau has prepared an awesome 49-page quick reference that helps you configure SQL Server 6.5 for maximum performance and troubleshoot poor performance. Here`s the outline:
Introduction Top Performance Items to Review for Initial SQL Server Configuration More on Memory Tuning Understanding the Functions of LazyWriter, Checkpoint, and Logging Read-Ahead Manager Disk I/O Performance Clustered Indexes Nonclustered Indexes Covering Indexes Index Selection RAID Creating as Much Disk I/O Parallelism as Possible Tips for Using ShowPlan Tips for Using Windows NT/SQL Performance Monitor Monitoring Processors Disk I/O Counters Tips for Using SQLTrace Tempdb in RAM? Deadlocking Join Order Importance SQL to Avoid If at All Possible Use ShowPlan to Detect Queries That Are Not Using Indexes Smart Normalization A Special Disk I/O Tuning Scenario: EMC Symmetrix Some General Tips for Performance Tuning SQL Server References
Download this gem from msdn.microsoft.com/developer
I have a database which stores documents (e.g. policies and guidelines)in our content management system. The follow relationships exist:Documents (1-to-Many) LinkTableKeywordLink (Many-to-1) KeywordsDocuments (1-to-Many) LinkTableAttachments (Many-to-1) AttachmentsDocuments (1-to-Many) LookUpSubjectsDocuments (1-to-Many) LookUpDocTypeWhen the user conducts a search I want the SQL to check if the stringthey enter is present in:* the Title, Author, Summary fields of Documents OR* the Title or Path of the Attachments* the Keywords that are links OR* the Subject that is linked OR* the DocType that is linked.Is this possible in one SQL query. I have tried the following:SELECT DISTINCT Documents.Document, Documents.Title,PriorityFROM Documents,Attachments,Keywords,LinkTableAttachments,LinkTabl eKeywordLinkWHERE((Documents.Document=LinkTableAttachments.Document ID andLinkTableAttachments.AttachmentID=Attachments.Id) OR(Documents.Document=LinkTableKeywordLink.DocumentI D andLinkTableKeywordLink.KeywordID=Keywords.Id))AND (Documents.Title Like '%SEARCHSTRING%' OR Documents.Author Like'%SEARCHSTRING%' OR Documents.Summary Like '%SEARCHSTRING%' ORKeywords.Keyword Like '%SEARCHSTRING%' OR DocType.DocType Like'%SEARCHSTRING%' OR Attachments.AttachmentTitle Like '%SEARCHSTRING%'OR Attachments.Path like '%SEARCHSTRING%' or Subjects.Subject Like'%SEARCHSTRING%')AND StartDate<=getDate() and ReviewDate>getDate() order by Titlebut this causes, perhaps understandably, a timeout error.Any thoughts?Thanks!Steve
Hi,I need deep knowledge about DTS tasks. Can anyone send me an e-book orrelated document about DTS packages. (Links on the Internet site aregenerally advertisement or not working links).Thanks,Veysel Can Demir
I have a Report that has a document map Label in the Report which I need to remove. However as the report has over 50 text-boxes I am having difficulty locating it. I have had a look at the XML but that does not seem to indicate the offending text box. Any advice would be greatly appreciated.
