http://aspalliance.com/ Recent articles on AspAlliance.com. This article will show you how to use LINQ to retrieve your data and then "hook" it to a Crystal Report. http://aspalliance.com/2049_Use_LINQ_to_Retrieve_Data_for_Your_Crystal_Reports Vince Varallo Tue, 15 Mar 2011 00:00:00 GMT This article delves into the new methods exposed in Crystal Reports new WPF Viewer. These methods include the ReportDocument.BeforeFormatPage Event, the ReportRequestStatus.NumberOfPages, and more. http://aspalliance.com/2037_Exploration_of_New_Methods_in_Crystal_Reports_WPF_Viewer Eric Landes Tue, 04 Jan 2011 00:00:00 GMT This article demonstrates the Group Expert and Hierarchical Grouping options using Crystal reports with the help of an ASP.NET web site that displays data from the AdventureWorks sample database. After a short introduction, Vince examines the creation of a new solution and report using simple grouping with relevant source code examples and screenshots. http://aspalliance.com/1994_Using_the_Group_Expert_and_Hierarchical_Grouping_in_SAP_Crystal_Reports_for_Visual_Studio_2010 Vince Varallo Tue, 26 Oct 2010 00:00:00 GMT SAP/Crystal Reports is introducing the new free WPF viewer to use Crystal reports with Visual Studio. In this article, Eric tells us what's new with this new tool. After a short introduction, he examines the new features of the API and the installation process. He also provides a detailed coverage of the creation of a new Reporting Application with the WPF viewer with the help of relevant screenshots. http://aspalliance.com/1990_Introducing_the_Crystal_Reports_Visual_Studio_2010_WPF_viewer Eric Landes Tue, 28 Sep 2010 00:00:00 GMT In this article, Vince demonstrates the usage of the new WPF Viewer that comes with SAP Crystal Reports for Visual Studio 2010. Vince goes over basic functionalities such as how to create a new solution, how to display data in a DataGrid control using the Entity Framework, how to create a crystal report and display data in it. Throughout the article Vince provides relevant source code examples and screenshots. http://aspalliance.com/1991_Using_the_New_WPF_Viewer_with_SAP_Crystal_Reports_for_Visual_Studio_2010 Vince Varallo Tue, 21 Sep 2010 00:00:00 GMT This article will review some of the new features of SAP Crystal Reports for Visual Studio 2010 and build a sample application using ASP.NET and SQL Server 2008. http://aspalliance.com/1980_A_look_at_SAP_Crystal_Reports_for_Visual_Studio_2010 Vince Varallo Tue, 20 Jul 2010 00:00:00 GMT Like with most things, Crystal Reports tends to be split into levels of complexity whenever possible. Beginner, Intermediate, Advanced are all used to describe books, courses and articles. The problem is that reporting requirements are dictated by the client and by the nature of the database being reported from. In many cases the initial request may seem simple to implement, but may not be a good logical fit with how the database stores the information. http://aspalliance.com/1949_Crystal_Reports_Optional_Table_Linking_and_the_Importance_of_Order Jason Dove Tue, 22 Jun 2010 00:00:00 GMT In this article, Vince examines the creation of an ASP.NET web application that uses the CrystalReportPartsViewer Control to create a drill through report where the user can view summary level data and click on a hyperlink to drill into the details. http://aspalliance.com/1947_Using_Crystal_Reports_and_ASPNET_to_Create_Drill_through_Reports_and_Graphs Vince Varallo Tue, 08 Jun 2010 00:00:00 GMT I hate sub reports and always consider them the last resort in any reporting solution. The negative effect on performance and maintainability is just not worth the easy ride they give the report writer. Nine times out of ten reporting requirements can be met using a little forethought and planning (and a solid understanding of formulas). With that said, there are a few novel ways of using sub reports which will not affect performance and actually prove a boon to the developer. http://aspalliance.com/1927_Crystal_Reports_3_New_Uses_For_Sub_Reports_ Jason Dove Tue, 11 May 2010 00:00:00 GMT This article demonstrates how to create formulas in a Crystal Report and use the Crystal scripting language to create variables, use built in functions, perform conditional logic, and manipulate dates. After a brief introduction, the article provides the steps required to create the database, the website, and the report, including how to add fields and formulas to the report. Near the end, the article examines the steps required to create formulas with variables. http://aspalliance.com/1940_Using_Variables_Within_Crystal_Report_Formulas Vince Varallo Tue, 27 Apr 2010 00:00:00 GMT Have you ever had to create a custom report within an application you have written for a customer? Most developers have, and there are two schools of thought on how developers normally perform this task. Some choose to create the report using the same technology that the application was created in (ASP, WinFrom, WPF) while others choose to use a reporting package such as Crystal Reports. Using a reporting package will help create reports rapidly. This article walk you through the creation of your first report using Crystal Reports. http://aspalliance.com/1920_Creating_your_First_Crystal_Report_for_Use_in_a_NET_Application Jeff McWherter Tue, 16 Mar 2010 00:00:00 GMT Your masterpiece report is now complete. It doesn't just meet your customer’s expectations, it blows them out of the water. All they want is a beautifully-summarized report that can be displayed in a myriad of ways. Then disaster strikes! You try to run the report for a month against the live database and not the two days worth of test data you used for development, then your report’s runtime goes from twenty seconds to two hours. Every Crystal Reports developer has experienced this situation and it can be one of the most frustrating aspects of report design. Thankfully there are a variety of things that can be done to combat bad performance, any one of which can reap huge benefits... http://aspalliance.com/1918_Crystal_Reports_5_Tests_for_Top_Performance Jason Dove Tue, 02 Mar 2010 00:00:00 GMT Once a report library grows to a certain size there are always going to be common formulas which are needed repeatedly. Having easier access to them can save a lot of development time. http://aspalliance.com/1921_Crystal_Reports_Save_Time_with_Formula_Sharing_ Jason Dove Tue, 23 Feb 2010 00:00:00 GMT In this article, Vince demonstrates the creation of a Windows Service to automatically run and send a Crystal Report as an email attachment. After a basic introduction, he examines the creation of the database and windows service with the help of relevant source code and explanations. Towards the end of the article, Vince discusses the steps to be followed in order to install the windows service. http://aspalliance.com/1917_Automate_delivery_of_Crystal_Reports_With_a_Windows_Service Vince Varallo Tue, 16 Feb 2010 00:00:00 GMT In this article, Vince examines the creation of a report that connects to two databases but displays the data on one report with he help of relevant screenshots and source code. Sub reports embed one report inside another while linking on a common field. They can be useful when you need to report data from more than one data source or when you need to run separate and distinct queries to retrieve data on a report. http://aspalliance.com/1907_Building_Reports_using_ASPNET_and_Crystal_Reports__Part_7_Using_Subreports_to_Create_Advanced_Reports Vince Varallo Tue, 15 Dec 2009 00:00:00 GMT In this sixth part of the series, Vince examines the creation of a sales forecast crystal report based on the AdventureWorks database in a series of steps. He initially provides a brief outline of creating a new solution in Visual Studio 2008 and database connectivity and then demonstrates the usage of parameter fields and formula fields in addition to building an ASP.NET web page to execute and preview the report with the help of example screenshots and code snippets. http://aspalliance.com/1892_Building_Reports_Using_ASPNET_and_Crystal_Reports__Part_6__Build_a_Sales_Forecast_Report_Using_Parameter_Fields Vince Varallo Mon, 09 Nov 2009 00:00:00 GMT In this second part of the series, Eric examines the usage of caching in Crystal Reports. He makes use of Visual Studio Team System testing to compare performance between cached and non-cached pages. After providing a short introduction and outlining the system requirements, he examines the test strategy in detail and provides a comprehensive coverage of both the NonCached and Cached loads with a detailed analysis of the results with the help of screen shots and source codes. http://aspalliance.com/1893_Load_Testing_Crystal_Reports_with_High_Shareability_Caching Eric Landes Thu, 29 Oct 2009 00:00:00 GMT In this article, Vince walks the user through the process of creating a Crystal Report as a web service and then creating a web site to consume the service. After providing a short introduction, he examines the relevant steps which includes the creation of a web service, adding crystal reports file, and establishing database connectivity using Visual Studio 2008. Towards the end of the article, he examines the creation of a web site with the help of relevant source code and screenshots. http://aspalliance.com/1883_Building_Reports_using_ASPNET_and_Crystal_Reports__Part_5__Creating_Reports_as_a_Web_Service Vince Varallo Mon, 28 Sep 2009 00:00:00 GMT In this fourth part of the series, Vince Varallo examines the creation of an employee report and demonstrates the usage of Crystal Reports object model to change the grouping fields and manipulate the properties of the group at runtime to show or hide sections, reset the page number, or insert a page break using Visual Studio 2008. He provides a step-by-step analysis of each procedure with the help of relevant screen shots and source code. http://aspalliance.com/1874_Building_Reports_Using_ASPNET_and_Crystal_Reports__Part_4_Dynamic_Grouping Vince Varallo Tue, 18 Aug 2009 00:00:00 GMT In this third part of the series, Varallo shows how to rebuild the Invoice created in Part 1 using disconnected datasets instead of connecting directly to the database. This gives the user the flexibility to manipulate the data and implement rules in a c# business class rather than in the report. He provides a detailed overview of each concept in a step-by-step manner supported with screen shots and source code. http://aspalliance.com/1866_Building_Reports_using_ASPNET_and_Crystal_Reports__Part_3__An_Invoice_Report_Using_Disconnected_Data Vince Varallo Mon, 20 Jul 2009 00:00:00 GMT We have come across a situation where we have to generate the report from more then 2 queries using crystal reports. All queries are different -- 2 transaction tables with relevant joins from dimension tables. So to make the report we have to create 2 different connections from the universe and it eventually gave performance problems when dealing with a large sets of records. In this case, we have to link each query with the others on the basis of common dimensions. While fetching a report with a large amount of data, it takes a lot of time to complete. http://aspalliance.com/1861_How_to_handle_multiple_queries_simultaneously_in_Crystal_reports_connecting_from_Business_object_Universe Umesh Bansal Wed, 24 Jun 2009 00:00:00 GMT In this second part of the series, Vince examines the creation of a quarterly sales report with the help of Crystal Reports by using the Adventure Works sample database. He provides detailed coverage of each step including the concept of cross tab reports and date manipulation with the help of relevant screen shots and source code. The article also demonstrates the usage of the Crystal Report Viewer and the Object Model to view the report as a PDF using ASP.NET. http://aspalliance.com/1851_Building_Reports_Using_ASPNET_and_Crystal_Reports__Part_2__Quarterly_Sales_Report Vince Varallo Mon, 15 Jun 2009 00:00:00 GMT In this video Mohammad Azam demonstrates how to pass parameters to Crystal Reports programmatically. [5:58] http://aspalliance.com/1843_Video_Passing_Parameters_to_Crystal_Reports_Programmatically_ Mohammad Azam Mon, 18 May 2009 00:00:00 GMT Often times, when developers think about Crystal Reports, they think about a stand-alone designer and reports running in a sandbox. This is a common misconception and often leads to logic placed on reports that should have been handled in code. In this article Jeff discusses the basics of the Report Document Model and Report View Model with the help of comprehensive explanations and screen shots. http://aspalliance.com/1837_Understanding_the_Crystal_Reports_Object_Model Jeff McWherter Mon, 11 May 2009 00:00:00 GMT In this video Mohammad Azam demonstrates how to create parameter fields in Crystal Reports. Mohammad demonstrates this feature using the design time wizard available in Visual Studio. [7:23] http://aspalliance.com/1839_Video_Creating_Parameter_Fields_in_Crystal_Reports Mohammad Azam Mon, 04 May 2009 00:00:00 GMT Did you know that Crystal Reports ships with functionality to render geographic data? In recent years the ability to create reports that visually interpret data has become an easy task, and more businesses are asking for more complex functionality, such as reporting on geographic data. This article introduces the Crystal Reporting mapping basics, then goes beyond and introduces a way to use third party mapping controls. http://aspalliance.com/1838_Geographic_Data_with_Crystal_Reports Jeff McWherter Fri, 01 May 2009 00:00:00 GMT In this article Mohammad Azam demonstrates the usage of ParameterField in Crystal Reports to manipulate reports at runtime. He examines the concept in a step-by-step manner with a comprehensive explanation and supporting screen shots. http://aspalliance.com/1833_Creating_Parameter_Fields_in_Crystal_Reports Mohammad Azam Mon, 27 Apr 2009 00:00:00 GMT We all know that what managers like best about reports are the colorful charts. The data presented could mean that the company is struggling for sales, but hey, it is presented in a fancy chart. This article introduces the Crystal Reporting charting basics, and then goes beyond and introduces a way to use third party charting controls. http://aspalliance.com/1834_Crystal_Reports_Charting_Fundamentals Jeff McWherter Wed, 22 Apr 2009 00:00:00 GMT In this first part of the series, Vince examines the creation of an invoice with the help of Crystal Reports by using the Adventure Works sample database. He provides detailed coverage of each step including the concept of header and detail records and one to many relationships with the help of relevant screen shots and source code. The article also demonstrates the usage of the Crystal Report Viewer and the Object Model to view the report as a PDF using ASP.NET. http://aspalliance.com/1831_Building_an_Invoice_Application_with_ASPNET_and_Crystal_Reports__Part_1 Vince Varallo Tue, 21 Apr 2009 00:00:00 GMT In this article, Eric tests the out of the box caching capability of Crystal Reports. Using the testing component of Visual Studio, Eric shows load test results from a Crystal Reports test suite. http://aspalliance.com/1825_Load_Testing_Crystal_Reports_Caching_Features Eric Landes Mon, 23 Mar 2009 00:00:00 GMT I do not have any artistic talent; I am a developer. How many times have you heard this before? Perhaps it was you that made this statement. Today's GUI development demands a certain sense of style that many developers lack. In this article, Jeff covers tools and basic tips to aid an artistically challenged developer in creating Crystal Reports that are professional and usable with the help of detailed explanations followed by relevant screen shots. Towards the end of the article, he examines a few design specifics such as Margins, Templates, and Dynamic Images. http://aspalliance.com/1787_Designing_Crystal_Reports_for_Users Jeff McWherter Mon, 22 Dec 2008 00:00:00 GMT Eric continues the series on how to format your Crystal reports programmatically. This can be very helpful when deploying the same reports for different customers who want a different look. He demonstrates the different formatting methods, such as custom formatting a WinForm application, and also that of Crystal objects with the help of relevant source code. http://aspalliance.com/1734_How_to_Change_Crystal_Report_Formatting_for_Different_Customers__Part_2 Eric Landes Fri, 03 Oct 2008 00:00:00 GMT Moving reports in a sizable application from Crystal Reports for Visual Studio 2005 to Crystal Reports 2008 can be a frustrating transition. This article provides guidance based on the lessons the author has learned from her development experience. After providing a brief history and comparison of different versions of Crystal Reports, she examines the development of applications using Crystal Reports under Windows Vista 64 bit and gives some tips to avoid potential problems along with a brief outline of Redistribution of Reports. http://aspalliance.com/1744_Lessons_Learned_Sorting_out_Crystal_Reports_2008_Versioning_Service_Packs_and_Deployment Julia Lerman Wed, 24 Sep 2008 00:00:00 GMT In this article, Eric shows us how to give the same report a different style for your different customers with minimal involvement from the developer. After providing a brief overview and requirements specification, he outlines the formatting options with the help of source code and screenshots. Toward the end of the article, Eric demonstrates how to set different styles for your application and also provides the relevant project which you can download and work on. http://aspalliance.com/1713_How_to_Change_Crystal_Report_Formatting_for_Different_Customers__Part_1 Eric Landes Thu, 21 Aug 2008 00:00:00 GMT This article demonstrates the creation of sub-reports using Crystal Reports. After providing a short overview of the database design, the author delves deeper into the report building process in a series of steps with associated screenshots. Towards the end of the article, he shows us how to display the report on a web page. http://aspalliance.com/1673_Creating_SubReports_Using_Crystal_Reports Mohammad Azam Fri, 11 Jul 2008 00:00:00 GMT Many times beginning Crystal Reports authors overlook the powerful feature of cross tabs, in this article we discuss the basics of creating and formatting cross tabulations in Crystal Reports 2008. http://aspalliance.com/1689_Cross_Tab_Craziness_in_Crystal_Reports Jeff McWherter Tue, 08 Jul 2008 00:00:00 GMT In this video, Mohammad Azam demonstrates how to create sub-reports in crystal reports. He walks you through the steps required to display hierarchical data using crystal reports. [8:40] http://aspalliance.com/1675_Video_Creating_SubReports_Using_Crystal_Reports Mohammad Azam Mon, 23 Jun 2008 00:00:00 GMT In the second part of this series, Eric shows how to automatically incorporate testing report output from your crystal reports using Fitnesse and Visual Studio 2008. After providing a short overview, he examines the need for testing values and outlines the required steps to build a Fitnesse test. He also deeply analyzes the code sample along with the screenshot of the final output. http://aspalliance.com/1663_Utilizing_your_NET_Projects_Automated_Acceptance_Tests_on_Crystal_Reports__Part_2 Eric Landes Thu, 29 May 2008 00:00:00 GMT In this first part of the series, Eric shows how to use automated acceptance testing against Crystal Reports using the object model. After providing the requirements, he examines how to utilize automated acceptance tests with reports along with sample code to validate the report. He concludes the article by providing a structure of the report settings. http://aspalliance.com/1643_Utilizing_your_NET_Projects_Automated_Acceptance_Tests_on_Crystal_Reports__Part_1 Eric Landes Mon, 19 May 2008 00:00:00 GMT Creating reports can be a daunting task. Reports can demand a great deal of effort and time, especially if you have not worked with Crystal Reports much. In this article, Jeff provides six quick Crystal Reports Design Tips to assist in creating killer reports with style and speed. Among other tips, you will learn how to add WaterMarks to your reports. Each tip has been deeply examined with the help of relevant explanations and screenshots for better understanding. http://aspalliance.com/1593_Six_Quick_Crystal_Reports_Design_Tips Jeff McWherter Wed, 27 Feb 2008 00:00:00 GMT Crystal Reports 2008 was released in October 2007. This article (written in Jan 08) explains the ins and outs of the CR2008 versions, integration with VS versions, side-by-side compatibility, upgrading reports and general features of interest to Visual Studio Developers. http://aspalliance.com/1564_What_Visual_Studio_Developers_Should_Know_About_Crystal_Reports_2008 Julia Lerman Mon, 28 Jan 2008 00:00:00 GMT In this review, Eric starts with a basic introduction and layout of Brian's Crystal Reports book. He then provides chapter wise detailed opinion of the contents and also some of his recommendations. http://aspalliance.com/1535_Review_Crystal_Reports_Encyclopedia_Professional_XI_Reports Eric Landes Thu, 27 Dec 2007 00:00:00 GMT In this article, you will learn how to write a Windows Forms viewer for reports created in the Crystal Reports end-user program (eg. Crystal Reports XI). The viewer allows users to view the existing reports with fresh data as well as input parameter variables at run time. The utility can be written with Visual Studio 2005 or Visual Studio 2008. http://aspalliance.com/1483_Writing_a_Viewer_Utility_for_Crystal_Reports Julia Lerman Tue, 23 Oct 2007 00:00:00 GMT In this article Eric shows how to use the new Crystal Viewer to help distribute reports. http://aspalliance.com/1412_Using_Crystal_Viewer_to_Display_your_Crystal_Reports Eric Landes Thu, 27 Sep 2007 00:00:00 GMT In this article Eric shows how to create custom Crystal Reports for blogs and for portal statistics. http://aspalliance.com/1409_Creating_Custom_Reports_for_DotNetNuke_using_Crystal_Reports__Part_3 Eric Landes Mon, 03 Sep 2007 00:00:00 GMT In this second part of the series, Eric shows how to create a report on forums using Crystal Reports and DotNetNuke. http://aspalliance.com/1371_Creating_Custom_Reports_for_DotNetNuke_using_Crystal_Reports__Part_2 Eric Landes Fri, 31 Aug 2007 00:00:00 GMT In this series of articles Eric shows how to create custom Crystal Reports for DotNetNuke web sites. http://aspalliance.com/1369_Creating_Custom_Reports_for_DotNetNuke_Using_Crystal_Reports__Part_1 Eric Landes Wed, 25 Jul 2007 00:00:00 GMT In this article, Eric shows how to use Crystal Reports in a Windows Form application. http://aspalliance.com/1297_Displaying_Crystal_Reports_using_WinForms_and_C Eric Landes Fri, 01 Jun 2007 00:00:00 GMT This article will elaborate on a report created earlier for the Agile process. It describes how to make each story card unique using Team Foundation Server (TFS) and Crystal Reports. http://aspalliance.com/1270_Creating_a_Unique_Story_report_with_TFS_and_Crystal_Reports Eric Landes Thu, 17 May 2007 00:00:00 GMT In this article Eric shows the reader how to create a burn down chart (used in many agile software projects) using Crystal Reports and Team Foundation Server (TFS). http://aspalliance.com/1253_Creating_Agile_Project_Reports_with_TFS_and_Crystal_Reports__Part_3 Eric Landes Tue, 24 Apr 2007 00:00:00 GMT In this article Eric shows the reader how to create two reports using Crystal Reports and Team Foundation Server (TFS) for an agile project. http://aspalliance.com/1174_Creating_Agile_Project_Reports_with_TFS_and_Crystal_Reports__Part_2 Eric Landes Tue, 20 Feb 2007 00:00:00 GMT In this article Eric introduces the reader to creating management reports using Crystal Reports and Team Foundation Server (TFS) for an agile project. http://aspalliance.com/1160_Creating_Agile_Project_Reports_with_TFS_and_Crystal_Reports__Part_1 Eric Landes Mon, 12 Feb 2007 00:00:00 GMT In this article Pradeep demonstrates how to import dynamic images to the Crystal Report without any database overhead with the help of code samples. http://aspalliance.com/1097_Importing_Dynamic_Images_to_the_Crystal_Report_without_Database_Overhead_using_Visual_Studio_2005 Pradeep Shukla Wed, 10 Jan 2007 00:00:00 GMT This tutorial describes the various steps in generating a cross-tab report using the Crystal Report elements that are integrated with the Visual Studio 2005 default installation. http://aspalliance.com/1041_Creating_a_Crosstab_Report_in_Visual_Studio_2005_Using_Crystal_Reports Jayaram Krishnaswamy Thu, 19 Oct 2006 00:00:00 GMT In this article Eric shows how to create a Crystal Report based on a Sharepoint List using web services. http://aspalliance.com/981_Creating_a_SharePoint_Lists_Report_Using_Crystal_Reports_with_Web_Services Eric Landes Tue, 22 Aug 2006 00:00:00 GMT In this article Eric takes you through creating a Crystal Report that helps Project Managers using Microsoft Project Server produce a Project Velocity report. http://aspalliance.com/935_Creating_a_Project_Velocity_Crystal_Report_using_Microsoft_Project_Server Eric Landes Mon, 17 Jul 2006 00:00:00 GMT In this article Eric takes you through creating a Crystal Report that helps Project Managers using Microsoft Project Server summarize incomplete tasks. http://aspalliance.com/884_Creating_a_Task_Summary_Crystal_Report_from_Microsoft_Project_Server Eric Landes Wed, 07 Jun 2006 00:00:00 GMT In this article, Eric takes you through creating a Crystal Report that summarizes unanswered questions on the forums portion of a Community Server application. http://aspalliance.com/849_Creating_a_Crystal_Report_for_Community_Server Eric Landes Wed, 17 May 2006 00:00:00 GMT An article discussing how to deploy a Crystal web intranet application to a Dev/Testing and Production environment, using MSBuild. http://aspalliance.com/779_Deploying_Crystal_Report_Intranet_Web_Application_Using_MSBuild Eric Landes Thu, 02 Mar 2006 00:00:00 GMT This article describes how to use the CrystalReportsViewer and Crystal Report Template components within VS 2005 and how to populate a report from a dynamically generated DataSet at runtime without login errors. This is typically known as the "push" method. http://aspalliance.com/776_Creating_Dynamic_DataSets_for_Crystal_Reports_in_ASPNET_20 Chuck Bradley Tue, 28 Feb 2006 00:00:00 GMT In this article, Eric reviews the Crystals BI dashboard presentation product geared toward end-users. He looks at the product from a developers perspective. http://aspalliance.com/758_Review_Crystal_Xcelsius Eric Landes Wed, 18 Jan 2006 00:00:00 GMT This is the final part in a series about creating a quick way to manage Crystal Reports in a DotNetNuke private assembly. http://aspalliance.com/755_Creating_a_DotNetNuke_Private_Assembly_with_Crystal_Reports__Part_4 Eric Landes Mon, 16 Jan 2006 00:00:00 GMT In this 3rd of a four-part series, Eric shows how to display the Crystal parameters dynamically in a private assembly for DNN. http://aspalliance.com/754_Creating_a_DotNetNuke_Private_Assembly_with_Crystal_Reports__Part_3 Eric Landes Fri, 06 Jan 2006 00:00:00 GMT This is the second in a series of articles showing how to integrate a Crystal Report Manager into DotNetNuke. This article will step through creating a DAL (Data Access Layer) and BLL (Business Logic Layer) using DNN standards. http://aspalliance.com/734_Creating_a_DotNetNuke_Private_Assembly_with_Crystal_Reports__Part_2 Eric Landes Tue, 15 Nov 2005 00:00:00 GMT This is the first in a series of articles showing how to integrate a Crystal Report Manager into DotNetNuke. This article will step through creating a private assembly using Visual Studio as the development environment and using the Data Access Layer in DNN. http://aspalliance.com/733_Creating_a_DotNetNuke_Private_Assembly_with_Crystal_Reports__Part_1 Eric Landes Thu, 27 Oct 2005 00:00:00 GMT In the final part of a three-part series on Test Driven Development (TDD) in .NET, Eric Landes shows how to code to the scenario for a Business Intelligence project. He uses Crystal Reports 10 with nUnit to compare the output of a report to the raw SQL data from which the report is generated. http://aspalliance.com/712_Test_Driven_Development_for_a_Business_Intelligence_Project_with_Crystal_Reports_Part_3 Eric Landes Mon, 29 Aug 2005 00:00:00 GMT In the second part of a three-part series on Test Driven Development (TDD) in .NET, Eric Landes shows how to set up a further test for a Business Intelligence project. He uses Crystal Reports 10 with nUnit to compare the output of a report to the raw SQL data from which the report is generated. http://aspalliance.com/704_Test_Driven_Development_for_a_Business_Intelligence_Project_with_Crystal_Reports_Part_2 Eric Landes Mon, 15 Aug 2005 00:00:00 GMT In the first part of a three-part series on Test Driven Development (TDD) in .NET, Eric Landes shows how to set up the initial tests for a Business Intelligence project using Crystal Reports. Some preliminary knowledge of TDD is necessary. http://aspalliance.com/690_Test_Driven_Development_for_a_Business_Intelligence_Project_with_Crystal_Reports Eric Landes Tue, 05 Jul 2005 00:00:00 GMT A listing of different resources a developer can utilize when developing an ASP.NET solution with Crystal Reports. http://aspalliance.com/677_Recommended_Crystal_Reports_Resources_for_NET_Developers Eric Landes Tue, 31 May 2005 00:00:00 GMT In the third and final part of our series creating the FFAssist sample application, Eric Landes demonstrates new features of Visual Studio 2005 Beta 2 and Crystal Reports .NET. http://aspalliance.com/669_Sample_Application_FFAssist_using_Crystal_NET_for_Visual_Studio_2005__Part_3 Eric Landes Wed, 18 May 2005 00:00:00 GMT When deploying a Crystal Reports application written in ASP.NET, must the remote server have the Crystal Reports .NET server components installed? Ben Higgins from the ORCS Webteam addresses a common misconception. http://aspalliance.com/672_Deploying_a_Crystal_Reports_Application_to_a_Remote_Server Web Team at ORCS Web Fri, 13 May 2005 00:00:00 GMT An article that shows some methods that simulate creating a Crystal Report on the fly in an ASP.NET application using Crystal Developer 10. http://aspalliance.com/661_Create_Crystal_Reports_on_the_Fly_using_ASPNET Eric Landes Tue, 03 May 2005 00:00:00 GMT Eric Landes provides a layman's view of the different Crystal Reports licensing options available to web developers, from Crystal .NET to Crystal XI. http://aspalliance.com/654_Crystal_Reports_Licensing_Information_for_Web_Developers Eric Landes Thu, 24 Mar 2005 00:00:00 GMT Part 2 of a sample application to show the new features of Crystal .NET, available in Visual Studio 2005. http://aspalliance.com/598_Sample_App_FFAssist_Using_Crystal_NET_for_VS_2005__Part_2 Eric Landes Tue, 08 Feb 2005 00:00:00 GMT The introductory explanation of the Fantasy Footbal Assist sample Application (FFAssist). FFAssist demostrates some of the new features of Crystal .NET included with Visual Studio 2005. http://aspalliance.com/523_Sample_App_FFAssist_Using_Crystal_NET_for_VS_2005__Part_1 Eric Landes Tue, 01 Feb 2005 00:00:00 GMT Crystal Reports has the ability to produce output in PDF format. Often, it is desirable to have multiple reports appear in the same PDF file. Crystal Reports does not have the ability to export multiple reports into the same PDF, or to password protect a PDF, but several third party components can process PDFs post-export from Crystal Reports. We'll use one .NET control named Dynamic PDF Merger to combine two PDFs into a single file, and return the single file to the end user. http://aspalliance.com/571_Merging_and_Password_Protecting_PDFs_Exported_by_Crystal_Reports Richard Dudley Tue, 30 Nov 2004 00:00:00 GMT Often, the best way to prevent an error is to understand why it occurs. In various newsgroups, questions regarding the Crystal Reports LogOnException are asked quite often. A recent Crystal Alliance article discussed how to debug and get rid of this error. This article investigates why these occur, which when combined with the previous article, can help prevent this error from happening. http://aspalliance.com/532_Understanding_the_Login_Failed_Error_in_Crystal_Reports Richard Dudley Mon, 20 Sep 2004 00:00:00 GMT This snippet briefly demonstrates how to open new windows with Javascript and ASP.NET. http://aspalliance.com/525_CodeSnip_Opening_Crystal_Reports_in_a_New_Window_in_ASPNET Richard Dudley Wed, 15 Sep 2004 00:00:00 GMT One of the most common questions regarding Crystal Reports in ASP.NET is how to automatically print a Crystal Report. Because the Internet is a stateless, disconnected medium, automatic printing of a Crystal Report using Web Forms cannot be accomplished as easily as when using Windows Forms. This article examines two options for automatic printing of a Crystal Report using ASP.NET and compares one alternative method where the user must initiate printing. http://aspalliance.com/509_Automatically_Printing_Crystal_Reports_in_ASPNET Richard Dudley Wed, 01 Sep 2004 00:00:00 GMT Many of the issues addressed on the forums are about logging onto Crystal Reports. This article shows how to debug some of these issues. http://aspalliance.com/490_Troubleshooting_Database_Login_Errors_using_Crystal_Reports_with_NET Eric Landes Fri, 23 Jul 2004 00:00:00 GMT Now that Crystal Reports 10 has been out a while, I wanted to go over some reasons to upgrade, and what you might encounter when upgrading. There are a lot of reporting options out there and this may give you some ideas as to how Crystal 10 could figure into your toolset. http://aspalliance.com/480_Reasons_to_Upgrade_Your_Web_Application_to_Crystal_10_ Eric Landes Mon, 12 Jul 2004 00:00:00 GMT When exporting from Crystal Reports .NET to Excel, the output can turn out to be unusable without a lot of reformatting in the spreadsheet. This tends to make business managers unhappy. Fortunatly, with a few programming and report formatting options, you can have perfect Excel exports with very little effort. http://aspalliance.com/478_Exporting_to_Excel_in_Crystal_Reports_NET__Perfect_Excel_Exports Richard Dudley Tue, 22 Jun 2004 00:00:00 GMT Final Part in Series on a sample application that Dynamically displays a reports parameters, then allows the user to view that report. http://aspalliance.com/463_Automagically_Display_Crystal_Parameters_Part_III Eric Landes Wed, 26 May 2004 00:00:00 GMT This article follows up on the Part I, discussing the class that is used to dynamically create the collection of server controls for the parameters of a Crystal Report. http://aspalliance.com/459_Automagically_Display_Crystal_Parameters_Part_II Eric Landes Mon, 17 May 2004 00:00:00 GMT This article is a walkthrough of a sample application that programmatically displays crystal reports parameters on a web page and outputs that same report. http://aspalliance.com/456_Automagically_Display_Crystal_Parameters_Part_I Eric Landes Fri, 07 May 2004 00:00:00 GMT In this last part of the series, we will take a look at how conditional formatting can help us hide/display a section of the Crystal Reports report. Conditional formatting refers to those formatting that are triggered only when certain condition is satisfied. Note that these formatting will override any fixed formatting done earlier using the Format Editor. http://aspalliance.com/217_Creating_Professional_Reports_using_Crystal_Report_for_Visual_StudioNET_Part_3 Eric Landes Thu, 12 Feb 2004 00:00:00 GMT Continue to develop Drill Down reports in Visual Basic.NET using Crystal Report: moving these items around and placing them in a particular order to get the desired result. http://aspalliance.com/216_Creating_Professional_Reports_using_Crystal_Report_for_Visual_StudioNET_Part_2 Eric Landes Wed, 11 Feb 2004 00:00:00 GMT A step by step guide to developing Drill Down reports in Visual Studio.NET using Crystal Reports. A Drill Down report is interactive, intended to enhance the viewer's experience by initially providing only a summary of the overall information and then allowing the viewer to drill-down to the details of his interest. http://aspalliance.com/215_Creating_Professional_Reports_using_Crystal_Report_for_Visual_StudioNET_Part_1 Eric Landes Tue, 10 Feb 2004 00:00:00 GMT An overview of Crystal Reports. Walkthroughs show how to use both Pull and Push methods as well as exporting the report file into other formats. http://aspalliance.com/265_Crystal_Report_for_Visual_Studio_NET Eric Landes Tue, 10 Feb 2004 00:00:00 GMT Sample code for logging on to Crystal .NET subreports using C#. http://aspalliance.com/231_Logging_on_to_Crystal_NET_subreports Eric Landes Thu, 30 Oct 2003 17:32:34 GMT This article covers several tips picked up from various mailing lists on Crystal .NET. http://aspalliance.com/12_Crystal_NET_Tips Eric Landes Thu, 30 Oct 2003 00:00:00 GMT How to dynamically create Formulas in crystal reports .net http://aspalliance.com/242_Crystal_Report_Formulas Eric Landes Sat, 25 Oct 2003 16:24:08 GMT Walk through of creating a Crystal Report http://aspalliance.com/11_Crystal_Net_Stored_Procedures_with_Datasets Eric Landes Sun, 21 Sep 2003 00:00:00 GMT