Report/subreport help?

How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well.

Would you create a subreport or something else, and how many subreports can you have within a report, and if you had more then one where is the best places to insert it in the report and would you know where can I find some info about that.

I hope all of this makes sense,because I am just completely stuck.

Regards"How would you run one report that is made out of two reports at the same time to get them dispayed on seperate pages as well... and if you had more then one where is the best places to insert it in the report"

- I would create 2 subreports. The best place to put them (I think) would be the details section. Make a Details a and a Details b and set the NewPageAfter for Details a.

"how many subreports can you have within a report"

- I'm not sure what the limit is. I have a report that has 3 subreports without a problem.

"where can I find some info about that."

- Not sure about any specific websites, but you can try a search in following links:

Crystal Reports Help:
http://support.businessobjects.com/search/advsearch.asp

Crystal Reports Forum:
http://support.businessobjects.com/forums/default.asp|||thanks a lot for your help, I got some good suggestions, I just have to make it work now.

Regards

Report, Data sources errors.

Hi,

I have created several reports with Reporting Services and Visual Studio 2005 for an ASP.NET 2 application.

Now, when I want to edit a report and I select Report -> Data Sources in the Visual Studio menu, I get the error "prefix " cannot be mapped to namespace name "xml" or "xmlns". Line 1 position 87." My website datasources are empty and I can't build new reports.

Any idea ?

Thanks for your help.

Nicolas.

I am having this same problem. Does anyone have a solution.

I was able to make 2 Reports, and as I was working on my third report today the same error occured.

When i open the pervious reports i made (which still work), and goto Report > Data Sources I also get the error message:

Prefix '' cannot be mapped to namespace name reserved for "xml" or "xmls". Line 1, position 87

Any help is appreciated - thanks.

sql

Report Y-Axis Scale Appears to be incorrect

Chart Report Y-Axis is not consistently scaling correctly. For many reports, it works well and the Y-axis is correctly scaled. For others, Y-axis scaling is incorrect. We have verified that the data behind the report is correctly reflected in the chart. However, the chart Y-axis scaling is not matching the data.

For example in this report excerpt:

http://home.comcast.net/~michael.lane/Bad_Y-Scale_Trend_Chart.PNG

We are using automatic axis scaling with no programmatic intervention. Most other similar charts from this report display correctly, with correct scaling.

Your assistance in pinning this down is very much appreciated.

Although this issue was not on the list of items addressed, it nevertheless appears to be fixed via the latest SP1 patch.

Report Y-Axis Scale Appears to be incorrect

Chart Report Y-Axis is not consistently scaling correctly. For many reports, it works well and the Y-axis is correctly scaled. For others, Y-axis scaling is incorrect. We have verified that the data behind the report is correctly reflected in the chart. However, the chart Y-axis scaling is not matching the data.

For example in this report excerpt:

http://home.comcast.net/~michael.lane/Bad_Y-Scale_Trend_Chart.PNG

We are using automatic axis scaling with no programmatic intervention. Most other similar charts from this report display correctly, with correct scaling.

Your assistance in pinning this down is very much appreciated.

Although this issue was not on the list of items addressed, it nevertheless appears to be fixed via the latest SP1 patch.

Report with Multiple Tables Join

I am designing a Receipt using Crystal Reports 8.5 Developer, MS SQL 2000 Server and MS Visual Basic 6.0 sp6. My Receipt will grab some data from RCP, RCPGL, RCPDetail and Customer tables.

SQL = SELECT RCP.RCPID, RCPGL.RCPGLID, RCPDetail.RCPDetailID, RCP.RCPDate, RCP.RCPID, RCPGL.GLDate, RCPGL.ChequeNo, RCPGL.GrossAmount, RCPDetail.InvoiceNo, RCPDetail.AmountPaid, Customer.CustomerName FROM RCP, RCPDetail, RCPGL, Customer WHERE RCP.RCPID=RCPDetail.RCPID AND RCP.RCPID=RCPGL.RCPID AND RCP.CustomerID=Customer.CustomerID AND RCP.RCPID= glngRCPID

Let say RCPDetail has 3 Invoices data and RCPGL has 2 cheque transactions, my SQL query will returns 6 records.

What I want is to display a section with 3 records of Invoice and another section to display 2 lines of cheque transactions.

Anyone can give me some recommendation?Group on the record type. If this is implicit from the data (e.g. ChequeNo is non-0 for cheques) then create a formula to return a type and group on the formula.|||Hi JaganEllis,
Thanks for your suggestion. I have found an idea and it is using grouping too. I will create a temporary table call TempReceipt. I'll SELECT data from RCPGL table and INSERT "RCPGL" as the key into TempReceipt and then SELECT data from RCPDetail table and INSERT "RCPDetail" as the key. After that join the TempReceipt table with Customer table using ADO. When display the data in Report, I'll use Group by the key of TempReceipt to separate the data.sql

report with groupby

hi,
i have a query working with crystal reports on oracle server.

--There is a table transaction_hist containing 'due_date' column(which is a number to be converted to date). In the report i want the summary of the amounts with current due_date, future due_date, past 1to30 days due_date,31to60,61to90 and 91to180 due_dates.

eg
current future 1_30 31_60 61_90 91_181
sum 99999 99999 99999 9999 9999 9999


PS: i have tried to make formula column for all these due_dates...but could not group by them and summarize them.Try uisng Cross tab reports. Read more in help file

Report window opens, remains blank

I am trying to open reports through an existing application. When I click the button to run the report, the new window opens, appears to be trying to load (the windows logo in the top corner is flowing, the hourglass is present), and then stops. I am left with a blank window, no report, and no error message.

I am able to view and run the reports through the Report Server. Other users are able to run the reports through the application.

Any ideas?

Thanks,

Michelle

I found a solution. I had Adobe Reader 6.0 installed (still not sure why it wasn't working with that). I uninstalled this and installed the latest version of Adobe Reader (8.1), and it worked.

Report window opens, remains blank

I am trying to open reports through an existing application. When I click the button to run the report, the new window opens, appears to be trying to load (the windows logo in the top corner is flowing, the hourglass is present), and then stops. I am left with a blank window, no report, and no error message.

I am able to view and run the reports through the Report Server. Other users are able to run the reports through the application.

Any ideas?

Thanks,

Michelle

I found a solution. I had Adobe Reader 6.0 installed (still not sure why it wasn't working with that). I uninstalled this and installed the latest version of Adobe Reader (8.1), and it worked.sql

Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.sql

Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.

Report Viewer Web Part - Error - Help!

I am trying to integrate reports that I have built with VS 2005 and deployed to my report server locally.

The path to the report is

http://SERVERNAME/Reports/Pages/Report.aspx?ItemPath=%2fBilling+System+Reports%2fBasic+Financial+Reports%2fBasic+Financial+Statistics+-+TimeKeeper+YTD

When I put that into the "Report" parameter the web part display an error:

The report server has encountered a configuration error. See the report server log files for more information

And when I click on the ellipses, I get a pop up with the same error.

I installed SQL2005 SP2 and the RS Add on for MS sharepoint CTP

Any help would be great!

Thanks,

Erik

Assuming your report server is configured in SharePoint integrated mode (which I'm not sure it is). You don't use the report server path for the web part, you use the path to the report in SharePoint. You can get this path from the document library where the report is stored.

|||

What if I just want the web part to act like an iframe into the reporting services web front end, like the web parts for 2000 worked? Are these web parts not designed to work this way? If not, are there any 2005 web parts for viewing reports on the SSRS front end?

Thanks!

sql

Report Viewer shrinking and shows scrollbar

I am using Crystal Report Viewer in ASP.NET page. In some of my reports, the viewer seem to be shrinking to about one third of the page. I have set all properties including width etc properly.
Have anybody seen this behaviour before?I have also faced same problem..If you get any solve pls. post in this forum.|||We found that this problem happens when we install some specific printer drivers. If I uninstall all printers from my server, all reports are working fine. Please post your updates too..|||I was reading something on Crystal KB the other day about print drivers. I can't remember the exact scenario but the gist of it was that the report was misbehaving in the production environment.

The solution was to set the report to "No Printer" in the design environment so that it didn't carry over the print driver settings. Everytime a user prints with a different printer and those settings conflict with the design print settings, it creates havoc.

Just wondering if setting your report to "No Print" would alleviate this problem too?

Linda|||We tried that. And it worked fine until I try to print the report. When I print, it returns to the smaller size.

- Tony|||Sounds like a bug to me!

Report Viewer Question

I am using rs on a SQL 2000 DB and have an application built using VWDE 2005
to display reports. I installed the ReportViewer control and set the
appropriate URL and report path. When I open the page, I first get a popup
to enter the password (is there a way to avoid this?) and then I get what
looks like a report manager window on the screen. I have to navigate to my
reports, select the one I want and then click on the "Full Screen" icon to
see the report.
How can I get a page to simply present the report when opened?
WayneIs the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
use the new controls to display reports you need to have RS 2005 installed
(which can use a SQL Server 2000 DB, that is what I am doing).
If you want it hardcode during design then using the for Report Path (click
on the upper right of the control to fill in the report tasks) put in
something like this: /MyFolder/MyReport not sure if case sensitive but it
could be. For your server this is what I have: http://Myserver/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am using rs on a SQL 2000 DB and have an application built using VWDE
>2005 to display reports. I installed the ReportViewer control and set the
>appropriate URL and report path. When I open the page, I first get a popup
>to enter the password (is there a way to avoid this?) and then I get what
>looks like a report manager window on the screen. I have to navigate to my
>reports, select the one I want and then click on the "Full Screen" icon to
>see the report.
> How can I get a page to simply present the report when opened?
> Wayne
>|||The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
own the server.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
> use the new controls to display reports you need to have RS 2005 installed
> (which can use a SQL Server 2000 DB, that is what I am doing).
> If you want it hardcode during design then using the for Report Path
> (click on the upper right of the control to fill in the report tasks) put
> in something like this: /MyFolder/MyReport not sure if case sensitive
> but it could be. For your server this is what I have:
> http://Myserver/ReportServer
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a popup
>>to enter the password (is there a way to avoid this?) and then I get what
>>looks like a report manager window on the screen. I have to navigate to my
>>reports, select the one I want and then click on the "Full Screen" icon to
>>see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>|||I am pretty sure that the server needs to be RS2005. Looking at the info on
the controls it specifies RS 2005 for the server report. If you service
upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
supposed to be backward compatible.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
> own the server.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks) put
>> in something like this: /MyFolder/MyReport not sure if case sensitive
>> but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the "Full
>>Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>|||Thanks for the information - I'll check with my service provider.
Wayne
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23GcxKud%23FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am pretty sure that the server needs to be RS2005. Looking at the info on
>the controls it specifies RS 2005 for the server report. If you service
>upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
>supposed to be backward compatible.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
>> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I
>> don't own the server.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks)
>> put in something like this: /MyFolder/MyReport not sure if case
>> sensitive but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set
>>the appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the
>>"Full Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>>
>

Report Viewer on Internet Site

Hi, I am developing a website that will use the VS Report Viewer control to display some business reports.....The website will be on the internet, but the report viewer will need to access an internal report server that the internet users don't have access to? Is this possible, or the correct way to do this? Any ideas / suggestions would be appreciated!

Cheers
Chris

If you use anonymous access then the user who is accessing the report from the internet does not have to authenticate any type of username to the server.

However, you probably don't want just ANYONE to see your reports, so you may want to develop a secure front-end with Visual Studio to authenticate the user in that fashion. Sort of like a portal on a website. If you go this route, be sure to use a stored procedure and possibly encryption for your password I/O.

report viewer keep showing report is being generated

hi all,

i developed a web app with embedded report viewer to show the reports (server report). everything works alright. i created a setup file to install it at another machine. everything looks ok except that when i want to view the report, it will always show 'Report is being generated' for a very long time when it only takes a few seconds when i view it on report server.

i found the following warning in event viewer (application):

Process information:

Process ID: 4976

Process name: aspnet_wp.exe

Account name: DWPC1\ASPNET

Exception information:

Exception type: SoapException

Exception message: System.Web.Services.Protocols.SoapException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found > Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found

at Microsoft.ReportingServices.WebServer.SessionStarterAction.CreateExisting()

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

End of inner exception stack trace

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

Request information:

Request URL: http://localhost/AirForce/Reserved.ReportViewerWebControl.axd?ReportSession=icwhpl55jbfwm355yxxw152i&ControlID=56545a8d-aaa2-4050-b66e-3a18d3c931d8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&Interval=539000

Request path: /AirForce/Reserved.ReportViewerWebControl.axd

User host address: 127.0.0.1

User: DWPC1\dwdvpr

Is authenticated: True

Authentication Type: Negotiate

Thread account name: DWPC1\ASPNET

Thread information:

Thread ID: 7

Thread account name: DWPC1\ASPNET

Is impersonating: False

Stack trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.GetExecutionInfo()

at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetExecutionInfo()

at Microsoft.Reporting.WebForms.ServerReport.TouchSession()

at Microsoft.Reporting.WebForms.SessionKeepAliveOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)

at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Please help. No specific error message to help me debug. i have no idea what's wrong.

Thanks!

I saw this message quite often before I've tried this approach: before trying to change the report path or HistoryId do the following:
ReportViewer1.ServerReport.ReportPath = "";
ReportViewer1.ServerReport.Refresh();

However, I still get sometimes the message "ASP.NET session expired" or something similar.

report viewer keep showing report is being generated

hi all,

i developed a web app with embedded report viewer to show the reports (server report). everything works alright. i created a setup file to install it at another machine. everything looks ok except that when i want to view the report, it will always show 'Report is being generated' for a very long time when it only takes a few seconds when i view it on report server.

i found the following warning in event viewer (application):

Process information:

Process ID: 4976

Process name: aspnet_wp.exe

Account name: DWPC1\ASPNET

Exception information:

Exception type: SoapException

Exception message: System.Web.Services.Protocols.SoapException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found > Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'icwhpl55jbfwm355yxxw152i' cannot be found

at Microsoft.ReportingServices.WebServer.SessionStarterAction.CreateExisting()

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

End of inner exception stack trace

at Microsoft.ReportingServices.WebServer.ReportExecutionService.GetExecutionInfo(ExecutionInfo& executionInfo)

Request information:

Request URL: http://localhost/AirForce/Reserved.ReportViewerWebControl.axd?ReportSession=icwhpl55jbfwm355yxxw152i&ControlID=56545a8d-aaa2-4050-b66e-3a18d3c931d8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&Interval=539000

Request path: /AirForce/Reserved.ReportViewerWebControl.axd

User host address: 127.0.0.1

User: DWPC1\dwdvpr

Is authenticated: True

Authentication Type: Negotiate

Thread account name: DWPC1\ASPNET

Thread information:

Thread ID: 7

Thread account name: DWPC1\ASPNET

Is impersonating: False

Stack trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.GetExecutionInfo()

at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetExecutionInfo()

at Microsoft.Reporting.WebForms.ServerReport.TouchSession()

at Microsoft.Reporting.WebForms.SessionKeepAliveOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)

at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Please help. No specific error message to help me debug. i have no idea what's wrong.

Thanks!

I saw this message quite often before I've tried this approach: before trying to change the report path or HistoryId do the following:
ReportViewer1.ServerReport.ReportPath = "";
ReportViewer1.ServerReport.Refresh();

However, I still get sometimes the message "ASP.NET session expired" or something similar.sql

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

Hi

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

What version of Report Server are you connecting to? The ReportViewer control is not compatible with SQL Server 2000 Reporting Services. You need the April CTP of Report Server. Your code looks OK otherwise.

Rajeev|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

- fix the ReportService.asmx error with replacing the <assemblies> section in the <system.web> section of the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config file:

<assemblies>
<clear />
<add assembly="ReportingServicesWebServer" />
<add assembly="mscorlib" />
<add assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</assemblies>

Make sure the web.config files for reportserver and reportmanager have full access:
Change the following line in both web.config files:
<trust level="Full" originUrl="" />
Location: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
and: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

the real path to show the report using report manager is as below:
http://localhost/ReportServer/Pages/ReportViewer.aspx?/SampleReport/Report1&rs:Command=Render
Am i need to change the reportpath same as above?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

|||Did you find the solution to the above problem? I am having a similar issue. I add a reportviewer control in my webapp. I am using the ServerReprot and did specify report path etc. When I view the form, I can see the parameter page for the report fine but when I click on View report button, it basically does not do anything.
Thanks|||

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

Except I have read things suggesting the VS05 ReportViewer does not work with SQL 2000 RS. I suppose it seems right to me; I have resorted to a Web Browser control in WinForms as a temp fix to the issue.

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

Hi

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

What version of Report Server are you connecting to? The ReportViewer control is not compatible with SQL Server 2000 Reporting Services. You need the April CTP of Report Server. Your code looks OK otherwise.

Rajeev
|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

- fix the ReportService.asmx error with replacing the <assemblies> section in the <system.web> section of the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config file:

<assemblies>
<clear />
<add assembly="ReportingServicesWebServer" />
<add assembly="mscorlib" />
<add assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Web.Services, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add assembly="System.Web.Mobile, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</assemblies>

Make sure the web.config files for reportserver and reportmanager have full access:
Change the following line in both web.config files:
<trust level="Full" originUrl="" />
Location: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
and: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

the real path to show the report using report manager is as below:
http://localhost/ReportServer/Pages/ReportViewer.aspx?/SampleReport/Report1&rs:Command=Render
Am i need to change the reportpath same as above?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

|||Did you find the solution to the above problem? I am having a similar issue. I add a reportviewer control in my webapp. I am using the ServerReprot and did specify report path etc. When I view the form, I can see the parameter page for the report fine but when I click on View report button, it basically does not do anything.
Thanks
|||

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

Except I have read things suggesting the VS05 ReportViewer does not work with SQL 2000 RS. I suppose it seems right to me; I have resorted to a Web Browser control in WinForms as a temp fix to the issue.

Report Viewer Horizontal Scrollbar

Hi,

Is there a report viewer property that needs to be set to enable the horizontal scroll bar. My reports are being cut off at the end of the iframe. I have several other reports that do show the horizontal scroll bar, but for some reason all my reports in the newly created project do not allow horizontal scrolling. Vertical scrolling is still available.

Thanks

Umer

It seems that the scroll bar appears when I make the width of a subreport wide. This prevents the report from being cut off, but this also mean tat reports that arent as wide will still show a horizontal scroll bar.

So heres a question, how do I specify the width of a report to increase and decrease based on the size of the report.

Lets say I have 5 columns from one set of date, 15 columns from another and 1 column from a third. How can I make sure the horizontal scroll appears in the 5-column and 15 column report and the page is wide enough to accomodate the 15 column report. And that no horizontal scroll bar appears in the 1 column report.

Any help will be greatly appreicated.

Thanks

Umer

Report Viewer Error after Deployment

I have created a report on my local machine and deployed it on a server. As I am the administrator of the server, I can access the reports with servername\Reports. The report has got three data sets. Out of these three one is a Stored procedure and other two data sets have sql queries. The user selects the 'Business year' and 'sales type' from list box. This report works perfect from my local machine as well as from teh server when I am running it

I have some other users who wish to access these reports. I did the following steps:

Created a new role and assigned it at the Data Source Folder and Reports Folder

I also made the user a Database user on the server.

After doing these steps, the user can access the Reports site by servername\Reports.

The user then can go into the Reports folder. But when the user tries to run the report, he gets an error with:

An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for data set 'BusinessYear'. (rsErrorExecutingCommand)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Can anyone help me with this? Is htere something to do with setting up of the datasource?

I have tried to search, but could not find relevant info.

Any help/Pointers will be really appreciated.

regards

Joshker

Hi Joshker,

Can you provide us with the RS Log Files so we can look into the error in more detail......

Potenitally you could have a "datatype" issue wrong with the Business Year....