Getting Rid of 'Duplicate Records' - Using a Command Object
This blog post shows how to get rid of duplicate records by using a Command Object in Crystal Reports. Duplicate records can be caused by adding additional 'details level' tables to a report. Jan. 31, 2012
Comments: 0   Rank: 20932   Page Views: 271 (Stats updated nightly)

Formatting X-Axis Date Labels in a Chart - Using a Cross-tab
This blog post shows how to customize the x axis of a chart in crystal reports by using a cross-tab. A sample report is available here http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/0098abcc-e80e-2f10-6b91-a6a7bb33912a Dec. 22, 2011
Comments: 0   Rank: 19198   Page Views: 521 (Stats updated nightly)

Grouping a Report by Order of Parameter Input
You have a report that is grouped and the end user has a parameter / prompt where they enter values for this group. The report is filtered on the values entered. This blog post will show you how to order the group based on the order of values entered in the parameter. Dec. 21, 2011
Comments: 0   Rank: 20538   Page Views: 333 (Stats updated nightly)

Displaying All Missing Dates In a Range - A Custom Function Sample
If you have a date field on your report, you may have days missing on the report. Sometimes there may be a need to simply display the days that are missing so that the sequence is not interrupted. This blog post will help you create a Custom Function in Crystal Reports to display these days. Dec. 13, 2011
Comments: 0   Rank: 21398   Page Views: 171 (Stats updated nightly)

Calculating the Distance Between Two Points - A Custom Function Sample
If you have data fields representing latitude and longitude and wish to calculate the distance between two points, you can use a Haversine calculation to approximate that distance. This blog post will help you create a Custom Function for Crystal Reports to make that calculation. Dec. 13, 2011
Comments: 0   Rank: 20200   Page Views: 389 (Stats updated nightly)

Passing Multiple "LIKE" and or "NOT LIKE" Statements to the Database
Sample code for a Crystal Report to pass LIKE statements to the database server. Values are entered via a multiple value parameter / prompt. Jul. 28, 2011
Comments: 1   Rank: 18596   Page Views: 596 (Stats updated nightly)

Parameterized Date Group Intervals in Crystal Reports
Sample code for a Crystal Report to allow the end user to change the grouping interval on a date or datetime field to Monthly, Weekly, Quarterly, etc.  Jul. 21, 2011
Comments: 3   Rank: 18336   Page Views: 638 (Stats updated nightly)

Disable Drill-Down on Subreports in Crystal Reports CR2008 or XI 3.x DHTML Viewers
This blog features a sample Crystal Report with a javascript function that disables drill-down on subreports in the DHTML viewers. For BusinessObjects Enterprise 3.x or Crystal Reports Server 2008 only.  Dec. 22, 2010
Comments: 1   Rank: 15096   Page Views: 1188 (Stats updated nightly)

webElements 247 Beta
Blog contains info and links for webElements 247 beta testing. Dec. 13, 2010
Comments: 0   Rank: 16835   Page Views: 870 (Stats updated nightly)

Summaries by Time Period - Sample Crystal Report
This sample Crystal Report shows multiple summaries by several time periods based on a user entered end datetime.  Dec. 13, 2010
Comments: 0   Rank: 13062   Page Views: 1614 (Stats updated nightly)

Crystal Reports, webElements, and the iPad
During the SAP 5O5 World Championships we created a sample Crystal Report to run on the iPad. The report uses webElements controls for the select menu and the submit method. Aug. 19, 2010
Comments: 2   Rank: 9684   Page Views: 2650 (Stats updated nightly)

Crystal Reports Year to Year Comparison Sample
This sample is an interactive "year to year comparison tool" created with Crystal Reports. webElements functions are used to create the embedded html controls. This sample can be adapted to use any data set. This was created as part of the Value Added Samples and Demos. Jul. 2, 2010
Comments: 4   Rank: 8637   Page Views: 3003 (Stats updated nightly)

Peformance Tip - Passing Conditional Date Ranges to the Database
This blog and sample report demonstrate how a conditional If-Then-Else statement can be passed server-side by Crystal. Having the database server process the records will increase performance substantially. Apr. 19, 2010
Comments: 0   Rank: 10991   Page Views: 2184 (Stats updated nightly)

webElements 246 Beta
Blog contains info and links for webElements 246 beta testing. Mar. 24, 2010
Comments: 8   Rank: 7624   Page Views: 3328 (Stats updated nightly)

SPC Process Control Chart Sample
This blog post has a link to a sample crystal report containing a process control (SPC) chart. Mar. 23, 2010
Comments: 0   Rank: 14851   Page Views: 1238 (Stats updated nightly)

Dynamic Grouping Drill-down Sample
This report is an adaptable sample that features dynamic grouping / drilldown, dynamic measures, and intra-report navigation. This report is part of the value added samples and demos program. Feb. 1, 2010
Comments: 0   Rank: 10166   Page Views: 2471 (Stats updated nightly)

Hiding the Toolbar in Crystal Reports and 2 Other Great OpenDocument Features
This blog will show you how to hide the toolbar in the Crystal Reports viewers. You will also see how to hide the drill-down tabs, change the viewer background to white, and align your content to the left. Jan. 25, 2010
Comments: 0   Rank: 9794   Page Views: 2607 (Stats updated nightly)

Charting off of Any Number in Crystal Reports
This blog post and sample report show how to chart off of any whileprinting records numbers in Crystal Reports. Jan. 8, 2010
Comments: 4   Rank: 10424   Page Views: 2368 (Stats updated nightly)

Setting a Crystal Report to Any Datasource
Setting a Crystal Report from tables to a stored procedure or command or universe (or the reverse) can be difficult. Using the method in this blog post you can avoid any associated datasource mapping issues. Dec. 21, 2009
Comments: 7   Rank: 3944   Page Views: 4952 (Stats updated nightly)

Crystal Reports Interactive Tag Cloud Sample
This sample is an interactive "tag cloud" created with Crystal Reports. webElements functions are used to create the embedded html controls. This sample can be adapted to use any data set. This was created as part of the Value Added Samples and Demos. Dec. 8, 2009
Comments: 0   Rank: 8964   Page Views: 2893 (Stats updated nightly)

Crystal Reports Navigation: A Top of Page Index
This sample shows how to create an index for hyperlinking to a group that starts with a certain letter or number. The index is at the top of each page. Report part linking and cross-tabs are used. Dec. 8, 2009
Comments: 0   Rank: 9444   Page Views: 2736 (Stats updated nightly)

Greater Speed & Flexibility for Xcelsius Dashboard Components
Use Crystal Reports to deliver your Xcelsius models in a dashboard and bypass Live Office or any other web service. Nov. 30, 2009
Comments: 2   Rank: 8804   Page Views: 2946 (Stats updated nightly)

Displaying Text File Contents from a File Directory in Crystal Reports
If you have a directory structure containing text files, then you can display the directory information and the text file contents in Crystal Reports. Nov. 25, 2009
Comments: 3   Rank: 11473   Page Views: 2026 (Stats updated nightly)

Value Added Samples and Demos
Value Added Samples and Demos - What is this all about? Nov. 25, 2009
Comments: 0   Rank: 11336   Page Views: 2066 (Stats updated nightly)

Staging webElements Controls
This sample shows how webElements controls can be "staged" to cascade from the highest hierarchy level to the lowest level. Nov. 24, 2009
Comments: 2   Rank: 12410   Page Views: 1758 (Stats updated nightly)

ProjectVegas cr2008, Crystal Reports
 Oct. 25, 2007
Comments: 0   Rank: 14304   Page Views: 1352 (Stats updated nightly)

Poor Man's Ad Hoc, Crystal Reports
 Sep. 11, 2007
Comments: 1   Rank: 14120   Page Views: 1388 (Stats updated nightly)

Translating Reports using Custom Functions, Crystal Reports
 Dec. 11, 2006
Comments: 0   Rank: 13423   Page Views: 1526 (Stats updated nightly)

Crosstab Samples, Crystal Reports
 Oct. 24, 2006
Comments: 2   Rank: 11448   Page Views: 2037 (Stats updated nightly)

Finance Samples, Crystal Reports
 Oct. 18, 2006
Comments: 0   Rank: 13274   Page Views: 1558 (Stats updated nightly)

Calendar Report Samples, Crystal Reports
 Oct. 14, 2006
Comments: 1   Rank: 10907   Page Views: 2211 (Stats updated nightly)