Reporting Services - Load Balancing + Reports (Crystal Or SSRS)

Sep 27, 2010

We currently have two web servers (Windows Server 2008 Standard, IIS7) setup to host an ASP.Net website and are using the basic features of our hardware firewall to provide network load balancing (NLB) between the two servers. This means we have had to change the ASP.Net session state mode to SQL Server in order to make the data stored in session accessible no matter which server responds to the request. The main issue now is that crystal reports (basic edition packaged with VS2008) do not seem to support serialization which is needed in order to store/transfer the report to session state on SQL Server.

From what I have read so far in order to get crystal reports working in a web farm environment it seems the only option is to upgrade to Crystal Reports Server and load the reports from a third server. Another option may be to use SQL Server Reporting Services (SSRS) as we already have this so no extra cost involved, however I'm not sure if SSRS would resolve the issue with storing reports in session?

View 1 Replies


Similar Messages:

SQL Reporting :: Differences Between Ssrs Reports And Crystal Reports?

Oct 20, 2010

differences between ssrs reports and crystal reports?

View 2 Replies

SQL Reporting :: SSRS Reporting Services When Expanding A Drill Down Row - It Becomes Very Long

Aug 9, 2010

I have created a drill down report in SSRS which works fine in Visual studio but when deployed and viewed using a report viewer on an asp.net web page it acts funny. It load fine the first time but as soon as i expand any of the drill downs the width of the report suddenly becomes very! lengthy and the details data disappears.

View 2 Replies

C# - How To Export Into Word Format Using Reporting Services (SSRS)

Apr 26, 2010

Using Reporting services in SQL Server 2005 in asp.net with c#, how can we export reports in word document?

View 2 Replies

SQL Reporting :: Error While Rendering Reports (Reporting Services 2005) In .Net 1.1 Web Application On IIS 6.0

Sep 30, 2010

I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.

View 1 Replies

SQL Reporting :: Make SSRS Reports Available Through ReportViewer

Dec 29, 2010

I have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.

1) Set up new user? What permissions are required?
2) Configure SSRS to for external connections?
3) Firewall?

View 2 Replies

SQL Reporting :: Public Access To SSRS Reports?

Sep 21, 2010

I'm designing some reports to summarize recently compiled research findings. These reports are going to be posted on an ASP.NET page (via the report control) on the web site. I do not want to authenticate users, as the findings are meant to be public and requiring users to register and authenticate would add a barrier and is likely to decrease traffic.I've seen similar posts where reports are meant to be viewed by everyone on an intranet and permissions could be set using a designated workgroup. I need alternative solutions to the problem of making a report viewable by everyone who visits a site. I'm also currently unfamiliar with Kerberos (and I know that will probably pop up as a potential solution), so if there's a convenient way outside of that it would be great.

View 3 Replies

SQL Reporting :: Move RDLC Reports To SSRS?

Mar 7, 2011

I am using VWD 2008 with VB.Net code-behind. I have multiple parameterized RDLC reports that use tableadapters in a .xsd dataset that I use a reportviewer to view / export the PDF reports.

Lately, we have noticed that the reportviewer is causing many errors on our webserver and sometimes causing the webserver to crash. It has been recommended to me to move the RDLC reports to SSRS, which we also have up and running on another server.

My question is how do I do this? Do I have to convert them to RDL files? What about the fields on the .aspx pages that supply the parameters? Also, what do I do with the tableadapters?

We want to not use the reportviewer but still have the capability to retrieve the RDLC reports in PDF format.

View 3 Replies

SQL Reporting :: Use The ReportViewer To Display SSRS Reports?

Mar 26, 2010

Starting to look into an web app thet uses the ReportViewer to display SSRS reports. This is for SSRS 2008. What would be the best way to go about the follwoing: The reports are sales reports so only ceratin people will get to see certain reports.

1: If a user opens a report which they can see and that report has a subreport which they can't, will the subreport still be viewable?

2: If the webapp will be used by many different people internally and eventually by outside people, what is the best security startegy to use, just plain ServerReportCredentials passing, or something else?

View 1 Replies

SQL Reporting :: Changing The Background Color Of SSRS Reports?

Oct 26, 2010

1> "change the color of the background of report to the RGB (240, 240, 240)" and

2>change the background of the legend to "white" i am able to do the second requirement

View 4 Replies

SQL Reporting :: How To Integrate SSRS Reports To Sharepoint 2010

Nov 12, 2010

We have to integrate an SSRS report in sharepoint.When we will click on the report it should open in a custom aspx page and not under Report viewer.

View 1 Replies

SQL Reporting :: SSRS 2005 Error After Uploading New Reports?

Oct 4, 2010

I have been developing reports using BIDS 2005 and deploying them to a report server on my development machine.

These reports can be called succesfully from both the report manager and my asp.net website.Everything has been working fine.

Some time back some early versions of the reports were deployed to a test server in order that they could be tested away from the development machine. The reports processed successfully.Today I have uploaded a number of completed reports (using Report Manager) to the test server and am getting an error message for each one when I try to run it direct from Report Manager.

The message is: "An error has occurred during report processing Common Language Rutime detected an invalid program"

I've been trying to resolve this for a few hours now and am getting nowhere. Google has thrown up some finds on the error message but these seem to refer to people having issues with the compilation of large methods or forms with a very high number of controls.I can't see this being appropriate because most of the reports are relatively simple and the most complex probably has only 100 different controls.

View 1 Replies

Crystal Reports :: VS2008 Crystal Reports - "Load Report Failed - Error"?

Jul 25, 2010

I'm getting the "Load Report Failed" Error.

I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.

My development system is WinXp and my deployment system is Win2003 Server.

Here is what i have done -

1) Added a Crystal Report to my project "rptReport.rpt"

2) Added a Crystal Report Source (crSource) to my .aspx page.

3) Added Crystal Report Viewer to my page, with crSource as its Report Source.

This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine.
This is what i have already tried doing on deployment server:

1) Giving IIS_WPG full control to temp folder.

2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.

View 1 Replies

Crystal Reports :: How To Create SSRS Business Report Using Parameters

Dec 30, 2013

How to create ssrs with parameter in asp.net with c# using sql ....

View 1 Replies

SQL Reporting :: Ssrs 2008 Reports Datasource Error In Test Server?

Oct 18, 2010

i Have upgraded my Reports from Report server VS 2005 to VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

When i deployed to Test server i am trying to access my reports i am getting below errors,

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server, it doesn't works in srs 2008 test server.

View 1 Replies

Crystal Reports :: Error In Crystal Report For Load File Or Assembly?

Mar 19, 2011

i upload my site on server but there is error in crystal report web.comfig there is error as belowParser Error Message:Could not load file or assembly 'CrystalDecisions.ReportAppServer.ClientDoc, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

[Code]....

View 2 Replies

SQL Reporting :: Deploy The Reports Into Report Server With Out Using Web Services From .Net?

Jan 8, 2010

how can we deploy the reports into report server with out using web services from .Net. Is it possible.I need to set the reportserver url at runtime(using an XML file eg: http://localhost/reportserver). Can we do this in your solution?

View 1 Replies

C# - Producing A Form From An Overlay From Reporting Services Rdlc Reports

May 25, 2010

I am not sure what you call it in other technologies, on the IBM i (or iSeries) we call it overlays. The overlay is an image of a form that is stored on the server then a program generates the form with fields from the database so you can eliminate preprinted forms.

I had a problem last year with the method I was trying at the time. It was a rush job at the time to be revisited at a later point. The work-around at the time was to export to PDF. So now it is "later" and once again is a rush (imagine that). This is all done through a web-based interface.

So how do you generate forms from something that was once a preprinted form? What method do you recommend? This is a legal form and must be filled out a certain way and can have many in a batch (up to 50 or so). I would prefer to not have them print one page at a time.

View 1 Replies

Crystal Reports :: Either The Crystal Reports Registry Key Permissions Are Insufficient Or The Crystal Reports Runti?

Aug 5, 2010

When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.

View 2 Replies

Data Controls :: Why GridView Is Preferred Over Crystal Reports For Reporting

Dec 12, 2012

Why we are mostly use gridview not prefer crystal report for displaying report.

View 1 Replies

Crystal Reports :: Getting Error On Page Load

Oct 28, 2010

I'm trying to load up my website but I keep getting this error on page loads:

Server Error in '/' Application.

Configuration Error

Description:
An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

Source Error:

[Code]....

Line 17: <compilation targetFramework="4.0">
Line 18: <assemblies>
Line 19: <add assembly="CrystalDecisions.CrystalReports.Engine, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 20: <add assembly="CrystalDecisions.ReportSource, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
Line 21: <add assembly="CrystalDecisions.Shared, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>

View 1 Replies

Crystal Reports :: Could Not Load File Or Assembly

May 7, 2015

I have created a web application with crystal report and it is working fine. But when I am hosting my application it is throwing following exception.

Could not load file or assembly 'CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

View 1 Replies

SQL Reporting :: Convert .rdl Files From Ssrs 2000 To Ssrs 2005?

Nov 10, 2010

I have a number of .rdl SSRS 2000 files that I want to convert to SSRS 2005 .rdl files.

I have installed BIDS 2005 and have opened the project in BIDS 2005.

When i open any file individually I get about 200 error messages.

Does anyone know what I need to do to convert the .rdl files to SSRS 2005?

View 2 Replies

Installation :: Loading Balancing For Web Services Does Not Work?

Apr 27, 2010

I have the asp.net project which will access the web services (C#, mainly connection to database) in another computer which is running load balancing.

But the project always return "Underlying connection is closed!!".

View 6 Replies

SQL Reporting :: Print SSRS Report I Got The Message: Unable To Load Client Print Control?

Mar 25, 2011

When I try to print SSRS report I got the message: Unable to load client print control.

I am using report viewer to view the report

My ASP.Net application is running on a server.

My MS SQL server is running on a separate server

My Report server is running a separate server

I tried installing the report viewer patch from [URL] and installed the same on all the three servers ... and have restarted too!

It is not working on production environment and the same is working in development environment

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved