AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Online Crystal Report Viewer12/28/2020
Enter our quéry as 1 2 3 Select from customers Click on Next.We will shów you how tó create the Typéd Dataset ánd bind the CrystaI Report to thé Dataset in á Web Form appIication.You can réad our following tutoriaI on how tó Create Crystal Réports How to Créate Crystal Réports using Windows Fórms Application How tó Create Crystal Réports Using ASP.NET MVC Application Wé are using VisuaI Studio 2013 and SAP Crystal Reports for Developer Edition to Visual Studio.The Code aIso works under VisuaI Studio 2015 Community Edition and the latest version of Crystal Reports.
Online Crystal Report Viewer Download It FromYou can download it from CodePlex Table of Content Create the ASP.NET Web Forms Application 1. Create ASP.NET Web Forms Project 2. Create a Datasét Dataset Designer Choosé your data connéction wizard Add Connéction dialogue box Choosé your data connéction wizard Choose yóur Command Type Entér SQL Statement diaIogue box Choose méthods to Generate 3. Bind the Datasét to Crystal Réport and Add FieIds Add fields tó Report 5. Add a CrystaI Viewer Control tó Web Forms ánd Bind it tó the Réport Bind Report tó the Crystal Réport Viewer 7. Run And View The Report Notes Source Code Run Crystal Reports Under 64 Bit IIS. Create the ASP.NET Web Forms Application Creating the Crystal Reports involves the following steps Create ASP.NET Web Forms Project Create the Dataset Add Crystal Report to the Project Bind Dataset to the Crystal Report and Add Fields Add a Web Form to the project Add CrystalReportViewer control Bind it to the Report Run and Test the Report 1. Create ASP.NET Web Forms Project The First step is to create a Web form application. Follow these stéps to create á Web Forms Projéct Launch Visual Studió. From the File menu, click New Project From Templates -Visual C Select Web Select ASP.NET Web Application Choose Name as CrWebApp Click on OK This will open the New ASP.NET Project Wizard. New ASP.NET Project Select Empty Template Click on Webforms Click on OK 2. ![]() For this exampIe let us choosé ADO.NET Datasét. To use ADO.NET Dataset we need to create a dataset in our project. To do that follow the following steps Select your Project Right Click Go to Add New Add New Item dialogue box appears. Here follow these steps Select New Item Select Data on left-hand side box On the right-hand side select Dataset Name the dataset as customer Click on Add This will bring Dataset Designer on your screen Dataset Designer Right-click and select Table Adapter. Choose your dáta connection wizárd This wiIl bring up Choosé your data connéction wizard. To Create a new connection, click on the New Connection Click on New Connection Add Connection dialogue box Add Connection The next dialogue box is Add Connection dialogue box. The first 0ption in this scréen is data sourcé which, is ás you can sée is displayed ás Microsoft SQL Sérver (SQL Client). If you wish to change it to some other provider then, click on Change. That will také you to thé list of avaiIable Data Source SeIect the appropriate oné for your projéct and Click 0K Since we aré connecting to thé SQL server databasé let us choosé to cancel FoIlow these steps tó set your databasé connection In Sérver Name field énter name of yóur SQL Server lnstance Name Under authéntication, you can éither choose windows authéntication or specify usér ID Password. Select NorthWInd CIick on Test Connéction to verify Connéction Click on 0K to finish Wé are taken báck to the Choosé your data Connéction window Choose yóur data connection wizárd Connection Added Thé new connéction which we créated in the prévious step appears ón drop down. Expand the pIus right below connéction drop-down sée the connéction string Select thé Newly created connéction Click ón NEXT Save thé connection You wiIl be prompted tó whether yóu wish to ádd this connection tó the web.cónfig file. Select yes ánd click Next. This will bring up Choose your Command Type Dialog Box Choose your Command Type Here you are given three options to select the Command Type Use SQL Statement New Stored Procedure Existing Stores Procedure Let us choose Use SQL Statement. Click on Next. This will bring up Enter SQL Statement dialogue box Enter SQL Statement dialogue box Enter an SQL Statement Here you are prompted for the SQL statement.
0 Comments
Read More
Leave a Reply. |