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?
View 1 RepliesHi All ,
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
thanks
Is there has some standalone help file about sql ce except the Sqlce online document or in MSDN?
View 4 Replies View RelatedI have only Management Studio Express, is there a way to document my database?
View 3 Replies View RelatedHello 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.
View 1 Replies View RelatedHi everyone,
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
View 4 Replies View RelatedHi,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
View 3 Replies View RelatedI 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.
Regards
JohnJames
When you use the Jump to Report feature is there a way to also go to a specific document map link?
View 5 Replies View RelatedAll,
I have a report with a document map and when I run the report through
IE 7.0, the Document Map is blank. Running that same report through IE
6.0 and it is fine.
Both instances are run against the same server via Report Viewer so
there is no difference other than the client IE version.
Anyone know of a work around for this?
Thanks,
Sherry
Besides reports we also have some documents that have been uploaded to Report Manager. Is there a way that we could set a subscription for a document? I currently do not see one.
View 4 Replies View RelatedDoes anyone know if it is possible to control the formatting of the Document Map in SSRS? I would like to set the background color if possible.
View 5 Replies View RelatedThe contents of document maps do not appear since I upgraded to IE7. They still appear for users on IE6.
Reporting Services version is SQL2000.
Have looked all over - this problem has been reported in a number of places but there seems to be no response / fix / work-around from MS.
Can anyone help or at least comment?
Hi,
Does anyone know if it is possible to specify the size of a document map in a report? Ot it's scroll bar?
I have a report that contains about 100+ groups and therefore 100+ items in the document map. On initial display of the report, about 25 groups are visible in the document map, and you can see that there is more data below (half a row is shown) but the scroll bar does not allow scrolling all the way to the bottom of the list.
Thanks.
I add document map to my report but I forgot
how can I remove it
thanks!
Where can I download MS SQL help document? Thanks!
View 2 Replies View RelatedHi ,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 .
View 1 Replies View RelatedWe 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.
I am interested in storing millions of documents in a database. It appears that Oracle has a better selection of document management tools including a search engine than does SQL 7.
Any comments, suggestions, reviews, and/or white papers regarding this issue would be greatly appreciated.
Regards,
Steve Marsh
I am trying to save an MS WORD document... What Data type should I use?
I know in Sybase we used BLOB...
I have a client that would like to archive all of the documents .word, .xls, .pdf, .jpg, email coorespondance, etc. into some sort of database so in the near future when the project starts up again all of the information is in a clear consise format. I was hoping that this forum could provide some guidance in selecting a software package and a discussion on how to proceed.
I have 6 gigs of documents in a folder on our server.
I was planning on delivering the organized data on a external hard drive after putting the data into some sort of database.
I would like to include metadata about each particular document.
like
who created the document,
Key words about the document's purpose,
time frame the document is revelant for,
and so on.
I would like to use a database structure and possibly hot link the document to the DB.
I would like to use xml (if possible) for the metadata.
any help is greatly appreciated on this
I can be reached at
khively at maximusa dot com
for any additional questions
hai everyone
i have a requirement.
i am writing a very large sp.
i have written many comments in that sp.
i wanted to generate a document from that comments i have wriiten in that sp.
i know a similar thing can be done in vb.net comments.
is it possible top do such a thing in .sql file.
ie
all comments that i have wriiten in my .sql file should be extracted.
to a document.
hi all,
I need a built-in function which is given output of xml node value when i am sending a parameters ... xml document and node name.
example :
xml document
<employee>
<eno> 1 </eno>
<ename> dddd </ename>
<salary> 10000 </salary>
</employee>
I will give this xml document and node name (for eg: ename) to buil-in function. I want output 10000.
any built -in function like ... in mssql 2000.
Thanks&Regards,
Msrs
I'm newer to MS SQL, but have a programming background, so I'm going to try to describe what I'm doing in that sense.
What I want to do is pull an entire column of data from one table, and insert it into a column in another table. Typically, I would do this with an array and while loop or something similar. I've figured out how to do a while loop in SQL, but the array situation has me stumped. I tried reading http://weblogs.sqlteam.com/jeffs/archive/2007/06/26/60240.aspx that article, however it referred to a procedure, and I have no background or experience with procedures.
Any sort of idea or document on a technique to do this would be most appreciated, thank you!
Is there any utility that can document some sql server 2005 tables that I have in my database?I mean to add some description to column names so that I can know what they represent.Thank you!
View 3 Replies View Relatedhi 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
View 2 Replies View RelatedIs there a common way to document ETL (packages / data flows)? I looked for documentation templates in the internet but didn't find anything which was useful.
Thanks,
Kenan
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"
'or
'mstream.Write oleRst!tempole
rst.Fields("SubsectionDetail").Value = mstream.Read
rst.Update
rst.Close
Set rst = Nothing
Set mstream = Nothing
End If
How to make a hierarchy in a document map?
In the report designer, I have two levels of grouping: First Level: Country, Second level: City. I have no problem to create a document map containing both grouping.
However, the city and country are listed in a sequential order in the document map.
What else should I do and how, to make them a hierarchy that looks like a tree (file folder) structure?
Thanks.
Can anyone help,
I have created a report which works great when the users run from IE6, but when anyone runs report from IE7, the report displays ok, but the document appears to build but displays absolutely nothing.
Has anyone seen this problem with IE7 using Reporting Services 2000?
Thanks people
I need to import a word document as an RDL,
as this would save a lot of typing and formatting.
Could you advise if there is a tool available to assist with this.
Thanks
JohnJames
is it at all feasible to embed an office doument (specifically word) into an ssrs report so that the document will print out when renderered to pdf?
View 4 Replies View Related