Crystal Reports Engine 10' title='Crystal Reports Engine 10' />How to use Crystal Reports in ASP. NET using CWe will first download SAP Crystal Reports from the source and install it on our system, then using some simple code we will proceed. Initial chamber. First we need to download the SAP Crystal Reports for respective IDEs of Visual Studio as in the following Step 1. Open Your Visual Studio 2. Empty Website, provide a suitable name crystalrptdemo. Step 2. In Solution Explorer you get your empty website and then add a Web Form and SQL Server Database and Dataset as in the following For Web Formcrystalrptdemo your empty website then right click then select Add New Item Web Form. Name it crystalrptdemo. Crystal Reports Engine 10' title='Crystal Reports Engine 10' />Crystal Reports is a report writer that operates as a standalone report designer, an integrated part of Visual Studio, or part of SAPs Business Objects Enterprise. Tracks the Usage Share of Search Engines, Browsers and Operating Systems including Mobile from over 10 billion monthly page views. The SAP Community is the quickest way for users to solve problems, learn more about SAP solutions, and invent new ways to get things done. In this article Ill show you how to make and use a report using Crystal Reports in ASP. NET using C. Explains how to use Crystal Reports in ASP. NET Web aplication. The CSB issues safety recommendations to prevent the recurrence or reduce the likelihood or consequences of similar incidents or hazards in the future. For SQL Server Databasecrystalrptdemo your empty website then right click then right click then seelct. Add New Item SQL Server Database. Add the database inside the AppDatafolder. For Data. Setcrystalrptdemo your empty website then right click then right click then seelct Add New Item Data. Crystal Reports Engine 10' title='Crystal Reports Engine 10' />Set add the Data. Set inside the AppCodefolder. Database chamber. Step 3. In Server Explorer, click on your database Database. Tables Add New Table then make the table like this Table tbldata Dont forget to make ID as IS Identity True. Insert some data into your table by going to your table tbldata then right click then select Show tbldata Add data in the table. Stored Procedure spselect Double click on the dataset that is resides under the AppcodeFolder, see the following Image. When you double click the dataset you get the blank area, there you need to do something like the following. Right click on the blank area then seelct Add Datatable. Change the name of the table from Datatable. Newtbldata. There you must add 3 columns for ID, Name and City as we did in tbldata, so add the three columns. You will get something as in the following image. You must then go to crystalrptdemo then right click then select Add New Item Find Crystal Report. When you add this new Crystal Report Gallery opened there you need to do as in the following image. The following is my Employee Table, of which the data I will show as a report in ASP. NET using Crystal Reports. You will have something like this When your Crystal Reports report is opened as in the preceding image, you will find in the left or right dock Field Explorer is opened. Right click on Field Explorer then select Database Expert Create New Connection. You will need to find the table that we made in the Dataset, Newtbldata. Once you have your table, add that table to the right side pane using the button then press OK as in the following image. You will get you Newtbldata in Field Explorer like this. Here you must add these ID, Name and City from Database Fields to the Crystal Reports report, Section 3 Page Details. You can drag these fields to the Crystal Report Page Details. Design chamber. Step 4. Now open your crystalrptdemo. Crystal Reports. We will add a Crystal Reports Viewer here. Go to the toolbox and find Reporting then Drag and Drop a Crystal Reports Viewer. Page LanguageC Auto. Event. Wireuptrue Code. FileDefault. aspx. InheritsDefault     lt  Register assemblyCrystal. Decisions. Web, Version1. Cultureneutral, Public. Key. Token6. 92fbea. Crystal. Decisions. Web tagprefixCR     lt DOCTYPE html PUBLIC  W3. CDTD XHTML 1. 0 TransitionalEN http www. TRxhtml. 1DTDxhtml. CR Crystal. Report. Viewer IDCrystal. Report. Viewer. 1 runatserver               Auto. Data. Bindtrue             lt div      lt form  lt body  lt html  Code chamber. Step 5. Open your crystalrptdemo. Add some namespaces to the crystalrptdemo. System  using System. Collections. Generic  using System. Linq  using System. Web  using System. Web. UI  using System. Web. UI. Web. Controls  using System. Data  using Crystal. Decisions. Crystal. Reports. Engine  using System. Data. Sql. Client    public partial class Default  System. Web. UI. Page        Report. Document rprt  new Report. Document            protected void PageLoadobject sender, Event. Args e                rprt. LoadServer. Map. PathCrystal. Report. Sql. Connection con  new Sql. ConnectionData Source. SQLEXPRESS Attach. Db. FilenameData. DirectoryDatabase. Integrated SecurityTrue User InstanceTrue          Sql. Command cmd  new Sql. Commandspselect, con          Sql. Data. Adapter sda  new Sql. Data. Adaptercmd          Data. Set ds  new Data. Set          sda. Fillds, Newtbldata          rprt. Set. Data. Sourceds          Crystal. Report. Viewer. 1. Canoscan Lide 100 Software For Windows 7. Report. Source  rprt                                  Output chamber. I hope you like this. Thank you for reading. Custom color palette BI 4. Do you need a custom color palette for SAP Business. Objects BI 4. 0 Web. Intelligence, Analysis or Crystal ReportsThere are options available in the software to choose a custom color palette, but when you want to use your own custom color palette, its not possible in the frontend tooling. In XI 3. 1 we could work around that by changing the XML files so default a different color was used. In SAP Business. Objects BI 4. Web. Intelligence, Analysis and Crystal Reports. So if you need a house style for your reports, follow the next steps. Your administrator needs to go to the following directory on the server side C Program Files x. SAP Business. ObjectsSAP Business. Objects Enterprise XI 4. Find the file there named as Visualization. Config. template. Rename this file to Visualization. Config. xml. 4. Then edit this file and add the color for the palette as you required RGB colors are used5. Check there are no errors in the config file, otherwise the standard palette is applied you can define only one Corporate palette, and the palette ID must not be changed. Finally, you need to reboot Tomcat after editing the config file. Hope this helps to create your own color palette for Web. Intelligence, Analysis or Crystal Reports. I was able to create my own custom color palette with SAP BO BI 4. Service. Pack 4 Patch level 4. I dont know if earlier version are supported.