Does anyone know how to change the Document Map root text? - DISPLAYNAME property

hi, guys
Does anyone know how to change the Document Map root text? For example, i have report, the file name is sc.rdl, and then the root is sc. Apparently this is not good. I am thinking is there a way to change it.If you are using the ReportViewer controls in VS 2005, set DisplayName on either ReportViewer.LocalReport or ReportViewer.ServerReport, depending on the mode you are using. Setting DisplayName will also affect the generated file name for export. If you are connecting to the server directly via url access or using Report Server 2000, there is no way to change this value.|||

Brian, I want to be able to assign displayname at report design time....then be able to extract it out for display purposes when using the reportviewer control connecting to a server report. Doesn't sound like it's possible but is this something for a future enhancement. Currently, using the report viewer control, there's limited properties exposed when using ReportViewer.ServerReport.<property>. Would be nice to get at the author, description, etc. (and have an additional displayname property available).

Does anyone know how to change the Document Map root text?

hi, guys
Does anyone know how to change the Document Map root text? For example, i have report, the file name is sc.rdl, and then the root is sc. Apparently this is not good. I am thinking is there a way to change it.If you are using the ReportViewer controls in VS 2005, set DisplayName on either ReportViewer.LocalReport or ReportViewer.ServerReport, depending on the mode you are using. Setting DisplayName will also affect the generated file name for export. If you are connecting to the server directly via url access or using Report Server 2000, there is no way to change this value.|||

Brian, I want to be able to assign displayname at report design time....then be able to extract it out for display purposes when using the reportviewer control connecting to a server report. Doesn't sound like it's possible but is this something for a future enhancement. Currently, using the report viewer control, there's limited properties exposed when using ReportViewer.ServerReport.<property>. Would be nice to get at the author, description, etc. (and have an additional displayname property available).

Does anyone have any ideas ..

.. on making a DB map?
Hopefully someone knows of a tool/util.
Here's where I'm coming from:
We have a list of changes to make to our DB and the PHP interface.
I'd like to put together a list (map) of every table referenced on
each php page, as well as one showing every php page which uses each
table.
I'd like to have this as a reference so that when we bring in a
programmer, they can work more efficiently and be less likely to
create bugs.
Any ideas?
-MoDo you mean an ERD? How about using the diagram tool built into SQL Server.
If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSMS.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Mo" <Mehile.Orloff@.gmail.com> wrote in message
news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
> .. on making a DB map?
> Hopefully someone knows of a tool/util.
> Here's where I'm coming from:
> We have a list of changes to make to our DB and the PHP interface.
> I'd like to put together a list (map) of every table referenced on
> each php page, as well as one showing every php page which uses each
> table.
> I'd like to have this as a reference so that when we bring in a
> programmer, they can work more efficiently and be less likely to
> create bugs.
> Any ideas?
> -Mo|||On Mar 3, 5:33=A0pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Do you mean an ERD? =A0How about using the diagram tool built into SQL Ser=ver.
> If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSM=S.
> --
> Andrew J. Kelly =A0 =A0SQL MVP
> Solid Quality Mentors
> "Mo" <Mehile.Orl...@.gmail.com> wrote in message
> news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
>
> > .. on making a DB map?
> > Hopefully someone knows of a tool/util.
> > Here's where I'm coming from:
> > We have a list of changes to make to our DB and the PHP interface.
> > I'd like to put together a list (map) of every table referenced on
> > each php page, as well as one showing every php page which uses each
> > table.
> > I'd like to have this as a reference so that when we bring in a
> > programmer, they can work more efficiently and be less likely to
> > create bugs.
> > Any ideas?
> > -Mo- Hide quoted text -
> - Show quoted text -
Thanks for the suggestions.
I'll start there.
-Mo

document map works in preview but not in browser

Hi,
I have a strange issue - the document map works in preview mode but not when
used in the browser. No doubt this is a configuration issue in IE, but I
can't find it. Any ideas?
TIA,
Paul IbisonCan you be more specific? What do you mean it doesn't work? Do you get an
error when you click on a node in the doc map tree? Do you get an error in
the document map frame? Is the document map not showing up at all?
What version of IE are you using?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23mCNCnhWEHA.4032@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a strange issue - the document map works in preview mode but not
when
> used in the browser. No doubt this is a configuration issue in IE, but I
> can't find it. Any ideas?
> TIA,
> Paul Ibison
>|||Brian,
the version of IE is 6.0. The document map appears correctly and expands,
contracts etc. However when clicking on a node there is no repositioning of
the main document. Strangely, in the development environment on the same box
it works fine. BTW, the problem applies using either the report manager or
the reports service.
TIA,
Paul Ibison|||Are you seeing any script errors in the browser (check the lower left corner
of the IE window for a warning icon)?
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:u6lXIVjWEHA.712@.TK2MSFTNGP11.phx.gbl...
> Brian,
> the version of IE is 6.0. The document map appears correctly and expands,
> contracts etc. However when clicking on a node there is no repositioning
of
> the main document. Strangely, in the development environment on the same
box
> it works fine. BTW, the problem applies using either the report manager or
> the reports service.
> TIA,
> Paul Ibison
>|||Brian,
no, there aren't any errors or warnings. I've even tried with two textboxes
and no datasets or other complications, with the same result.
TIA,
Paul Ibison

Document map Problem

I accidentally created a document map and would like to remove it but I can
not find out which object in the report is causing the map to be generated.
I have a Chart and a matrix in the report. How can I figure out what is
causing the map to get created?
TIA
Deanthe one that's named is the one with something in the label; remove that value
"Dean" wrote:
> I accidentally created a document map and would like to remove it but I can
> not find out which object in the report is causing the map to be generated.
> I have a Chart and a matrix in the report. How can I figure out what is
> causing the map to get created?
> TIA
> Dean
>
>

Document map pane refreshing ENTIRE page!

I am using the ReportViewer control with SRS2005. I have an extremely large report (243 pages) - however. It takes an extremely long time to load the report as well as populate the document map pane.

When one clicks a link in the document map pane, it refreshes the entire page - and thus causes the report to take another 2-3min to repopulate the document map.

However, if I were to access the Report Server directly, clicking a link only causes the main content page to be refreshed.

This is a substantial difference between selectively refreshing as opposed to refreshing the ENTIRE page and hence taking 2-3min between links.

I am defining the report as:

<rsweb:ReportViewer ID="rvMain" runat="server" AsyncRendering="true" ProcessingMode="Remote" ShowParameterPrompts="False" OnPageNavigation="rvMain_PageNavigation" Width="100%" Height="800px" DocumentMapCollapsed="False" DocumentMapWidth="300px">
</rsweb:ReportViewer>

Hi,

Have you found a solution to this issue?

From my investigation, it seems that the problem is caused by using the OnPageNavigation event, since when removing it (in my case) the document map behavior does not reproduce.

I also found cases where the toggle functionality stoped working as of catching the OnPageNavigationEvent, after installing SQL 2005 SP1.

To me it looks like a bug in the web version ReportViewer control.

Regards

|||Hi,
I've a similar problem with Internet Explorer with SQL Server 2005, SP 2.
It would be of great help if someone could give a soln or provide some direction.

Document map pane refreshing ENTIRE page!

I am using the ReportViewer control with SRS2005. I have an extremely large report (243 pages) - however. It takes an extremely long time to load the report as well as populate the document map pane.

When one clicks a link in the document map pane, it refreshes the entire page - and thus causes the report to take another 2-3min to repopulate the document map.

However, if I were to access the Report Server directly, clicking a link only causes the main content page to be refreshed.

This is a substantial difference between selectively refreshing as opposed to refreshing the ENTIRE page and hence taking 2-3min between links.

I am defining the report as:

<rsweb:ReportViewer ID="rvMain" runat="server" AsyncRendering="true" ProcessingMode="Remote" ShowParameterPrompts="False" OnPageNavigation="rvMain_PageNavigation" Width="100%" Height="800px" DocumentMapCollapsed="False" DocumentMapWidth="300px">
</rsweb:ReportViewer>

Hi,

Have you found a solution to this issue?

From my investigation, it seems that the problem is caused by using the OnPageNavigation event, since when removing it (in my case) the document map behavior does not reproduce.

I also found cases where the toggle functionality stoped working as of catching the OnPageNavigationEvent, after installing SQL 2005 SP1.

To me it looks like a bug in the web version ReportViewer control.

Regards

Document map on Mac

I have seen other posts which indicate issues with the document map
and issues with reporting output in general on the Mac. However, I
haven't seen that anyone is having the specific problem I am having.
I have a report which uses a document map. It works perfectly in IE
6.0 on a PC when rendered as HTML or PDF. The report displays as HTML
(but not PDF) on the Mac in both IE and Safari, however the document
map does not display. This functionality is crucial for me. My main
concern for this particular client is making this document map work
with IE on the Mac whether that be in HTML or PDF. I should note
that, long term, I expect to see reports work in both browsers on the
Mac.
So my question is specifically:
Has anyone succeeded in displaying the document map in a report
rendered as HTML or PDF in IE on a Macintosh running OS 9 or OS 10,
latest release of IE.I have more information which I am sharing with anyone else who is
having this problem. The HTML output seems to use an IFrame. The
IFrame is supported in IE 5.2.3 for the Mac and it is also supported
in Safari. So, I still don't know why the document map doesn't show
up in HTML.
However, the PDF problem was with the Preview application in the Mac.
By default, PDF files are opened by Preview, even when they are opened
from a web page. I have opened other PDF 1.3 files from the web with
Preview without any problems. However, for some reason, Preview could
not open my reports generated from SQLRS. I was able to use the
Finder, Get Info feature on the Mac to tell the OS to open PDF files
with Adobe Reader 6.0 instead of Preview. So, I can now provide a
solution for reports, including a document map(Bookmarks in a PDF), on
the Mac.
I would still prefer to use HTML, which is faster, and does not
require a 2nd window to open.
eppingerr@.software-answers.com (Randy Eppinger) wrote in message news:<abcba2fa.0407160715.65406a3d@.posting.google.com>...
> I have seen other posts which indicate issues with the document map
> and issues with reporting output in general on the Mac. However, I
> haven't seen that anyone is having the specific problem I am having.
> I have a report which uses a document map. It works perfectly in IE
> 6.0 on a PC when rendered as HTML or PDF. The report displays as HTML
> (but not PDF) on the Mac in both IE and Safari, however the document
> map does not display. This functionality is crucial for me. My main
> concern for this particular client is making this document map work
> with IE on the Mac whether that be in HTML or PDF. I should note
> that, long term, I expect to see reports work in both browsers on the
> Mac.
> So my question is specifically:
> Has anyone succeeded in displaying the document map in a report
> rendered as HTML or PDF in IE on a Macintosh running OS 9 or OS 10,
> latest release of IE.|||The document map is only supported on IE 5.5 and higher on Windows.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Randy Eppinger" <eppingerr@.software-answers.com> wrote in message
news:abcba2fa.0407200502.524abb87@.posting.google.com...
> I have more information which I am sharing with anyone else who is
> having this problem. The HTML output seems to use an IFrame. The
> IFrame is supported in IE 5.2.3 for the Mac and it is also supported
> in Safari. So, I still don't know why the document map doesn't show
> up in HTML.
> However, the PDF problem was with the Preview application in the Mac.
> By default, PDF files are opened by Preview, even when they are opened
> from a web page. I have opened other PDF 1.3 files from the web with
> Preview without any problems. However, for some reason, Preview could
> not open my reports generated from SQLRS. I was able to use the
> Finder, Get Info feature on the Mac to tell the OS to open PDF files
> with Adobe Reader 6.0 instead of Preview. So, I can now provide a
> solution for reports, including a document map(Bookmarks in a PDF), on
> the Mac.
> I would still prefer to use HTML, which is faster, and does not
> require a 2nd window to open.
>
> eppingerr@.software-answers.com (Randy Eppinger) wrote in message
news:<abcba2fa.0407160715.65406a3d@.posting.google.com>...
> > I have seen other posts which indicate issues with the document map
> > and issues with reporting output in general on the Mac. However, I
> > haven't seen that anyone is having the specific problem I am having.
> >
> > I have a report which uses a document map. It works perfectly in IE
> > 6.0 on a PC when rendered as HTML or PDF. The report displays as HTML
> > (but not PDF) on the Mac in both IE and Safari, however the document
> > map does not display. This functionality is crucial for me. My main
> > concern for this particular client is making this document map work
> > with IE on the Mac whether that be in HTML or PDF. I should note
> > that, long term, I expect to see reports work in both browsers on the
> > Mac.
> >
> > So my question is specifically:
> > Has anyone succeeded in displaying the document map in a report
> > rendered as HTML or PDF in IE on a Macintosh running OS 9 or OS 10,
> > latest release of IE.

Document Map Not Showing

I have a aspx page with a ReportViewer but when I run the report
through the aspx page the document map doesn't appear.
However if I run it through the sql reporting services interface it
appears.
Any Ideas?DodgeMagnumGuy wrote:
> I have a aspx page with a ReportViewer but when I run the report
> through the aspx page the document map doesn't appear.
> However if I run it through the sql reporting services interface it
> appears.
> Any Ideas?
try adding this to your URL:
&rc:Toolbar=True&rc:DocMap=true&rc:Area=Toolbar
Rick

document map not fully displayed

when i work with a report in visual studio with a document map, it displays
all members in the report on the map.
when the report is deployed to report server, it has the document map but
only displays the top 20 or so (first visible page) members and i can't
scroll down past the top 20.
i've witnessed this on various reports for both 2000 and 2005, is this a
bug? or is there some setting some where?
thanks,
burkeI have experienced the same problem. Please post any resolution you find.|||known issues that will be fixed in reporting server 2005 SP2?
"Treviathon" <Treviathon@.discussions.microsoft.com> wrote in message
news:3F69734F-565A-4EAC-8FDD-C2958C8535B3@.microsoft.com...
>I know there are some issues with the document map and IE7.
> "Shawn" wrote:
>> I have experienced the same problem. Please post any resolution you
>> find.

Document Map not displaying for some users.

I have noticed that with some users the document map pane is empty,
whereas on my machine and others it displays as it should. Has anyone
seen this behavior before and how do you think I could resolve this?Ok, I figured it out.
With reporting services 2000, the document maps do not appear
correctly with users running IE7. There is a hotfix you can download
from Microsoft's site to resolve this.
On Apr 10, 10:08=A0am, Just Another Reporter <Crystal.War...@.gmail.com>
wrote:
> I have noticed that with some users the document map pane is empty,
> whereas on my machine and others it displays as it should. =A0Has anyone
> seen this behavior before and how do you think I could resolve this?

Document Map not appearing in Web Application

I have designed a report and everything is fine except when I view it in my vb.net application. When I view the report through the normal Reporting Services portal my document map appears fine without issue. However when I run it through my application the document map does not appear and the button is not available.

Here is the setup

I have a sql table that stores

* ReportID
* Title
* Keywords
* Serverpath

I then have an aspx page that simply has the webform report viewer with the following code. So I have a data grid populated from the reportinfo table with a Link on each title that passes the ServerPath to the reportviewer page. The URL that is genereated after I recently added the commands to the end of my report path through suggestion of another forum and that still didn't resolve the issue. Anyone out there have any suggestions on how to get the document map to show in the reportviewer webform?

The only thing I can think of is it has 3 parameters is there something special I am missing?

URL Genereated

http://perfectassistant.director-software.com/adminpages/reports/reportviewer.aspx?Path=/PAData/Student%20Information/Member%20Ensemble%20Listing%20Report&rc:Toolbar=True&rc:DocMap=true&rc:Area=Report

Page Load Code

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

Dim rptPath As String

rptPath = Request("Path")

Dim rs As New ReportingService

ReportViewer1.ServerReport.ReportServerCredentials = New ReportViewerCredentials("USERNAME", "PASSWORD", "")

ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://SERVERNAME.com/reportserver")

ReportViewer1.AsyncRendering = False

ReportViewer1.ShowDocumentMapButton = True

ReportViewer1.DocumentMapCollapsed = False

ReportViewer1.ServerReport.ReportPath = rptPath

End If

End Sub

Document Maps don't show when you have the HTML viewer control set to AsyncRendering=false.

See this article for an explanation why (it has to do with the fact that we don't use frames):

http://msdn2.microsoft.com/en-us/library/ms252090.aspx

Document Map Label

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.

Regards

JohnJames

Hi Chaps

I have resolved the issue.
Searched and removed <Label> Tags from XML Definition.

It's blindingly obvious when you know the solution.

Regards

JohnJames

Document map icon disappears!

Has anyone experienced this? One of our users cannot see the Document Map
icon on any report he views.
Clearly this is an issue with his browser or O/S or how his system is
configured, as everyone else can see the icon (and the map!).
Any pointers to what might be causing this greatly appreciated.
ThanksIt would appear to be the browser version. Upgraded to v6 of IE and problem
solved! :)
"Hyper" wrote:
> Has anyone experienced this? One of our users cannot see the Document Map
> icon on any report he views.
> Clearly this is an issue with his browser or O/S or how his system is
> configured, as everyone else can see the icon (and the map!).
> Any pointers to what might be causing this greatly appreciated.
> Thanks

Document Map Formatting

Does 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.

I'm not sure what you mean by "Document Map". Are you just asking how to set the background color of a report?

On the layout tab, right click the background grid (body) of the report. Click properties then change the background color in the properties window.

|||If you edit the properties of a table or a matrix group you have options for Document map label and Parent Group. These attributes draw the Document Map dynamically. At runtime the map is a plain black font on white background and it does not take on the properties of the report body.|||I'm not sure you can Ben, the style is controlled by a style sheet:

Code Snippet

style sheet:<link href="/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&amp;Version=2005.090.3042.00" rel="stylesheet" type="text/css" />

|||Can you change the stylesheet?|||

I found a blog that demonstrates how to override the CSS at runtime.

http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx

Document Map format

Is is possible to format the text of a field used in Document Map. I'm using
a date field and can format the field on the report, but not in the Document
Map. I couldn't find any expression function that can format a data value.Try the Format function: =Format(Fields!MyDate.Value,"d")
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Elmer Miller" <millere@.empireco.nospam> wrote in message
news:ewP5tzcZEHA.3228@.TK2MSFTNGP12.phx.gbl...
> Is is possible to format the text of a field used in Document Map. I'm
using
> a date field and can format the field on the report, but not in the
Document
> Map. I couldn't find any expression function that can format a data value.
>

Document Map for Excel

I've created a document map which displays a text string as the bookmark label (Document map label) when exporting to PDF (e.g. "January 2004", "March 2004"). However, when exporting to Excel, the tabs are named "Sheet1", "Sheet2", etc.

Is it possible to configure a report such that the tab names when exported to excel match the labels used in PDF?Excel worksheets (tabs) are a completely different concept than PDF bookmarks.
Excel worksheets are created based on the pages in the report. Support for providing specific names for Excel worksheets (i.e. report sections) is under consideration for a future release.
-- Robert

Document Map doesnt display in IE7

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

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=971203&SiteID=1.

Document Map customization options

Hello,
I wanted to customize the document map to remove the report name from the
top of the tree. Anyone know how to do that?
I also wanted to add links to other reports. Is this possible? If so how do
I interface with the doc map?
Thanks,
Patrick
--
Message posted via http://www.sqlmonster.comSo nobody knows...?
--
Message posted via http://www.sqlmonster.com|||Sorry, but the document map does not support what you are trying to do.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick P via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:4FE4D6747B080@.SQLMonster.com...
> So nobody knows...?
> --
> Message posted via http://www.sqlmonster.com

Document Map Bug

I am findng that when I add a document map and then later remove it that it
is still appearing in my reports...Is the report still in session? When you make a change to remove the
document map, I take it that you are re-deploying the report? Try closing
all the browser windows and then open a new browser window and view the
report. - Does the document map still appear?
I think the design descision was taken that once you render the report that
you are woking with a copy of the report in that browser session - and that
then allows changes to occur to the underlying report RDL - without it
affecting your session...
Peter Blackburn
Author: Hitchhiker's Guide to SQL Server 2000 Reporting Services
http://www.sqlreportingservices.net
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:AA230BE3-8D85-44C3-9E04-05F7A1873FE8@.microsoft.com...
>I am findng that when I add a document map and then later remove it that it
> is still appearing in my reports...