This is a migrated thread and some comments may be shown as answers.

n-Tier Parameterized Reporting Web Application

1 Answer 371 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Aniket Braganza
Top achievements
Rank 2
Aniket Braganza asked on 16 Nov 2008, 09:16 PM

Requirements

RadControls version

Q3 2008
.NET version

3.5 SP1
Visual Studio version

2008 SP1
programming language

ASP.NET, C#
browser support

all browsers supported by RadControls


PROJECT DESCRIPTION
I have created a project to demonstrate how to have a n-Tier hierarchy (data layer, class library, web app) and use the Telerik Reports. This demo allows the user to pass in a parameter to the constructor of the report, which can then be used to retrieve data from the backend database. Currently the dataset is created manually for demo purposes but this could be extended easily to bring back data from SQL server. Also this demo illustrates the use of a SQL Server Session state and a unique Machine key for your web app. To use this functionality you need to run aspnet_regsql.exe against your database to generate the necessary tables for asp.net to use a database backend for credentials and session state.

the 3 relevant lines of code to change in the web.config (excluding the addition of a connection string entry, are

<sessionState mode="SQLServer" allowCustomSqlDatabase="true" sqlConnectionString="ADD YOUR SQL CONNECTIONSTRING HERE" cookieless="UseCookies" timeout="60" regenerateExpiredSessionId="true"/> 
... 
<machineKey validationKey="ADD YOUR VALIDATION KEY HERE" decryptionKey="ADD YOUR DECRYPTION KEY HERE" validation="SHA1"/> 
... 
<authentication mode="Forms"
</authentication> 
 


Hope this helps someone as it took me a while to get this working the way I wanted it to.

Aniket

1 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 20 Nov 2008, 03:34 PM
Hi Aniket,

We believe that the provided project is not an unique solution and therefore is not suitable for the code library section. However it might be a good starting point for other community members and that is why we have transferred it into a forum thread.

Thank you for the involvement - your Telerik points have been updated for providing this project to our community.

All the best,
Steve
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
General Discussions
Asked by
Aniket Braganza
Top achievements
Rank 2
Answers by
Steve
Telerik team
Share this question
or