Changing the ReportViewer control size.

I have an aspx page that uses the ReportViewer control. The dimensions are
set at runtime.
private void Page_Load(object sender, System.EventArgs e)
{
reportViewer.ServerUrl = "http://localhost/reportserver";
reportViewer.ReportPath = "/Samples/Company Sales";
reportViewer.Width = 900;
reportViewer.Height = 580;
}
Is it possible to change the size of the control everytime the browser
window is resized?
TIA.You can set the size to a percent.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:OqzqmWrEFHA.2572@.tk2msftngp13.phx.gbl...
>I have an aspx page that uses the ReportViewer control. The dimensions are
>set at runtime.
> private void Page_Load(object sender, System.EventArgs e)
> {
> reportViewer.ServerUrl = "http://localhost/reportserver";
> reportViewer.ReportPath = "/Samples/Company Sales";
> reportViewer.Width = 900;
> reportViewer.Height = 580;
> }
> Is it possible to change the size of the control everytime the browser
> window is resized?
> TIA.
>|||Thank you.
This worked, but first I had to modify the ReportViewer.dll since, by
default, it doesn't accept precentage for dimensions.
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:ekIm4R5EFHA.3200@.TK2MSFTNGP10.phx.gbl...
> You can set the size to a percent.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
> news:OqzqmWrEFHA.2572@.tk2msftngp13.phx.gbl...
>>I have an aspx page that uses the ReportViewer control. The dimensions
>>are set at runtime.
>> private void Page_Load(object sender, System.EventArgs e)
>> {
>> reportViewer.ServerUrl = "http://localhost/reportserver";
>> reportViewer.ReportPath = "/Samples/Company Sales";
>> reportViewer.Width = 900;
>> reportViewer.Height = 580;
>> }
>> Is it possible to change the size of the control everytime the browser
>> window is resized?
>> TIA.
>|||Great, I'm glad you got it working. Sometimes I forget all the steps when I
did something, but just remember that it works!!
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:eoca6W5EFHA.2600@.TK2MSFTNGP09.phx.gbl...
> Thank you.
> This worked, but first I had to modify the ReportViewer.dll since, by
> default, it doesn't accept precentage for dimensions.
>
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:ekIm4R5EFHA.3200@.TK2MSFTNGP10.phx.gbl...
>> You can set the size to a percent.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
>> news:OqzqmWrEFHA.2572@.tk2msftngp13.phx.gbl...
>>I have an aspx page that uses the ReportViewer control. The dimensions
>>are set at runtime.
>> private void Page_Load(object sender, System.EventArgs e)
>> {
>> reportViewer.ServerUrl = "http://localhost/reportserver";
>> reportViewer.ReportPath = "/Samples/Company Sales";
>> reportViewer.Width = 900;
>> reportViewer.Height = 580;
>> }
>> Is it possible to change the size of the control everytime the browser
>> window is resized?
>> TIA.
>>
>

changing the label of the boolean parameter

I'm creating a boolean parameter in Report Designer and set .
Then on Preview Page I see to radio buttons, the first one is labeled
"true" and the other one is "false".? Can I set the labels I want to this
radio buttons?It is not possible to manipulate the boolean true/false labels.
Andy Potter|||Thanks Potter, And what about radio button or checkbox there is a way to put
it in the reporting server as afilter?
"Potter" wrote:
> It is not possible to manipulate the boolean true/false labels.
> Andy Potter
>|||When using the built in parameter selection, the "control type" of the
parameter (which I assume you mean by filter) is determined by the
datatype.
If you need more flexibility, you have to look at creating your own
parameter selection screen and calling the report via URL access or the
web service.
Andy Potter

changing the internet port number of MS RS Server

I tried to change the MS RS Server port from 80 to let's say 8080. But when
going back to MS RS home page I have an error page from MS RS with the
following message :
"The underlying connection was closed: Unable to connect to the remote
server."
I can't solve this
Could anybody help me.
Regards,
PS: OS is Win2K all Windows Updates, and IIS5Make sure to update the url in RSWebapplication.config to use the new port.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"jcredk" <jcredk@.discussions.microsoft.com> wrote in message
news:2F53430B-20F3-4BB4-A51F-2E60F5074592@.microsoft.com...
> I tried to change the MS RS Server port from 80 to let's say 8080. But
when
> going back to MS RS home page I have an error page from MS RS with the
> following message :
> "The underlying connection was closed: Unable to connect to the remote
> server."
> I can't solve this
> Could anybody help me.
> Regards,
> PS: OS is Win2K all Windows Updates, and IIS5
>|||Hi,
Thanks a lot that was the key I was searching.
Quick test has worked. I was accessing the homepage for reports ..!
"Daniel Reib [MSFT]" wrote:
> Make sure to update the url in RSWebapplication.config to use the new port.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jcredk" <jcredk@.discussions.microsoft.com> wrote in message
> news:2F53430B-20F3-4BB4-A51F-2E60F5074592@.microsoft.com...
> > I tried to change the MS RS Server port from 80 to let's say 8080. But
> when
> > going back to MS RS home page I have an error page from MS RS with the
> > following message :
> > "The underlying connection was closed: Unable to connect to the remote
> > server."
> >
> > I can't solve this
> >
> > Could anybody help me.
> >
> > Regards,
> >
> > PS: OS is Win2K all Windows Updates, and IIS5
> >
>
>|||I try this,
but now i have a blank default page, with no poosibility ton configure
anything,
i have just Home, My subscription, help menu
no menu to add directory or ton configure security.
I have forgotten something ?
Thanks.
Bruno
"jcredk" wrote:
> Hi,
> Thanks a lot that was the key I was searching.
> Quick test has worked. I was accessing the homepage for reports ..!
> "Daniel Reib [MSFT]" wrote:
> > Make sure to update the url in RSWebapplication.config to use the new port.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "jcredk" <jcredk@.discussions.microsoft.com> wrote in message
> > news:2F53430B-20F3-4BB4-A51F-2E60F5074592@.microsoft.com...
> > > I tried to change the MS RS Server port from 80 to let's say 8080. But
> > when
> > > going back to MS RS home page I have an error page from MS RS with the
> > > following message :
> > > "The underlying connection was closed: Unable to connect to the remote
> > > server."
> > >
> > > I can't solve this
> > >
> > > Could anybody help me.
> > >
> > > Regards,
> > >
> > > PS: OS is Win2K all Windows Updates, and IIS5
> > >
> >
> >
> >|||Did you try to reset iis using command IISReset ?
Most of the times simply restarting IIS does not force IIS to read/reflect
registry or config changes.
I had same problem on CRM server using SRS after changing some of IIS
configuration, this trick resolved it.
"jcredk" wrote:
> I tried to change the MS RS Server port from 80 to let's say 8080. But when
> going back to MS RS home page I have an error page from MS RS with the
> following message :
> "The underlying connection was closed: Unable to connect to the remote
> server."
> I can't solve this
> Could anybody help me.
> Regards,
> PS: OS is Win2K all Windows Updates, and IIS5
>sql

Changing Parameter in SQLDataSource for Multiple DropDowns

I have one page, one connection, and three dropdowns.
The connection looks like (as an example):

<asp:SqlDataSource ID="DropDownConn" runat="server" ConnectionString="<%$ ConnectionStrings:aousConnectionString %>"
SelectCommand="SELECT [Value], [Text] FROM [DropDown] WHERE (([Group] = @.Group) AND ([Viewable] = @.Viewable))">
<SelectParameters>
<asp:Parameter Name="Group" Type="String" />
<asp:Parameter DefaultValue="True" Name="Viewable" Type="Boolean" />
</SelectParameters>
</asp:SqlDataSource>

The DropDowns Look like this:

<asp:DropDownList ID="DropDown1" runat="server"></asp:DropDownList>
<asp:DropDownList ID="DropDown2" runat="server"></asp:DropDownList>
<asp:DropDownList ID="DropDown3" runat="server"></asp:DropDownList
The C# Code I am trying is like this:
DropDownConn.SelectParameters["Group"].Equals("DropDown1");
DropDownConn.SelectParameters["Viewable"].Equals(true);
DropDown1.DataSourceID = "DropDownConn";
DropDown1.DataTextField = "Text";
DropDown1.DataValueField = "Value";
DropDown1.DataBind();

As an example. I can not get it done so that I don't have to create 3 dataconnections. Any help, PLEASE?

It should be done this way..

DropDownConn.SelectParameters["Group"].DefaultValue = "some group value"; // change it accordingly on what data should be displayed in the dropdownlists
DropDownConn.SelectParameters["Viewable"].DefaultValue = "True";

DropDown1.DataSource = DropDownConn;
DropDown1.DataTextField = "Text";
DropDown1.DataValueField = "Value";
DropDown1.DataBind();

// for second

DropDownConn.SelectParameters["Group"].DefaultValue = "some group value for second dropdown"; // change it accordingly on what data should be displayed in the dropdownlists
DropDownConn.SelectParameters["Viewable"].DefaultValue = "True";

DropDown2.DataSource = DropDownConn;
DropDown2.DataTextField = "Text";
DropDown2.DataValueField = "Value";
DropDown2.DataBind();

-----

You can also, refactor the code to set the datasource for the dropdownlist.

Thanks

-Mark post(s) as "Answer" that helped you

|||

Thank you for the answer, and that method does work. Is that really the way we are suppose to do it. The default value is such a poor naming scheme and Microsoft had done such a good job with most other things. Thanks for the the help.

Changing PageHeight dynamically

My requirement is to have my report display on one 11 by 8.5 page. Is there a way to programmatically change the PageHeight report property based on the number of rows returned in a table? i.e., if the rowcount for table x >= 10, change PageHeight to 9.5.

Any ideas?

Thanks.

Brad

Is there anyway to achieve this?|||

Not really but you can use the next size or change the orientation of your report but before you do that run test copies through either preview or Reportveiwer depending of your choice for display and printing. Here is what I know there is an interactive height setting which you can use to reduce the size so maybe you can use it to increase it. Try the link below for details.

http://blogs.msdn.com/bwelcker/archive/2005/08/19/Alien-Lanes-_2800_Logical-and-Physical-Pagination-Rules_2900_.aspx

Changing Page Orientation for Sub Reports

We have a "Master" report that contains several sub-reports. Some of these
sub-reports we need to print in landscape orientation. We have been unable
to figure out how to set the page orientation for sub-reports. We also
looked to see if we could create "sections" (like MS Word) where we could
configure page breaks and page orientation.
Can anyone point us in the right direction?
Thanks,
ChrisUnfortunately, this is not supported in the current release. Other than some
sort of wrapper that chains together multiple reports, I can't think of how
you would do this.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Christopher Walls" <msnews@.travantsolutions.com> wrote in message
news:OtQ6K1meEHA.3984@.TK2MSFTNGP10.phx.gbl...
> We have a "Master" report that contains several sub-reports. Some of
> these
> sub-reports we need to print in landscape orientation. We have been unable
> to figure out how to set the page orientation for sub-reports. We also
> looked to see if we could create "sections" (like MS Word) where we could
> configure page breaks and page orientation.
> Can anyone point us in the right direction?
> Thanks,
> Chris
>

Changing Header based on subreport

Hi,
How can I change the contents of a container reports page header based on
the subreport that is being rendered?
Thanks,
JohnNever mind. Did workaround by putting each subreport in separate table with
separate table header and page break after table checked. originally had
each subreport in separate header lines in a single table.
Thanks,
John
"John" wrote:
> Hi,
> How can I change the contents of a container reports page header based on
> the subreport that is being rendered?
> Thanks,
> John