ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

|||thanks for pointing me in the right direction. I wrote this to get rid of the duplicate scrollbars in async mode.

<body>

<script language="JavaScript" type="text/JavaScript">

window.onload=function RemoveScrollbars()

{

document.getElementById("<%=ReportViewer1.ClientID %>").lastChild.firstChild.style.overflow = "visible";

}

</script>

<form runat="server" action="Report.aspx" >

<rsweb:ReportViewer

ID="ReportViewer1"

runat="server"

ProcessingMode="Remote"

AsyncRendering="false"

SizeToReportContent="true" />

</form>

</body>

I gleened this navagation from the nifty tree view in the IE Developer Toolbar.

works like a charm!

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<scriptlanguage="JavaScript"type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewerID="ReportViewer1"runat="server"Font-Names="Verdana"Font-Size="8pt"

ProcessingMode="Remote"Width="100%"CssClass="fullheight">

</rsweb:ReportViewer>

|||thanks for pointing me in the right direction. I wrote this to get rid of the duplicate scrollbars in async mode.

<body>

<script language="JavaScript" type="text/JavaScript">

window.onload=function RemoveScrollbars()

{

document.getElementById("<%=ReportViewer1.ClientID %>").lastChild.firstChild.style.overflow = "visible";

}

</script>

<form runat="server" action="Report.aspx" >

<rsweb:ReportViewer

ID="ReportViewer1"

runat="server"

ProcessingMode="Remote"

AsyncRendering="false"

SizeToReportContent="true" />

</form>

</body>

I gleened this navagation from the nifty tree view in the IE Developer Toolbar.

works like a charm!

sql

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer Height

Hello,

I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005.
When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success.
At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports.
Did you have any such problems? Can you help me?

Thank you,Xhtml does not treat percentage height the same way as traditional html. Take a look at www.gotreportviewer.com, FAQ #14.|||I also cannot get SizeToReportContent = True to work on my web form report viewer controls. Is this a bug or are we overlooking something?|||SizeToReportContent has no effect when AsyncRendering = true. If you set AsyncRendering = false, which renders the report contents inline (versus being in an iframe), then SizeToReportContent will work.|||I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.|||

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

|||

korggy wrote:

When I set AsyncRendering=true, I get an error message when the user tries to navigate to the second page of my report: " Page navigation is out of range."

When I set AsyncRendering=false, it works correctly.

I am using a remote report.

I figured out a workaround. See this post.

|||

Would it be possible to post your javascript?

I still get scrollbars even when AsyncRendering=false SizeToReportContent=true

|||

dreadjr wrote:

I wrote some javascript to size the report after it was loaded, using the AsyncRendering = true.

Can you please share that with the rest of us please?

|||

This is the script that I am using. If you resize a window, you then have to refresh the page to resize the viewer, but there is probably a workaround for that, too.

css style

.fullheight{margin-bottom:120px;}

javascript

<script language="JavaScript" type="text/JavaScript">

window.onload=function resize(){

var viewer = document.getElementById("<%=ReportViewer1.ClientID %>");

var htmlheight = document.documentElement.clientHeight;

viewer.style.height = (htmlheight - 120) + "px";

}

</script>

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"

ProcessingMode="Remote" Width="100%" CssClass="fullheight">

</rsweb:ReportViewer>

ReportViewer control questions

I am using report server on SQL2005. I want to embed a ReportViewer control
in an asp.net (1.1) page. I am using Visual Studio .NET. Is this possible,
or do I need to be using Visual Studio 2005?
And, once the ReportViewer control is there, what steps do I need to take in
order for the asp.net process to access report server on a different box in
the same domain? Do I need to add the Network Service account as a user in
report server?
Thanks,
RobHi Rob,
Report viewer comes with VS 2005 so you need to have the .NET 2.0 to use the
report viewer. you cannot use in asp.net 1.1.
for more FAQ see this http://www.gotreportviewer.com/
Let us know how it goes
Thanks
Bava
"Rob" wrote:
> I am using report server on SQL2005. I want to embed a ReportViewer control
> in an asp.net (1.1) page. I am using Visual Studio .NET. Is this possible,
> or do I need to be using Visual Studio 2005?
> And, once the ReportViewer control is there, what steps do I need to take in
> order for the asp.net process to access report server on a different box in
> the same domain? Do I need to add the Network Service account as a user in
> report server?
> Thanks,
> Rob

ReportViewer component - Parameters

Hi,
Can someone show me how to set reportviewer parameters. I am using
visual studio with the reportviewer component provided with reporting
services samples.
I understand that I have to set ServerURL and ReportPath properties,
but do not have a clue how to pass parameters to the reportviewer.
regards,
KSTake a look at http://odetocode.com/Articles/156.aspx.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"saleek" <khurrams@.intelligentmedia.com> wrote in message
news:ca505fb1.0410050324.3b9e32ff@.posting.google.com...
> Hi,
> Can someone show me how to set reportviewer parameters. I am using
> visual studio with the reportviewer component provided with reporting
> services samples.
> I understand that I have to set ServerURL and ReportPath properties,
> but do not have a clue how to pass parameters to the reportviewer.
> regards,
>
> KS

reportviewer blues

Hi,

Just trying to get my had around reportviewer in MS Visual Web Dev 2005. All is well if I do it all with the wizards etc but I want to be able to filter data based on textboxs etc and can't seem to do that without code. So I have started looking at coding it and have the following so far (I realise this will not filter on textbox data but I think I can get there from here if I get it working).

Imports Microsoft.Reporting.WebForms

Imports System.Data

Imports System.Data.SqlClient

PartialClass _Default

Inherits System.Web.UI.Page

ProtectedSub Page_Load(ByVal senderAsObject,ByVal eAs System.EventArgs)HandlesMe.Load

'Set the processing mode for the ReportViewer to Local

ReportViewer1.ProcessingMode = ProcessingMode.Local

Dim repAs LocalReport = ReportViewer1.LocalReport

rep.ReportPath ="SalesReport.rdlc"

Dim dsAs DataSet = GetSalesData()

'Create a report data source for the sales order data

Dim dsSalesOrderAsNew ReportDataSource()

dsSalesOrder.Name ="SalesData_Data"

dsSalesOrder.Value = ds.Tables("SalesData")

rep.DataSources.Add(dsSalesOrder)

EndSub

PrivateFunction GetSalesData()

Dim dsAsNew DataSet

Dim SQLConAsNew SqlConnection("SERVER= .\sqlexpress;Database=Adventureworks; Integrated Security=true;")

Dim commandAsNew SqlCommand("SELECT SalesPersonID, CountryRegionName FROM [AdventureWorks].[Sales].[vSalesPerson] WHERE CountryRegionName = 'Canada'", SQLCon)

Dim salesOrderAdapterAsNew SqlDataAdapter(command)

salesOrderAdapter.Fill(ds,"SalesData")

salesOrderAdapter.Dispose()

command.Dispose()

Return ds

EndFunction

EndClass

_____________________________________________________________________________________________

When I run it I get the following error

A data source instance has not been supplied for the data source 'Salesdata_vSalesPerson'

Any help appriciated

Thanks

Zuma

I can't beleive no one knows the answer to this one. Please help :(|||

Zuma:

When I run it I get the following error

A data source instance has not been supplied for the data source 'Salesdata_vSalesPerson'

modify this line

dsSalesOrder.Name ="SalesData_Data"

to be

dsSalesOrder.Name ="Salesdata_vSalesPerson"

|||

Thanks anooor, that was. I appriciate your time and skill.

ReportViewer - problems with deploying

I have a web application that was written in Visual Studio 2005, ASP.Net. I am using ReportViewer and it runs correctly and quickly in "local" setting. I have installed the ReportViewer.exe from my local machine's harddrive onto the web server and copied my web application to the web server. The aspx page opens fine, I see the reportviewer frame, but I do not see my report. I have tried changing the "ServerReport" and "LocalReport" ReportPath to "http://localhost/test" where the RDLC file is located but still no report shows up on the web server.

Could someone please instruct me how to deploy an ASP.Net web site that is using ReportViewer? I have installed, uninstalled and reinstalled the ReportViewer.exe file. I have downloaded it directly from Microsoft and restarted IIS, as I have seen in other posts. I am running out of options that I can try to get this to work, and I'd hate to have to scrap it and start over using tables and repeaters.

Thanks in advance.

Hi,

From your description, it seems that you want to connect to your report which existed on your remote web server, right?

To deploy reports in an Internet application, you can embed the ReportViewer Web server control in a custom Internet-ready application that you create and deploy. The ReportViewer Web server control is included in Visual Studio 2005 and can be distributed freely with your application. You can configure the control to display reports that run on a report server. The connection between your application and the report server is handled by the control, through the Web service programming interface. All authentication and authorization is handled by your application, which connects to the report server through a single, user-trusted connection.

For more information see:http://technet.microsoft.com/en-us/library/ms159272.aspx
More information on deploying see:http://technet.microsoft.com/en-us/library/ms159868.aspx

Thanks.

sql

Report-Sub Report in Visual Studio 2005

Hi everybody,
I have a problem on connecting subreports with reports.
I create the sub report, bind data to it, and filter the
data (in the query) with something like Case_Id = @.ParamCaseID.
I create the parameter ParamCaseID in the subreport and then I go
to the primary report and set the property parameters of the subreport
to ParamCaseID and value to (=Fields!PrimaryCaseID.Value).
I run the application to see the report and although the report is
showing I get the error "Subreport could not be shown" in the
place where the subreport was supposed to appear.
What am I doing wrong ?
Any help would be useful .
Thanks in advance.
To answer by e-mail remove the "bog" from the e-mail.I use SQL Server 2005 Reporting Services of course.sql

Reports Won't Deploy

I'm stuck, any ideas? Is this a version or sp issue or a connection problem?
SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
All my service and accounts are set up fine, I can manually upload a report
and data source to the report server, but VS 2005 will not deploy when the
web server is set in the TargetServerURL property.
The error I get is
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://phxdb02/Reports.
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
(Microsoft.ReportingServices.Designer)
The request failed with HTTP status 404: Not Found.
(Microsoft.ReportingServices.Designer)You need to specify the ReportServer web service endpoint not the Report
Manager url e.g. in your Project Properties for the TargetServerURL specify
http://phxdb02/ReportServer
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:EDDFC084-0623-4FE2-B742-2AAA52D2E3ED@.microsoft.com...
> I'm stuck, any ideas? Is this a version or sp issue or a connection
> problem?
> SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
> All my service and accounts are set up fine, I can manually upload a
> report
> and data source to the report server, but VS 2005 will not deploy when the
> web server is set in the TargetServerURL property.
> The error I get is
> TITLE: Microsoft Report Designer
> A connection could not be made to the report server
> http://phxdb02/Reports.
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.
> (Microsoft.ReportingServices.Designer)
> The request failed with HTTP status 404: Not Found.
> (Microsoft.ReportingServices.Designer)
>|||Perfect! Thank you, that was it!!!
"Jasper Smith" wrote:
> You need to specify the ReportServer web service endpoint not the Report
> Manager url e.g. in your Project Properties for the TargetServerURL specify
> http://phxdb02/ReportServer
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:EDDFC084-0623-4FE2-B742-2AAA52D2E3ED@.microsoft.com...
> > I'm stuck, any ideas? Is this a version or sp issue or a connection
> > problem?
> >
> > SQL Server 2005, Report Server Version: 9.00.1399.00 Visual Studio 2005.
> > All my service and accounts are set up fine, I can manually upload a
> > report
> > and data source to the report server, but VS 2005 will not deploy when the
> > web server is set in the TargetServerURL property.
> >
> > The error I get is
> >
> > TITLE: Microsoft Report Designer
> >
> > A connection could not be made to the report server
> > http://phxdb02/Reports.
> >
> > ADDITIONAL INFORMATION:
> >
> > The attempt to connect to the report server failed. Check your connection
> > information and that the report server is a compatible version.
> > (Microsoft.ReportingServices.Designer)
> >
> > The request failed with HTTP status 404: Not Found.
> > (Microsoft.ReportingServices.Designer)
> >
>
>

Reports without Using VS ?

Can I create reports for Report Services without having Visual Studio? If
so.. how?
Thanks,
RichYou cannot not avoid having some component of Visual Studio installed if you
want to use Report Designer.
You might want to review what tools are offered by our partners:
http://www.microsoft.com/sql/reporting/partners/default.asp
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Morey" <rwmorey71@.hotmail.com> wrote in message
news:uZIYfN$nEHA.628@.TK2MSFTNGP10.phx.gbl...
> Can I create reports for Report Services without having Visual Studio? If
> so.. how?
> Thanks,
> Rich
>|||Hi,
Is there any kind of freely downloadable thing that I can use? It seems a
little strange to me that Report Services would ship free with SQL Server
2000 but not include something to actually build reports with.. :-(
Rich
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:exwu%23l$nEHA.2300@.TK2MSFTNGP10.phx.gbl...
> You cannot not avoid having some component of Visual Studio installed if
> you
> want to use Report Designer.
> You might want to review what tools are offered by our partners:
> http://www.microsoft.com/sql/reporting/partners/default.asp
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Richard Morey" <rwmorey71@.hotmail.com> wrote in message
> news:uZIYfN$nEHA.628@.TK2MSFTNGP10.phx.gbl...
>> Can I create reports for Report Services without having Visual Studio? If
>> so.. how?
>> Thanks,
>> Rich
>>
>|||That is the intention with Yukon. For now all you need is some sort of
version of VS. The least expensive would be around $100 (VB.Net).
Bruce L-C
"Richard Morey" <rwmorey71@.hotmail.com> wrote in message
news:e3xoyvAoEHA.3224@.tk2msftngp13.phx.gbl...
> Hi,
> Is there any kind of freely downloadable thing that I can use? It seems a
> little strange to me that Report Services would ship free with SQL Server
> 2000 but not include something to actually build reports with.. :-(
> Rich
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> news:exwu%23l$nEHA.2300@.TK2MSFTNGP10.phx.gbl...
> > You cannot not avoid having some component of Visual Studio installed if
> > you
> > want to use Report Designer.
> > You might want to review what tools are offered by our partners:
> > http://www.microsoft.com/sql/reporting/partners/default.asp
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> >
> > "Richard Morey" <rwmorey71@.hotmail.com> wrote in message
> > news:uZIYfN$nEHA.628@.TK2MSFTNGP10.phx.gbl...
> >> Can I create reports for Report Services without having Visual Studio?
If
> >> so.. how?
> >>
> >> Thanks,
> >>
> >> Rich
> >>
> >>
> >
> >
>|||Would one of the "Express" version of VB, etc.. work?
Also, I would be developing reports on my machine, not on the server running
Report Services. What do I need to install on my machine to get Report
Writer to run?
I also hae Delphi.Net on my computer -- is this enough to install Report
Writer?
Rich
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uDDLfABoEHA.3464@.TK2MSFTNGP14.phx.gbl...
> That is the intention with Yukon. For now all you need is some sort of
> version of VS. The least expensive would be around $100 (VB.Net).
> Bruce L-C
> "Richard Morey" <rwmorey71@.hotmail.com> wrote in message
> news:e3xoyvAoEHA.3224@.tk2msftngp13.phx.gbl...
>> Hi,
>> Is there any kind of freely downloadable thing that I can use? It seems a
>> little strange to me that Report Services would ship free with SQL Server
>> 2000 but not include something to actually build reports with.. :-(
>> Rich
>> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
>> news:exwu%23l$nEHA.2300@.TK2MSFTNGP10.phx.gbl...
>> > You cannot not avoid having some component of Visual Studio installed
>> > if
>> > you
>> > want to use Report Designer.
>> > You might want to review what tools are offered by our partners:
>> > http://www.microsoft.com/sql/reporting/partners/default.asp
>> >
>> > --
>> > Bruce Johnson [MSFT]
>> > Microsoft SQL Server Reporting Services
>> >
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Richard Morey" <rwmorey71@.hotmail.com> wrote in message
>> > news:uZIYfN$nEHA.628@.TK2MSFTNGP10.phx.gbl...
>> >> Can I create reports for Report Services without having Visual Studio?
> If
>> >> so.. how?
>> >>
>> >> Thanks,
>> >>
>> >> Rich
>> >>
>> >>
>> >
>> >
>>
>|||The express version is a beta of the next release of VB. The report designer
will not work with that version of Visual Studio. The report writer is
separate from the server. You can install both but you do not have to.
Indeed, it will be common to not have the designer on the same machine as
the server. The server install makes it seem like you have both together but
you can just ignore the message about VS when installing the server.
I doubt the Report Writer would install with Delphi.Net. Think of the report
writer as an add-on to VS.
At a minimum you need VS 2003 (any version) and dotnet 1.1, some version of
MDAC 2.6 or higher.If you have a version of VS 2003 the rest of the
requirements will be checked for during the install and installed if they
are not there.
Bruce L-C
"Richard Morey" <rwmorey71@.hotmail.com> wrote in message
news:uC$MIENoEHA.2900@.TK2MSFTNGP09.phx.gbl...
> Would one of the "Express" version of VB, etc.. work?
> Also, I would be developing reports on my machine, not on the server
running
> Report Services. What do I need to install on my machine to get Report
> Writer to run?
> I also hae Delphi.Net on my computer -- is this enough to install Report
> Writer?
> Rich
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uDDLfABoEHA.3464@.TK2MSFTNGP14.phx.gbl...
> > That is the intention with Yukon. For now all you need is some sort of
> > version of VS. The least expensive would be around $100 (VB.Net).
> >
> > Bruce L-C
> >
> > "Richard Morey" <rwmorey71@.hotmail.com> wrote in message
> > news:e3xoyvAoEHA.3224@.tk2msftngp13.phx.gbl...
> >> Hi,
> >>
> >> Is there any kind of freely downloadable thing that I can use? It seems
a
> >> little strange to me that Report Services would ship free with SQL
Server
> >> 2000 but not include something to actually build reports with.. :-(
> >>
> >> Rich
> >>
> >> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> >> news:exwu%23l$nEHA.2300@.TK2MSFTNGP10.phx.gbl...
> >> > You cannot not avoid having some component of Visual Studio installed
> >> > if
> >> > you
> >> > want to use Report Designer.
> >> > You might want to review what tools are offered by our partners:
> >> > http://www.microsoft.com/sql/reporting/partners/default.asp
> >> >
> >> > --
> >> > Bruce Johnson [MSFT]
> >> > Microsoft SQL Server Reporting Services
> >> >
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >
> >> >
> >> > "Richard Morey" <rwmorey71@.hotmail.com> wrote in message
> >> > news:uZIYfN$nEHA.628@.TK2MSFTNGP10.phx.gbl...
> >> >> Can I create reports for Report Services without having Visual
Studio?
> > If
> >> >> so.. how?
> >> >>
> >> >> Thanks,
> >> >>
> >> >> Rich
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>

reports running in VB.Net much slower than Visual Studio

I've been building reporting services reports for the last 6 months,
and we just got our reporting services server last week. I've started
deploying my reports to the reporting server, and I'm disappointed in
the speed of the reports in a VB.Net windows application. I'm running
the reports in remote processing mode (not local).
The reports generate much slower than they do in Visual Studio. The
reports generate REALLY slow, if the reports are viewed in print
layout mode. I'd like to be able to use the print layout view, so the
report will display the footers, page breaks, and page numbering
correctly.
The reports run great in Visual Studio. Does anyone have any
suggestions to make the reports in a VB.Net windows application run
like they do in Visual Studio? Can anyone explain why the performance
is so different between the two? Why does rendering the report in
print layout mode so much slower in VB vs. Visual Studio? Or should
it be the same?
I'm using reporting services 2005. Our reporting services server is
running on a separate server than our SQL database.The rendering engine is the same in VS 2005 development environment as that
on the server (this was not true in 2000 which is why sometimes you would
see some small differences). However, VS 2005 caches data. That can account
for some of the issues. Another issue is network transmission time. But, the
main time difference is when you preview in VS you are previewing html which
is many times faster than PDF or other types of formats.
RS shines at providing data quickly to the user. By deciding you want to
present a book (or an electronic paper report) you are not taking advantage
of the strengths of RS. The best way to design reports is to present 10-20
pages to the user (or less). Make extensive use of drill through (links that
pull up additional detail reports).
They are re-writing the rendering engine for 2008 and expect PDF (and other
formats) that are slow today to be quite a bit faster.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<billyburditt@.gmail.com> wrote in message
news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
> I've been building reporting services reports for the last 6 months,
> and we just got our reporting services server last week. I've started
> deploying my reports to the reporting server, and I'm disappointed in
> the speed of the reports in a VB.Net windows application. I'm running
> the reports in remote processing mode (not local).
> The reports generate much slower than they do in Visual Studio. The
> reports generate REALLY slow, if the reports are viewed in print
> layout mode. I'd like to be able to use the print layout view, so the
> report will display the footers, page breaks, and page numbering
> correctly.
> The reports run great in Visual Studio. Does anyone have any
> suggestions to make the reports in a VB.Net windows application run
> like they do in Visual Studio? Can anyone explain why the performance
> is so different between the two? Why does rendering the report in
> print layout mode so much slower in VB vs. Visual Studio? Or should
> it be the same?
> I'm using reporting services 2005. Our reporting services server is
> running on a separate server than our SQL database.
>|||On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> The rendering engine is the same in VS 2005 development environment as that
> on the server (this was not true in 2000 which is why sometimes you would
> see some small differences). However, VS 2005 caches data. That can account
> for some of the issues. Another issue is network transmission time. But, the
> main time difference is when you preview in VS you are previewing html which
> is many times faster than PDF or other types of formats.
> RS shines at providing data quickly to the user. By deciding you want to
> present a book (or an electronic paper report) you are not taking advantage
> of the strengths of RS. The best way to design reports is to present 10-20
> pages to the user (or less). Make extensive use of drill through (links that
> pull up additional detail reports).
> They are re-writing the rendering engine for 2008 and expect PDF (and other
> formats) that are slow today to be quite a bit faster.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <billyburd...@.gmail.com> wrote in message
> news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
>
> > I've been building reporting services reports for the last 6 months,
> > and we just got our reporting services server last week. I've started
> > deploying my reports to the reporting server, and I'm disappointed in
> > the speed of the reports in a VB.Net windows application. I'm running
> > the reports in remote processing mode (not local).
> > The reports generate much slower than they do in Visual Studio. The
> > reports generate REALLY slow, if the reports are viewed in print
> > layout mode. I'd like to be able to use the print layout view, so the
> > report will display the footers, page breaks, and page numbering
> > correctly.
> > The reports run great in Visual Studio. Does anyone have any
> > suggestions to make the reports in a VB.Net windows application run
> > like they do in Visual Studio? Can anyone explain why the performance
> > is so different between the two? Why does rendering the report in
> > print layout mode so much slower in VB vs. Visual Studio? Or should
> > it be the same?
> > I'm using reporting services 2005. Our reporting services server is
> > running on a separate server than our SQL database.- Hide quoted text -
> - Show quoted text -
Thanks for your response. For the last 6 months I've been converting
excel reports to reporting services. Some of the reports are over 50
pages. I've been really pleased with creating these reports in
reporting services. The reports look much better than the original
Excel reports, and from start to finish it only take a few minutes to
generate a pdf, which we send to our clients.
Putting the reports online or in a windows application with user
interactivity would have been icing on the cake. I can change some of
my reports to have a drill down, but several of the reports need to
show all the detail together. It's too bad reporting services only
supports an HTML version for the web. HTML doesn't display the
footers, page breaks, and page numbering like the pdf files. It also
does a post back when paging through the report, which is really slow
for a report like mine.
Interactive reports would have been awesome for my reports, but
they're just too big. You said 2008 engine will be much faster. This
will be great for a windows application. Do you know if 2008 will
have a different format than HTML for the web? I haven't found much
information on reporting services for 2008.|||You can render however you want (html, pdf, excel). If you do PDF that will
show in the browser. In particular PDF will be much much faster (I've been
promised, I haven't seen). So your reports can be displayed in your VB app
with PDF and you will/should see substantial performance improvements with
2008.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<billyburditt@.gmail.com> wrote in message
news:1185982595.638219.275480@.19g2000hsx.googlegroups.com...
> On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> The rendering engine is the same in VS 2005 development environment as
>> that
>> on the server (this was not true in 2000 which is why sometimes you would
>> see some small differences). However, VS 2005 caches data. That can
>> account
>> for some of the issues. Another issue is network transmission time. But,
>> the
>> main time difference is when you preview in VS you are previewing html
>> which
>> is many times faster than PDF or other types of formats.
>> RS shines at providing data quickly to the user. By deciding you want to
>> present a book (or an electronic paper report) you are not taking
>> advantage
>> of the strengths of RS. The best way to design reports is to present
>> 10-20
>> pages to the user (or less). Make extensive use of drill through (links
>> that
>> pull up additional detail reports).
>> They are re-writing the rendering engine for 2008 and expect PDF (and
>> other
>> formats) that are slow today to be quite a bit faster.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <billyburd...@.gmail.com> wrote in message
>> news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
>>
>> > I've been building reporting services reports for the last 6 months,
>> > and we just got our reporting services server last week. I've started
>> > deploying my reports to the reporting server, and I'm disappointed in
>> > the speed of the reports in a VB.Net windows application. I'm running
>> > the reports in remote processing mode (not local).
>> > The reports generate much slower than they do in Visual Studio. The
>> > reports generate REALLY slow, if the reports are viewed in print
>> > layout mode. I'd like to be able to use the print layout view, so the
>> > report will display the footers, page breaks, and page numbering
>> > correctly.
>> > The reports run great in Visual Studio. Does anyone have any
>> > suggestions to make the reports in a VB.Net windows application run
>> > like they do in Visual Studio? Can anyone explain why the performance
>> > is so different between the two? Why does rendering the report in
>> > print layout mode so much slower in VB vs. Visual Studio? Or should
>> > it be the same?
>> > I'm using reporting services 2005. Our reporting services server is
>> > running on a separate server than our SQL database.- Hide quoted text -
>> - Show quoted text -
> Thanks for your response. For the last 6 months I've been converting
> excel reports to reporting services. Some of the reports are over 50
> pages. I've been really pleased with creating these reports in
> reporting services. The reports look much better than the original
> Excel reports, and from start to finish it only take a few minutes to
> generate a pdf, which we send to our clients.
> Putting the reports online or in a windows application with user
> interactivity would have been icing on the cake. I can change some of
> my reports to have a drill down, but several of the reports need to
> show all the detail together. It's too bad reporting services only
> supports an HTML version for the web. HTML doesn't display the
> footers, page breaks, and page numbering like the pdf files. It also
> does a post back when paging through the report, which is really slow
> for a report like mine.
> Interactive reports would have been awesome for my reports, but
> they're just too big. You said 2008 engine will be much faster. This
> will be great for a windows application. Do you know if 2008 will
> have a different format than HTML for the web? I haven't found much
> information on reporting services for 2008.
>|||On Aug 1, 11:26 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You can render however you want (html, pdf, excel). If you do PDF that will
> show in the browser. In particular PDF will be much much faster (I've been
> promised, I haven't seen). So your reports can be displayed in your VB app
> with PDF and you will/should see substantial performance improvements with
> 2008.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <billyburd...@.gmail.com> wrote in message
> news:1185982595.638219.275480@.19g2000hsx.googlegroups.com...
>
> > On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> The rendering engine is the same in VS 2005 development environment as
> >> that
> >> on the server (this was not true in 2000 which is why sometimes you would
> >> see some small differences). However, VS 2005 caches data. That can
> >> account
> >> for some of the issues. Another issue is network transmission time. But,
> >> the
> >> main time difference is when you preview in VS you are previewing html
> >> which
> >> is many times faster than PDF or other types of formats.
> >> RS shines at providing data quickly to the user. By deciding you want to
> >> present a book (or an electronic paper report) you are not taking
> >> advantage
> >> of the strengths of RS. The best way to design reports is to present
> >> 10-20
> >> pages to the user (or less). Make extensive use of drill through (links
> >> that
> >> pull up additional detail reports).
> >> They are re-writing the rendering engine for 2008 and expect PDF (and
> >> other
> >> formats) that are slow today to be quite a bit faster.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> <billyburd...@.gmail.com> wrote in message
> >>news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
> >> > I've been building reporting services reports for the last 6 months,
> >> > and we just got our reporting services server last week. I've started
> >> > deploying my reports to the reporting server, and I'm disappointed in
> >> > the speed of the reports in a VB.Net windows application. I'm running
> >> > the reports in remote processing mode (not local).
> >> > The reports generate much slower than they do in Visual Studio. The
> >> > reports generate REALLY slow, if the reports are viewed in print
> >> > layout mode. I'd like to be able to use the print layout view, so the
> >> > report will display the footers, page breaks, and page numbering
> >> > correctly.
> >> > The reports run great in Visual Studio. Does anyone have any
> >> > suggestions to make the reports in a VB.Net windows application run
> >> > like they do in Visual Studio? Can anyone explain why the performance
> >> > is so different between the two? Why does rendering the report in
> >> > print layout mode so much slower in VB vs. Visual Studio? Or should
> >> > it be the same?
> >> > I'm using reporting services 2005. Our reporting services server is
> >> > running on a separate server than our SQL database.- Hide quoted text -
> >> - Show quoted text -
> > Thanks for your response. For the last 6 months I've been converting
> > excel reports to reporting services. Some of the reports are over 50
> > pages. I've been really pleased with creating these reports in
> > reporting services. The reports look much better than the original
> > Excel reports, and from start to finish it only take a few minutes to
> > generate a pdf, which we send to our clients.
> > Putting the reports online or in a windows application with user
> > interactivity would have been icing on the cake. I can change some of
> > my reports to have a drill down, but several of the reports need to
> > show all the detail together. It's too bad reporting services only
> > supports an HTML version for the web. HTML doesn't display the
> > footers, page breaks, and page numbering like the pdf files. It also
> > does a post back when paging through the report, which is really slow
> > for a report like mine.
> > Interactive reports would have been awesome for my reports, but
> > they're just too big. You said 2008 engine will be much faster. This
> > will be great for a windows application. Do you know if 2008 will
> > have a different format than HTML for the web? I haven't found much
> > information on reporting services for 2008.- Hide quoted text -
> - Show quoted text -
I know you can export in those different formats, but can you display
the reports in a different format other than HTML on the web? HTML
doesn't display correctly and you have to post back to the server to
move through the pages of the document.
Billy|||Sure. When you request the rendering you can specify the format. Plenty of
people go right to PDF (HTML is much faster currently).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<billyburditt@.gmail.com> wrote in message
news:1186175875.359497.281210@.g4g2000hsf.googlegroups.com...
> On Aug 1, 11:26 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> You can render however you want (html, pdf, excel). If you do PDF that
>> will
>> show in the browser. In particular PDF will be much much faster (I've
>> been
>> promised, I haven't seen). So your reports can be displayed in your VB
>> app
>> with PDF and you will/should see substantial performance improvements
>> with
>> 2008.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <billyburd...@.gmail.com> wrote in message
>> news:1185982595.638219.275480@.19g2000hsx.googlegroups.com...
>>
>> > On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> > wrote:
>> >> The rendering engine is the same in VS 2005 development environment as
>> >> that
>> >> on the server (this was not true in 2000 which is why sometimes you
>> >> would
>> >> see some small differences). However, VS 2005 caches data. That can
>> >> account
>> >> for some of the issues. Another issue is network transmission time.
>> >> But,
>> >> the
>> >> main time difference is when you preview in VS you are previewing html
>> >> which
>> >> is many times faster than PDF or other types of formats.
>> >> RS shines at providing data quickly to the user. By deciding you want
>> >> to
>> >> present a book (or an electronic paper report) you are not taking
>> >> advantage
>> >> of the strengths of RS. The best way to design reports is to present
>> >> 10-20
>> >> pages to the user (or less). Make extensive use of drill through
>> >> (links
>> >> that
>> >> pull up additional detail reports).
>> >> They are re-writing the rendering engine for 2008 and expect PDF (and
>> >> other
>> >> formats) that are slow today to be quite a bit faster.
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >> <billyburd...@.gmail.com> wrote in message
>> >>news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
>> >> > I've been building reporting services reports for the last 6 months,
>> >> > and we just got our reporting services server last week. I've
>> >> > started
>> >> > deploying my reports to the reporting server, and I'm disappointed
>> >> > in
>> >> > the speed of the reports in a VB.Net windows application. I'm
>> >> > running
>> >> > the reports in remote processing mode (not local).
>> >> > The reports generate much slower than they do in Visual Studio. The
>> >> > reports generate REALLY slow, if the reports are viewed in print
>> >> > layout mode. I'd like to be able to use the print layout view, so
>> >> > the
>> >> > report will display the footers, page breaks, and page numbering
>> >> > correctly.
>> >> > The reports run great in Visual Studio. Does anyone have any
>> >> > suggestions to make the reports in a VB.Net windows application run
>> >> > like they do in Visual Studio? Can anyone explain why the
>> >> > performance
>> >> > is so different between the two? Why does rendering the report in
>> >> > print layout mode so much slower in VB vs. Visual Studio? Or should
>> >> > it be the same?
>> >> > I'm using reporting services 2005. Our reporting services server is
>> >> > running on a separate server than our SQL database.- Hide quoted
>> >> > text -
>> >> - Show quoted text -
>> > Thanks for your response. For the last 6 months I've been converting
>> > excel reports to reporting services. Some of the reports are over 50
>> > pages. I've been really pleased with creating these reports in
>> > reporting services. The reports look much better than the original
>> > Excel reports, and from start to finish it only take a few minutes to
>> > generate a pdf, which we send to our clients.
>> > Putting the reports online or in a windows application with user
>> > interactivity would have been icing on the cake. I can change some of
>> > my reports to have a drill down, but several of the reports need to
>> > show all the detail together. It's too bad reporting services only
>> > supports an HTML version for the web. HTML doesn't display the
>> > footers, page breaks, and page numbering like the pdf files. It also
>> > does a post back when paging through the report, which is really slow
>> > for a report like mine.
>> > Interactive reports would have been awesome for my reports, but
>> > they're just too big. You said 2008 engine will be much faster. This
>> > will be great for a windows application. Do you know if 2008 will
>> > have a different format than HTML for the web? I haven't found much
>> > information on reporting services for 2008.- Hide quoted text -
>> - Show quoted text -
> I know you can export in those different formats, but can you display
> the reports in a different format other than HTML on the web? HTML
> doesn't display correctly and you have to post back to the server to
> move through the pages of the document.
> Billy
>|||On Aug 3, 10:03 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Sure. When you request the rendering you can specify the format. Plenty of
> people go right to PDF (HTML is much faster currently).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <billyburd...@.gmail.com> wrote in message
> news:1186175875.359497.281210@.g4g2000hsf.googlegroups.com...
>
> > On Aug 1, 11:26 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> You can render however you want (html, pdf, excel). If you do PDF that
> >> will
> >> show in the browser. In particular PDF will be much much faster (I've
> >> been
> >> promised, I haven't seen). So your reports can be displayed in your VB
> >> app
> >> with PDF and you will/should see substantial performance improvements
> >> with
> >> 2008.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> <billyburd...@.gmail.com> wrote in message
> >>news:1185982595.638219.275480@.19g2000hsx.googlegroups.com...
> >> > On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:
> >> >> The rendering engine is the same in VS 2005 development environment as
> >> >> that
> >> >> on the server (this was not true in 2000 which is why sometimes you
> >> >> would
> >> >> see some small differences). However, VS 2005 caches data. That can
> >> >> account
> >> >> for some of the issues. Another issue is network transmission time.
> >> >> But,
> >> >> the
> >> >> main time difference is when you preview in VS you are previewing html
> >> >> which
> >> >> is many times faster than PDF or other types of formats.
> >> >> RS shines at providing data quickly to the user. By deciding you want
> >> >> to
> >> >> present a book (or an electronic paper report) you are not taking
> >> >> advantage
> >> >> of the strengths of RS. The best way to design reports is to present
> >> >> 10-20
> >> >> pages to the user (or less). Make extensive use of drill through
> >> >> (links
> >> >> that
> >> >> pull up additional detail reports).
> >> >> They are re-writing the rendering engine for 2008 and expect PDF (and
> >> >> other
> >> >> formats) that are slow today to be quite a bit faster.
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >> <billyburd...@.gmail.com> wrote in message
> >> >>news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
> >> >> > I've been building reporting services reports for the last 6 months,
> >> >> > and we just got our reporting services server last week. I've
> >> >> > started
> >> >> > deploying my reports to the reporting server, and I'm disappointed
> >> >> > in
> >> >> > the speed of the reports in a VB.Net windows application. I'm
> >> >> > running
> >> >> > the reports in remote processing mode (not local).
> >> >> > The reports generate much slower than they do in Visual Studio. The
> >> >> > reports generate REALLY slow, if the reports are viewed in print
> >> >> > layout mode. I'd like to be able to use the print layout view, so
> >> >> > the
> >> >> > report will display the footers, page breaks, and page numbering
> >> >> > correctly.
> >> >> > The reports run great in Visual Studio. Does anyone have any
> >> >> > suggestions to make the reports in a VB.Net windows application run
> >> >> > like they do in Visual Studio? Can anyone explain why the
> >> >> > performance
> >> >> > is so different between the two? Why does rendering the report in
> >> >> > print layout mode so much slower in VB vs. Visual Studio? Or should
> >> >> > it be the same?
> >> >> > I'm using reporting services 2005. Our reporting services server is
> >> >> > running on a separate server than our SQL database.- Hide quoted
> >> >> > text -
> >> >> - Show quoted text -
> >> > Thanks for your response. For the last 6 months I've been converting
> >> > excel reports to reporting services. Some of the reports are over 50
> >> > pages. I've been really pleased with creating these reports in
> >> > reporting services. The reports look much better than the original
> >> > Excel reports, and from start to finish it only take a few minutes to
> >> > generate a pdf, which we send to our clients.
> >> > Putting the reports online or in a windows application with user
> >> > interactivity would have been icing on the cake. I can change some of
> >> > my reports to have a drill down, but several of the reports need to
> >> > show all the detail together. It's too bad reporting services only
> >> > supports an HTML version for the web. HTML doesn't display the
> >> > footers, page breaks, and page numbering like the pdf files. It also
> >> > does a post back when paging through the report, which is really slow
> >> > for a report like mine.
> >> > Interactive reports would have been awesome for my reports, but
> >> > they're just too big. You said 2008 engine will be much faster. This
> >> > will be great for a windows application. Do you know if 2008 will
> >> > have a different format than HTML for the web? I haven't found much
> >> > information on reporting services for 2008.- Hide quoted text -
> >> - Show quoted text -
> > I know you can export in those different formats, but can you display
> > the reports in a different format other than HTML on the web? HTML
> > doesn't display correctly and you have to post back to the server to
> > move through the pages of the document.
> > Billy- Hide quoted text -
> - Show quoted text -
I'll do some research on how to do this. Thanks for all your
responses.
Billy

Reports Questions

Hi everybody!

I have some questions about Reports:

1. Where I download Report Builder?
2. Can I use it with an Access Database?
3. I use Visual Basic 2005 Express, but I can't see any report control (like Report Viewer, ...). Is it avaible in VB 2005 Express? If yes, how can I activate it?
4. There is a way to convert my Access Reports to a SQL Report (or some report that work with VB .NET, like Crystal Report or another) ? Report Designer do it?
5. Where I download Report Designer?

Can someone helpme?
Thanks, very much!Report Builder is a part of SQL Server, Workgroup edition or better. Currently you can use it with SQL Server databases, and Oracle support is coming soon.

ReportViewer and Report Designer are included in Visual Studio, Standard edition or better (not Express). However, Visual Web Developer Express is supported via an add-in: http://msdn.microsoft.com/vstudio/express/vwd/download/

Report Designer is not currently downloadable, except as included in the VWD add-in mentioned above.

Report Designer--the edition included in SQL Server--can import Access reports.|||Rajeev,

You wrote: "Currently you can use it with SQL Server databases, and Oracle support is coming soon."

Is DB2 support ever going to be added?

Reports Questions

Hi everybody!

I have some questions about Reports:

1. Where I download Report Builder?
2. Can I use it with an Access Database?
3. I use Visual Basic 2005 Express, but I can't see any report control (like Report Viewer, ...). Is it avaible in VB 2005 Express? If yes, how can I activate it?
4. There is a way to convert my Access Reports to a SQL Report (or some report that work with VB .NET, like Crystal Report or another) ? Report Designer do it?
5. Where I download Report Designer?

Can someone helpme?
Thanks, very much!Report Builder is a part of SQL Server, Workgroup edition or better. Currently you can use it with SQL Server databases, and Oracle support is coming soon.

ReportViewer and Report Designer are included in Visual Studio, Standard edition or better (not Express). However, Visual Web Developer Express is supported via an add-in: http://msdn.microsoft.com/vstudio/express/vwd/download/

Report Designer is not currently downloadable, except as included in the VWD add-in mentioned above.

Report Designer--the edition included in SQL Server--can import Access reports.
|||Rajeev,

You wrote: "Currently you can use it with SQL Server databases, and Oracle support is coming soon."

Is DB2 support ever going to be added?

Reporting, Visual Studio, layout level, median function

I'd like to calculate the median of a set of values, ie: 1,2,2,2,5 would have
a median of 2.
I've been able to get the average using
sum(fields!1.value)/count(fields!1.value) or Avg(fields!1.value).
How can the median be found using either a function or a math formula?
Thanks,
JimI have no clue if this would work, but it might be worth a try... add a new
text column ( and maybe hide it)...
It's value is
=IIF(rownumber(nothring)=Count(Fields!1,Value),Fields!Fieldname.Value,0)
So the value of this field will be 0 for all rows except the middle row,
which will have the value of the OTHER column with values ... Of course this
only would work if the OTHER column is sorted, and you'd have to account for
an even/odd number of rows...
But then you sum this column in your aggregate row, which would be the
median value...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:440D1DAE-8C20-41D5-819D-C193254626F4@.microsoft.com...
> I'd like to calculate the median of a set of values, ie: 1,2,2,2,5 would
> have
> a median of 2.
> I've been able to get the average using
> sum(fields!1.value)/count(fields!1.value) or Avg(fields!1.value).
> How can the median be found using either a function or a math formula?
> Thanks,
> Jim|||Is your syntax correct? I cant get it to work..
=IIF(rownumber(nothring)=Count(Fields!1,Value),Fields!Fieldname.Value,0)
what does Fields!1 represent?
"Wayne Snyder" wrote:
> I have no clue if this would work, but it might be worth a try... add a new
> text column ( and maybe hide it)...
> It's value is
> =IIF(rownumber(nothring)=Count(Fields!1,Value),Fields!Fieldname.Value,0)
> So the value of this field will be 0 for all rows except the middle row,
> which will have the value of the OTHER column with values ... Of course this
> only would work if the OTHER column is sorted, and you'd have to account for
> an even/odd number of rows...
> But then you sum this column in your aggregate row, which would be the
> median value...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:440D1DAE-8C20-41D5-819D-C193254626F4@.microsoft.com...
> > I'd like to calculate the median of a set of values, ie: 1,2,2,2,5 would
> > have
> > a median of 2.
> >
> > I've been able to get the average using
> > sum(fields!1.value)/count(fields!1.value) or Avg(fields!1.value).
> >
> > How can the median be found using either a function or a math formula?
> >
> > Thanks,
> > Jim
>
>

Reporting Svcs 2000 and Visual Studio 2005?

Hi,
I'm a newbie to Reporting Svcs.
My PC has VStudio 2003 and VStudio 2005.
I installed Rep Svcs 2000 and created a report with it from VStudio 2003.
From VStudio 2005 there's no access to create projects of type Report.
The windows end-user application project that needs to display the reports
is in VStudio 2005, but from VStudio 2005 I don't see the option to create
reports with Rep Svcs 2000.
I need to be able to design reports in Rep Svcs 2000 and be able to access
them from this win application project that is in VStudio 2005. Is this
possible? How can I do that?
Thank you in advance,
RichardRS 2000 is a framework 1.1 asp.net application. RS 2005 is a 2.0 framework
asp.net application. There are two ways to integrate a 2.0 app with (whether
winforms or webforms) you can use web services (which requires a good bit of
work on your part for winforms) or you can use URL integration. Just embed
an IE control on your winform and use URL integration. Pretty straight
forward as long as you are doing an intranet app.
VS 2005 comes with new winform and webform controls. These can be used in
either local mode (all rendering is local, no server is involved) or server
mode. Either way, the new controls only work with RS 2005 reports.
Note that you can (if you have a license) install RS 2005 to use SQL Server
2000 as its metadata/object store.
I highly recommend going to RS 2005. It has a lot of new, really useful
features (better performance, multi-select parameters, end user sorting,
etc).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:FC440BC3-BF2F-430E-A5CB-9929322F7EE7@.microsoft.com...
> Hi,
> I'm a newbie to Reporting Svcs.
> My PC has VStudio 2003 and VStudio 2005.
> I installed Rep Svcs 2000 and created a report with it from VStudio 2003.
> From VStudio 2005 there's no access to create projects of type Report.
> The windows end-user application project that needs to display the reports
> is in VStudio 2005, but from VStudio 2005 I don't see the option to create
> reports with Rep Svcs 2000.
> I need to be able to design reports in Rep Svcs 2000 and be able to access
> them from this win application project that is in VStudio 2005. Is this
> possible? How can I do that?
> Thank you in advance,
> Richard|||Thank you, Bruce. Then is it possible to design the report using Rpt Scvs
2000, and have the WinForm application in .Net 2.0 invoke/render/display this
report? How would you suggest this could be done?
Thank you in advance,
Richard
===
"Bruce L-C [MVP]" wrote:
> RS 2000 is a framework 1.1 asp.net application. RS 2005 is a 2.0 framework
> asp.net application. There are two ways to integrate a 2.0 app with (whether
> winforms or webforms) you can use web services (which requires a good bit of
> work on your part for winforms) or you can use URL integration. Just embed
> an IE control on your winform and use URL integration. Pretty straight
> forward as long as you are doing an intranet app.
> VS 2005 comes with new winform and webform controls. These can be used in
> either local mode (all rendering is local, no server is involved) or server
> mode. Either way, the new controls only work with RS 2005 reports.
> Note that you can (if you have a license) install RS 2005 to use SQL Server
> 2000 as its metadata/object store.
> I highly recommend going to RS 2005. It has a lot of new, really useful
> features (better performance, multi-select parameters, end user sorting,
> etc).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:FC440BC3-BF2F-430E-A5CB-9929322F7EE7@.microsoft.com...
> > Hi,
> >
> > I'm a newbie to Reporting Svcs.
> > My PC has VStudio 2003 and VStudio 2005.
> > I installed Rep Svcs 2000 and created a report with it from VStudio 2003.
> > From VStudio 2005 there's no access to create projects of type Report.
> >
> > The windows end-user application project that needs to display the reports
> > is in VStudio 2005, but from VStudio 2005 I don't see the option to create
> > reports with Rep Svcs 2000.
> >
> > I need to be able to design reports in Rep Svcs 2000 and be able to access
> > them from this win application project that is in VStudio 2005. Is this
> > possible? How can I do that?
> >
> > Thank you in advance,
> >
> > Richard
>
>|||Webservices: render to PDF or HTML and give it to something to display.
URL integration. Assemble a string passing in parameters via URL. Use the IE
control in a Winform and set its URL to the string.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:E95F77EE-9D60-4863-8D68-E6B2CEEA79C6@.microsoft.com...
> Thank you, Bruce. Then is it possible to design the report using Rpt Scvs
> 2000, and have the WinForm application in .Net 2.0 invoke/render/display
> this
> report? How would you suggest this could be done?
> Thank you in advance,
> Richard
> ===> "Bruce L-C [MVP]" wrote:
>> RS 2000 is a framework 1.1 asp.net application. RS 2005 is a 2.0
>> framework
>> asp.net application. There are two ways to integrate a 2.0 app with
>> (whether
>> winforms or webforms) you can use web services (which requires a good bit
>> of
>> work on your part for winforms) or you can use URL integration. Just
>> embed
>> an IE control on your winform and use URL integration. Pretty straight
>> forward as long as you are doing an intranet app.
>> VS 2005 comes with new winform and webform controls. These can be used in
>> either local mode (all rendering is local, no server is involved) or
>> server
>> mode. Either way, the new controls only work with RS 2005 reports.
>> Note that you can (if you have a license) install RS 2005 to use SQL
>> Server
>> 2000 as its metadata/object store.
>> I highly recommend going to RS 2005. It has a lot of new, really useful
>> features (better performance, multi-select parameters, end user sorting,
>> etc).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:FC440BC3-BF2F-430E-A5CB-9929322F7EE7@.microsoft.com...
>> > Hi,
>> >
>> > I'm a newbie to Reporting Svcs.
>> > My PC has VStudio 2003 and VStudio 2005.
>> > I installed Rep Svcs 2000 and created a report with it from VStudio
>> > 2003.
>> > From VStudio 2005 there's no access to create projects of type Report.
>> >
>> > The windows end-user application project that needs to display the
>> > reports
>> > is in VStudio 2005, but from VStudio 2005 I don't see the option to
>> > create
>> > reports with Rep Svcs 2000.
>> >
>> > I need to be able to design reports in Rep Svcs 2000 and be able to
>> > access
>> > them from this win application project that is in VStudio 2005. Is this
>> > possible? How can I do that?
>> >
>> > Thank you in advance,
>> >
>> > Richard
>>|||Thank you. The current implementation uses Crystal Reports Viewer on a
WinForm, so the use of an IE control on a WinForm will be the easiest to
implement.
Sincerely,
Richard
==="Bruce L-C [MVP]" wrote:
> Webservices: render to PDF or HTML and give it to something to display.
> URL integration. Assemble a string passing in parameters via URL. Use the IE
> control in a Winform and set its URL to the string.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:E95F77EE-9D60-4863-8D68-E6B2CEEA79C6@.microsoft.com...
> > Thank you, Bruce. Then is it possible to design the report using Rpt Scvs
> > 2000, and have the WinForm application in .Net 2.0 invoke/render/display
> > this
> > report? How would you suggest this could be done?
> >
> > Thank you in advance,
> >
> > Richard
> > ===> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> RS 2000 is a framework 1.1 asp.net application. RS 2005 is a 2.0
> >> framework
> >> asp.net application. There are two ways to integrate a 2.0 app with
> >> (whether
> >> winforms or webforms) you can use web services (which requires a good bit
> >> of
> >> work on your part for winforms) or you can use URL integration. Just
> >> embed
> >> an IE control on your winform and use URL integration. Pretty straight
> >> forward as long as you are doing an intranet app.
> >>
> >> VS 2005 comes with new winform and webform controls. These can be used in
> >> either local mode (all rendering is local, no server is involved) or
> >> server
> >> mode. Either way, the new controls only work with RS 2005 reports.
> >>
> >> Note that you can (if you have a license) install RS 2005 to use SQL
> >> Server
> >> 2000 as its metadata/object store.
> >>
> >> I highly recommend going to RS 2005. It has a lot of new, really useful
> >> features (better performance, multi-select parameters, end user sorting,
> >> etc).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> >> news:FC440BC3-BF2F-430E-A5CB-9929322F7EE7@.microsoft.com...
> >> > Hi,
> >> >
> >> > I'm a newbie to Reporting Svcs.
> >> > My PC has VStudio 2003 and VStudio 2005.
> >> > I installed Rep Svcs 2000 and created a report with it from VStudio
> >> > 2003.
> >> > From VStudio 2005 there's no access to create projects of type Report.
> >> >
> >> > The windows end-user application project that needs to display the
> >> > reports
> >> > is in VStudio 2005, but from VStudio 2005 I don't see the option to
> >> > create
> >> > reports with Rep Svcs 2000.
> >> >
> >> > I need to be able to design reports in Rep Svcs 2000 and be able to
> >> > access
> >> > them from this win application project that is in VStudio 2005. Is this
> >> > possible? How can I do that?
> >> >
> >> > Thank you in advance,
> >> >
> >> > Richard
> >>
> >>
> >>
>
>

Reporting Services: I cannot deploy reports.

I am using Visual Studio 2005 and trying to deploy reports to SQL Server 2000.

I get the following message:

A connection could not be made to the report server http://aklink1/reportserver.

ADDITIONAL INFORMATION:

The attempt to connect to the report server failed.Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

Please help!

Hi,

The RDL files for SQL 2005 reports have changed. They are not backward compatible. Can you check the version of your Reporting Services Designer via the about box?

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

Version 9.00.1399.00

|||

Hi,

That's the 2005 version. You have 2 options:

upgrade the report server to 2005