Showing posts with label below. Show all posts
Showing posts with label below. Show all posts

Monday, March 26, 2012

ReportView renders reports weird...?

I'm using a ReportViewer control to render reports on my page. It does render the reports, but ever report scrolls below the iframe that it creates. It's difficult to explain, but basically, you can't scroll to the bottom of the report. That data is below the iframe's bottom border. The iframe is not mine, it's created by ResportViewer. I have a screenshot to illustratehere (http://www.appell.com/imges/srsscontrol.gif)

Here's my code (it's using a MasterPage):

<asp:Content ContentPlaceHolderID="cph_MainContent" runat="server" ID="cntDefault"> Choose from the available reports:   <asp:DropDownList ID="ddlReports" runat="server" OnSelectedIndexChanged="ShowReport" AutoPostBack="true"> <asp:ListItem Value="">Select a report</asp:ListItem> </asp:DropDownList> <div style="margin:8px 0px 0px 0px;clear:both;"> <rsweb:ReportViewer ID="reportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="600px" AsyncRendering="true" ProcessingMode="Remote" ShowToolBar="True" Width="700px"> <ServerReport ReportPath="" ReportServerUrl="http://sqlwebreports/ReportServ" DisplayName="report" Timeout="1000" /> </rsweb:ReportViewer> </div></asp:Content>

Any idea what's going wrong here? BTW, I have tried changing the InteractiveSize and it doesn't matter how short I make the report, it still scrolls below the bottom...

Thanks for the help!

Eddie

Take out the div tags. If you have it in a table tags, take those out. I had the same problem. The report was in a panel that was in a table. Took out the table tags and the report rendered fine.|||Thanks, but I tried that and I get the same exact result. This code:
<asp:Content ContentPlaceHolderID="cph_MainContent" runat="server" ID="cntDefault"> Choose from the available reports:   <asp:DropDownList ID="ddlReports" runat="server" OnSelectedIndexChanged="ShowReport" AutoPostBack="true"> <asp:ListItem Value="">Select a report</asp:ListItem> </asp:DropDownList> <rsweb:ReportViewer ID="reportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="600px" AsyncRendering="true" ProcessingMode="Remote" ShowToolBar="True" Width="700px"> <ServerReport ReportPath="" ReportServerUrl="http://sqlwebreports/ReportServ" DisplayName="report" Timeout="1000" /> </rsweb:ReportViewer></asp:Content>

Renders exactly the same as the other code - the report still scrolls out of sight...

Thanks for the reply!

eddie

|||If you haven't done this yet, take out the content place holder tags and just put the viewer in a panel. Also, ssl can give the viewer trouble|||

Yeah, turns out the control just can't be used with a MasterPage. I tried everything, and the only way I could get it to work was to take it out of a ContentPlaceHolder, which is required if using a MasterPage. So I just converted this page to a standard webform and it works fine. Too bad though...

Eddie

|||

Also, you can check what settings are there for "Style" of the Report Viewer. You can acccess the styling of the ReportViewer as follows:

1) Design View

2) Right click on the ReportViewer and you will see the Style tab in the popup. Click that.

3) Go to Layout section. There should be a "Content" section. For Overflow, choose "Use Scrollbars if needed".

I believe this should solve the problem.

Good luck...

bullpit

ReportService2005.asmx error

Hi,

I am getting below error message while uploading reports using RS.EXE command or MS Management Studio. There is no problem if I use IE and connect to https://localhost/Reports and then upload the .rdl file.

Could not connect to server: https://localhost/ReportServer/ReportService2005.asmx

Any idea what is the problem? I have SecureConnectionLevel=2 and UrlRoot as https://FQDN_SERVERNAME/reportserver in rsreportserver.config file. FQDN_SERVERNAME matches exactly with my web site certificate name.

Thanks

I had issues with the web service when I used localhost also, when I used the server name my problems went away. I don't think I got a could not connect to server error though.

-Somsong

Monday, March 12, 2012

Reports broke from remote

Hello
Recently this one report errors as below when running on any machine except
the actual server hosting the
reporting services.
a.. An error has occurred during report processing.
a.. Cannot create a connection to data source 'databasename.
a.. For more information about this error navigate to the report
server on the local server machine, or enable remote errors
They did recently change the name of the machine hosting the datasource, but
it shows up OK
in RS config manager.
Anything else I could look at?
Regards
CTCheck out the credentials for the report datasource. I always use shared
datasources but perhaps this report uses a report specific datasource that
has a problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MSNewsGroup" <Cal@.obded.org> wrote in message
news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
> Hello
> Recently this one report errors as below when running on any machine
> except the actual server hosting the
> reporting services.
> a.. An error has occurred during report processing.
> a.. Cannot create a connection to data source 'databasename.
> a.. For more information about this error navigate to the report
> server on the local server machine, or enable remote errors
> They did recently change the name of the machine hosting the datasource,
> but it shows up OK
> in RS config manager.
> Anything else I could look at?
> Regards
> CT
>|||Could that be if it works on the machine hosting RS?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e3Ywj7s0HHA.464@.TK2MSFTNGP02.phx.gbl...
> Check out the credentials for the report datasource. I always use shared
> datasources but perhaps this report uses a report specific datasource that
> has a problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "MSNewsGroup" <Cal@.obded.org> wrote in message
> news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> Recently this one report errors as below when running on any machine
>> except the actual server hosting the
>> reporting services.
>> a.. An error has occurred during report processing.
>> a.. Cannot create a connection to data source 'databasename.
>> a.. For more information about this error navigate to the report
>> server on the local server machine, or enable remote errors
>> They did recently change the name of the machine hosting the datasource,
>> but it shows up OK
>> in RS config manager.
>> Anything else I could look at?
>> Regards
>> CT
>|||It depends on how the credentials are configured. Check and see if it is
using a shared datasource or report datasource. If report datasource compare
how its credentials are setup compared to a report datasource/shared
datasource that works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MSNewsGroup" <Cal@.obded.org> wrote in message
news:%23ag1lpt0HHA.4824@.TK2MSFTNGP02.phx.gbl...
> Could that be if it works on the machine hosting RS?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e3Ywj7s0HHA.464@.TK2MSFTNGP02.phx.gbl...
>> Check out the credentials for the report datasource. I always use shared
>> datasources but perhaps this report uses a report specific datasource
>> that has a problem.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "MSNewsGroup" <Cal@.obded.org> wrote in message
>> news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> Recently this one report errors as below when running on any machine
>> except the actual server hosting the
>> reporting services.
>> a.. An error has occurred during report processing.
>> a.. Cannot create a connection to data source 'databasename.
>> a.. For more information about this error navigate to the report
>> server on the local server machine, or enable remote errors
>> They did recently change the name of the machine hosting the datasource,
>> but it shows up OK
>> in RS config manager.
>> Anything else I could look at?
>> Regards
>> CT
>>
>