Skip to Content
0
Former Member
Jun 04, 2008 at 11:32 PM

concurrent users issue with CR .net version

22 Views

<p>

Hi All, I have given brief description below on my issue. I request you to provide your feedback.

</p>

<p>

<strong>Background</strong>

</p>

<p>

We are developing a web application for our US-based client. The web application will be used for internal purposes by the client. I went through the following URLs regarding deploying 'CR for .NET 2005' on IIS6. http://www.businessobjects.com/product/catalog/crystalreports_visualstudio/licensing.asp and http://support.microsoft.com/kb/317789http://support.microsoft.com/kb/317789">http://support.microsoft.com/kb/317789>

</p>

<p>

These URLs state the we don't need to purchase any additional license if the web application is for internal purposes and the number of concurrent users does not exceed 5. However, the concurrent users of our application can be as many as 100. The URLs state that for scalability we may have to upgrade to Crystal Reports (CR) Server XI which supports up to 250 concurrent users.

</p>

<p>

Note that the web site will be installed in a web farm.

</p>

<p>

<strong>Problem </strong>

</p>

<p>

When we contacted Business Objects (BO), they mentioned that CR Server XI supports only 20 concurrent users. More importantly, design and development of reports using CR Server XI is different from CR for .NET.

</p>

<p>

On the other hand, BO has recommended that we go with CR Enterprise Server which will support our need of 100 concurrent users. Again, apparently design and development of reports using CR Enterprise Server is different from CR for .NET.

</p>

<p>

BO has suggested that we go with either CR Server XI or CR Enterprise Server.

</p>

<p>

<strong>Current Design Approach using 'CR for .NET 2005'</strong>

</p>

<p>

UI: User Interface is designed to provide the filter criteria to the user. This layer is designed using asp.net. Each report screen has filter section on the top and one user control at the bottom. Once a user selects the filter criteria and clicks on Show Report button, filter criteria is hidden and report is displayed on the same page.

</p>

<p>

User Control: This has the Crystal Reports Viewer Control in it. It also contains the Business Logic (BL) in its code behind page. The BL will call the appropriate DAL function to fetch the result to be shown in the report.

</p>

<p>

DAL: This layer will execute the corresponding database stored proc and fill the Entity Collection and then return the entity collection to BL.

</p>

<p>

DB: We created SPs for getting the result set to be displayed in the report.

</p>

<p>

Entity: This layer has entity classes for all the reports.

</p>

<p>

<strong>Help Needed</strong>

</p>

<p>

We want to confirm that the design approach explained above will work with CR Server XI and CR Enterprise Server. If not, what changes do we have to make in our code to make it compatible with CR server esp. in a web farm scenario.

</p>

<p>

We also want to know what other options are available to deploy CR on IIS6 that will meet our requirement of 100 concurrent users in a web farm scenario.

</p>

<p>

Thanks, Vidu.

</p>