Hide Dcoument Map by Default while viewing the Report in SSRS

Hello Experts

I use a Report where i have a document Map getting generated. but by default it is displayed and the user has to close the window to view the report. i wanted to know if its possible to hide the Document map window by default and based on the click of the icon the window will be show to the user when viewing in the default Report page.

/chandresh soni

Did you already try the URL access parameter: rc:DocMap=false ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens

Thanks for your suggestion. but i cannot expect my user to type rc:DocMap=false in the URL. as i deploy the report on the Report server and the user view the same through Report Manager.

since the Report has a document map, it covers 25 % of the main screen. so i wanted a way that by default it should be hidden and only on the click of the icon in the Toolbar it should be visible.

i appreciate if you can help me find the solution

/Soni

|||

I have the same problem

Soni-- Did you get the solution?

|||

Another 'poor sool' experiencing this 'feature(?)'.

Any solutions yet ?

|||

I created a report with Document Map on (from Matrix Textbox Properties | Navigation tab) and the same report without Document Map. Saved both and searched for differences in the resulting rdl files. This helped me to find the problem in my original report. Removing the Label element in the Grouping part of the Matrix element removed also the Document Map icon from my reports.This is an extract of the changed rdl file.

Before:

<Grouping Name="PersonGroup">
<Label>=Fields!Person.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!Person.Value</GroupExpression>
</GroupExpressions>
</Grouping>

After:

<Grouping Name="PersonGroup">
<GroupExpressions>
<GroupExpression>=Fields!Person.Value</GroupExpression>
</GroupExpressions>
</Grouping>

This must be some bug wit the Layout-UI not synchronizing with the rdl file, because the Document Map label was definitily NOT set in the Navigation tab of the report that opened with Document Map default on.

sql

Hide Dcoument Map by Default while viewing the Report in SSRS

Hello Experts

I use a Report where i have a document Map getting generated. but by default it is displayed and the user has to close the window to view the report. i wanted to know if its possible to hide the Document map window by default and based on the click of the icon the window will be show to the user when viewing in the default Report page.

/chandresh soni

Did you already try the URL access parameter: rc:DocMap=false ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens

Thanks for your suggestion. but i cannot expect my user to type rc:DocMap=false in the URL. as i deploy the report on the Report server and the user view the same through Report Manager.

since the Report has a document map, it covers 25 % of the main screen. so i wanted a way that by default it should be hidden and only on the click of the icon in the Toolbar it should be visible.

i appreciate if you can help me find the solution

/Soni

|||

I have the same problem

Soni-- Did you get the solution?

|||

Another 'poor sool' experiencing this 'feature(?)'.

Any solutions yet ?

|||

I created a report with Document Map on (from Matrix Textbox Properties | Navigation tab) and the same report without Document Map. Saved both and searched for differences in the resulting rdl files. This helped me to find the problem in my original report. Removing the Label element in the Grouping part of the Matrix element removed also the Document Map icon from my reports.This is an extract of the changed rdl file.

Before:

<Grouping Name="PersonGroup">
<Label>=Fields!Person.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!Person.Value</GroupExpression>
</GroupExpressions>
</Grouping>

After:

<Grouping Name="PersonGroup">
<GroupExpressions>
<GroupExpression>=Fields!Person.Value</GroupExpression>
</GroupExpressions>
</Grouping>

This must be some bug wit the Layout-UI not synchronizing with the rdl file, because the Document Map label was definitily NOT set in the Navigation tab of the report that opened with Document Map default on.

Hidden Values are not calculated in SSRS 2005?!

Hi,
I just created a Report in SSRS 2005 and wanted to use the "old" trick to
display data values in the header (reference body-elements from the header).
I know this worked fine in SSRS 2000, but in SSRS 2005 it seems, that they
have build in some "optimization" which doesn't render/calculate hidden
Fields anymore.
So, when I reference a Field that isn't hidden it works just fine - but as
soon as I hide the referenced field in the body it never gets a value, thus
the textbox in the header stays empty as well.
Initially I referenced Textboxes embedded in a table, but it neither works
for texboxes which are directly contained in the body-region. As soon as an
element is hidden it seems to be ignored by the rendering engine.
Any help would be appreciated.
Thanks,
FlorianA suitable workaround would be to set the font color to the same color as
the background color.
-Tim
"Florian" <Florian@.discussions.microsoft.com> wrote in message
news:AB31608E-EFF9-4D0B-865C-956519A96859@.microsoft.com...
> Hi,
> I just created a Report in SSRS 2005 and wanted to use the "old" trick to
> display data values in the header (reference body-elements from the
> header).
> I know this worked fine in SSRS 2000, but in SSRS 2005 it seems, that they
> have build in some "optimization" which doesn't render/calculate hidden
> Fields anymore.
> So, when I reference a Field that isn't hidden it works just fine - but as
> soon as I hide the referenced field in the body it never gets a value,
> thus
> the textbox in the header stays empty as well.
> Initially I referenced Textboxes embedded in a table, but it neither works
> for texboxes which are directly contained in the body-region. As soon as
> an
> element is hidden it seems to be ignored by the rendering engine.
> Any help would be appreciated.
> Thanks,
> Florian

hidden ReportParameter where is it?

I'm coding up a WinForm using SSRS WebServices, and I have found I can't see a Hidden property for the ReportParameter

Anyone know how to read if a Parameter is hidden?

You can know that whether the report parameter is hidden or not by using the below code snippets.

Dim pAs Microsoft.Reporting.WebForms.ReportParameterInfoFor Each pIn ReportViewer1.ServerReport.GetParametersIf p.Visible =False Then'Parameter is hiddenEnd IfNext

|||

Thanks for the reply, but I'm having a little difficulity understanding why this is not available from Reporting Services Web Service.

I am looking up the details from reportservice.asmx WebService, and returning the information back to a List:

CatalogItem[] items =this.objRS.ListChildren(currentFolder,false);

(Sorry it's in C#)

Where objRS is the RS WebServices.

Then I use

reportParametersArray =this.objRS.GetReportParameters(report, historyID, forRendering,null,null);

foreach (ReportParameter pin reportParametersArray)

{

p.Visible; // This odes not exist :-(

}

However Visible is not available using it in this way :-(

Why is it different, and what am I missing?

|||

Hi,

You can get the visibility by adding a condition to the code you have written. Please find the code below. I hope this would help.

--

reportParametersArray =this.objRS.GetReportParameters(report, historyID, forRendering,null,null);
foreach (ReportParameter pin reportParametersArray)
{
if (p.Prompt =="") {
//Parameter is hidden }}

--

|||

Perfect, thanks.

Why oh why the name change from Visible to Prompt?

|||

It's something like a flag used for an internal manipulation.

HELP: Alternates from a Subreport?

Hello, I'm sorta new to SSRS and had a question hopefully someone can answer. Right now I'm using a stored procedure in oracle to pass the first set of data to my report. My report is fairly simple in that it is a header a detail row and a footer for totals. There isnt any grouping or sorting of data, it just displays basically exactly what the stored procedure passes it. It's a list of customers and their information. Here is the tricky part where I am having trouble.

One of the columns is for Social Security Numbers(SSNs) and the stored procedure doesnt send the SSN. The SSN is passed from another query that is dependent on the customers ID number. So, as of right now in the details section under the SSN column I put a subreport for the SSNs. Also, some customers have more than one SSN so the subreport creates more rows according to the how many it needs to display all the SSNs. I like this because it doesnt repeat all the customers information for every SSN they have.

But where I work they dont want to have multiple files for every report and just want to keep 1 report with 1 report file. So, how can I accomplish this exact same report without using a subreport?

Hope someone can help me and thanks ahead of time.

-Evan

I put the same post on MSDN forums and this is what the solution was:

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