Showing posts with label window. Show all posts
Showing posts with label window. Show all posts

Wednesday, March 28, 2012

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.

Monday, February 27, 2012

help: SQL report (2000) and window form(VS2003)

hi Gummy
I have one problem. I don't know how to embed a SQL report (2000) onto
window form(VS2003), I do some research, a lot of information is
VS2005. I think you are done before.
Can you give me some information or sample code.
I really need you help.
Thanks so much.
-AlberYour best choice for this is to use URL integration. Embed a IE browser
control, then create the appropriate URL for the reports you want to show. I
have done this and it works well.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<lgxdo@.yahoo.com> wrote in message
news:1175188629.964581.98010@.y66g2000hsf.googlegroups.com...
> hi Gummy
> I have one problem. I don't know how to embed a SQL report (2000) onto
> window form(VS2003), I do some research, a lot of information is
> VS2005. I think you are done before.
> Can you give me some information or sample code.
> I really need you help.
> Thanks so much.
> -Alber
>|||Dear Bruce,
Thanks so much. Can you give me a simple code? I create a form and add
a button to the form. And :
-->
private AxSHDocVw.AxWebBrowser axWebBrowser1;
private void button1_Click_1(object sender, System.EventArgs e)
{
object o="";
axWebBrowser1.Navigate("http://gp-ecomm/reportserver/misc/
bbitems",ref o, ref o, ref o,ref o);
}
-->
debug Error:
An unhandled exception of type 'InvalidActiveXStateException' occurred
in axinterop.shdocvw.dll
I am no idea about this.:(
Can you fix it'
Thanks so much.
Alber|||What I have always done is embed an Web browser control in a form. That
isn't what you are doing in the supplied code below.
Also I suggest trying a URL in IE and make sure it works and just copy and
paste into your code and use that for a test.
Indeed, you can start off with showing any website first. If you google you
can find VB code that does this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<lgxdo@.yahoo.com> wrote in message
news:1175376498.129336.290910@.y66g2000hsf.googlegroups.com...
>
> Dear Bruce,
> Thanks so much. Can you give me a simple code? I create a form and add
> a button to the form. And :
> -->
> private AxSHDocVw.AxWebBrowser axWebBrowser1;
> private void button1_Click_1(object sender, System.EventArgs e)
> {
> object o="";
> axWebBrowser1.Navigate("http://gp-ecomm/reportserver/misc/
> bbitems",ref o, ref o, ref o,ref o);
> }
> -->
> debug Error:
> An unhandled exception of type 'InvalidActiveXStateException' occurred
> in axinterop.shdocvw.dll
> I am no idea about this.:(
> Can you fix it'
> Thanks so much.
> Alber
>

Sunday, February 19, 2012

help: a problem to add a login in sql server

Hello,
I am trying to add a login for a Window NT user
in the SQL server but getting following error messages
Error 15401: Windows NT user or group '%s' not found.
Check the name again.
I have checked all the setting in the domain and could not
find anything wrong.
Plese some one can tell me what should I do to fix it.
Thanks
KarenHave had similar problem. Three times in one year. Some advice I've
received was check PDC & BDC sync, verify upper & lower case, but what
seemed to work for me was to reboot the server. I know this is sometimes
unacceptable, but sometimes it works.
You can do a google search also.
Bill
"Karen" <kchen@.grainscanada.gc.ca> wrote in message
news:086101c35c61$64eea390$a101280a@.phx.gbl...
> Hello,
> I am trying to add a login for a Window NT user
> in the SQL server but getting following error messages
> Error 15401: Windows NT user or group '%s' not found.
> Check the name again.
> I have checked all the setting in the domain and could not
> find anything wrong.
> Plese some one can tell me what should I do to fix it.
> Thanks
> Karen