|
Index
Go to the index by Subject page
Here are brief descriptions of each tip
in our back issues. If you would like to download a pdf with the full
tip, see the right hand panel.
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
|
Index to Earlier Years
(1999-2007)
Issue 63: September/October 2007
Business Objects and SAP; Crystal Reports
2008 announced; Analyze your data by Day of Week in a Crosstab; Use the
Share UFL to carry forward a balance from last months report; Create a NULL
value in a formula; GroupName function; NPV function; Shadows on boxes with
round corners; Drill down with text objects; Using multi column reports with
Group Sections
Issue 62: July-August 2007
Better export to Excel with the Grid UFL;
Share data between reports with our Share UFL; Box and Line formatting;
Summary Fields in a Text object; Wrapping days on the top line in a calendar
report; Daylight savings in New Zealand.
Issue 61: March/April 2007
How to exclude records based on another
table; Display Date Ranges in the calendar report; Display complete month
when it starts on a Friday or Saturday; Create blank label records at
the top of the first page; Printer settings in Crystal Reports XI; How to
document conditional formatting; New products from
Cortex Systems; How to get
the group tree back; How to display CR or OD on negative numbers
Issue 60: January/February 2007
Crystal Reports XI/R2; Insert Summary
changes in XI/R2; Calendar Report with performance
thresholds.
- Issue 59: December 2006
- Conference Report -
Business Objects Insight 2006; use Disk Output and Text Lookup UFL's to
persist data between reports; How to use Hierarchical Summaries in a
formula; Improve the readability of your charts; Security Issues with
Dynamic Images; Sub Selects in SQL Expressions
- Issue 58: October 2006 (Parameter
Issue)
- Create multi purpose reports by using a
parameter; Static Pick List in Crystal Reports XI; Dynamic Pick List in
Crystal Reports XI; Pick List Data sources; Cascading Pick List in Crystal
Reports XI; Use cViewPICK to populate your pick lists; Conference Report -
Microsoft Tech Ed 2006; Sorting two dimensional product codes; use OLAP data
source for your report.
- Issue 57: August 2006 (Extra Time
Issue)
- Include Ties in TopN reports; Dynamic
Number of TopN values; Round to nearest 10c in those cash reports; Why do we
get rounding errors; How to eliminate rounding errors; Calculate
specific day of next month; Images and fonts not appearing as expected; What
does that field really hold; Turning on guidelines; Sorting a field
numerically with an alpha prefix; Control-Tab to cycle through windows
- Issue 56: May 2006
- Use multiple sections with alternate
formats; Calculations on Crosstab summary fields; Use Set Print Date/Time
for testing reports on a specific date; set the month first to include all
valid days for that month; Hotkeys to cycle through applications and report
windows.
- Issue 55: April 2006 (April Full
Issue)
- View your Crystal Report on your iPOD or MP3
player; How to drill down with PDF documents; Crystal Reports hotkeys for
preview and design windows; Formulas for last day of month, number of days
in the month, last Friday and Wednesday of the month
- Issue 54: March 2006 (March Division
Issue)
- Check divisor for zero in a division
formula; Book Review: Crystal Reports Xi by George Peck; Group by a field
more than once; Summary of a field in groups; Hierarchical summary fields in
a formula; Why you need summaries in formulas; Calculate a week number for
those weeks that don't start on Sunday; Keep track of current version;
Hotkeys for Windows explorer and minimize all windows
- Issue 53: February 2006 (February Format
Issue)
- Text interpretation with memo fields;
Use cViewTEXT to retrieve text from a file; Use Crystal Reports to automate
your disk backup; Date Time format strings in ToText function; Calculate a
week number using formulas with variables
- Issue 52: January 2006 (New Year Issue)
- Use Crystal Reports as an auditing tool;
Date Time Fields at midday and midnight; Report on Business Objects
User conference in Orlando; Interesting extension to the Pareto Principle;
Dynamic Images in your report; What's New in Crystal Reports for Visual
Studio 2005; How to calculate a week number using DatePart function;
Identify the last group in a report
- Issue 51: October/November 2005 (Daylight
Saving Issue)
- Remember to change clocks and check formulas
over daylight savings change over; What day did that happen? When does
the day start? Page Footer section behaves differently; How to format
temperature data; Tech Ed 2005 conference review; Business Objects
conference in Orlando and Queensland
- Issue 50: August 2005 (Welcome Back Issue)
- New Features in Crystal Reports XI
(Conditional Column Color in Charts; Parameter Changes; Dynamic and
Cascading Pick Lists; Dynamic TopN; Dynamic Ascending/Descending sort;
Hierarchical Groups) Hyperlink for Crystal Reports Server XI; Sort your
parameter array before printing in a heading; Where are the repository
samples? Using Strike Out on field formatting; Selecting all the objects in
a section; Using summaries with Perform Grouping on Server; Business Objects
conference in Orlando
- Issue 49: January/February 2005 (New Year Issue)
- Business Objects XI Road Show; Major new
features in Crystal Reports XI; Gantt Chart to display a range of data; Use
a horizontal bar chart in older versions; Crystal Reports XI layout and
toolbars; Use Gauge charts to display data; When to use Pie Charts
- Issue 48: December 2004 (Christmas
Crosstab Issue)
- Use other summary functions in your crosstab;
Use cell background and border to highlight your crosstab headings;
Use a manual crosstab for more control; Crosstab features covered in
previous issues; Artistic Interlude with Liam O'Neill; Use an OLAP grid
inside your report.
- Issue 47: November 2004 (Five Year
Anniversary Issue)
- Review of the previous five years; Group Expert
Improvements; remember to back up your reports; Business Objects User
conferences; Where can you find previous issues? Formula to create time
bands; Display a specific digit in Pi; Report missing data summary; Artistic
Interlude - Sculpture on Shore 2004; Use a Crystal report to list your
Crystal reports; Field heading placement; Web server folder names; XML and
Crystal Reports; Parameter Pick List update; Include all your data in your
database design; What has happened with Crystal and SQL; Thanks to our
contributors;
- Issue 46: October 2004 (Back to Work Issue)
- Use Group Expert; Windows XP Service Pack 2
and Crystal Reports 8.5; Use a parameter to select different chart layouts;
Included deleted data in your database design; What has happened to Crystal
Dictionaries? Insight 2004 (Australia Business Objects User Group
Conference); Use Round function to round numbers to tens and hundreds; Left
Join problem solved with SQL
- Issue 45: September 2004 (International
Date Line Issue)
- Use conditional formatting with duplex
printer page breaks; use IMP to combine your binary clauses to get more TRUE
values; don't keep changing your data in
your database design; extract sentences from memo fields; Nested
hierarchical groups in CR11; Be careful with date literals if you are
outside the USA; Use DateSerial function;
- Issue 44: August 2004 (Olympic Issue)
- Award Silver and gold medals with NthLargest
Summary field; cViewSQL
can work with your Crystal report to update a database; Mailto hyperlink can
include additional fields; Pahia (Bay of Islands) Scenery; Book review: The
Inmates are running the Asylum by Alan Cooper; wrapping a crosstab down the
page; use EQV to combine your binary clauses; remove repeating fields in
your database design; custom function for the day of the year
- Issue 43: July 2004 (On the Edge Issue)
- cViewIMAGE is bigger and better; cViewTEXT
can now load dynamic text into your report; Weighted Average summary;
Muriwai Scenery; Unset Keep Together to avoid blank pages; Book review:
Crystal Reports 10 Complete Reference by George Peck; Use XOR as
a Boolean operator; Singularity Principle in database design;
Custom Function for padding a string
- Issue 42: June 2004 (Big Easy Issue)
- Average calculated three ways (Mean, median
and Mode); Taranaki Scenery; CDUGNA 2004 (New Orleans) conference report and
photos; Using PreviousIsNULL and NextIsNULL in a report; Use
Performance Information as a benchmark; Negate an AND statement with OR;
Beginners guide to Business Views; Atomic Principle in database design;
Custom Function for Ordinals (1st, 2nd, etc.)
- Issue 41: May 2004 (Database Issue)
- New Orleans conference dates; Use an on
demand subreport to mimic a drill down; New Special Fields in Crystal
Reports 10; A problem with record selection and left joins; How to sum
distinct count at higher levels; Use UTC time values in your database
design; Auckland sky line photo; java and the Crystal e-learning modules;
age as a custom function
- Issue 40: February/March
2004 (St Patrick's Day Issue)
- File
User Function Library released; New Features in Crystal Reports 10;
Integrating Microsoft CRM with Crystal Reports; Register New Maps with
MIGM30; Formula problems with Leap Years; Display a parameter range with "No
Upper Bound" or "No Lower Bound"; Screen size controls Export to text
formatting; Rescheduled conference dates
- Issue 39: January 2004
- Business Objects purchase Crystal Decisions;
Report on Tech Ed 2003; New feature Summary of CR10; Release of Crystal
Analysis 10; Use descriptions with Boolean parameters; cView 8.17 and
9.17 now available; How do you make a report secure? Use chart templates to
share chart formatting; Export part of your report using a UFL;
Compare MS reporting services and Crystal Reports; Compare versions and
editions of Crystal Reports; Use a backup if you have accidentally upgraded
to CR9; Chase International utility to convert CR9 to CR8.5; Conference
dates for Sydney and New Orleans
-
- Issue 38: July/August 2003
- Business Objects to buy Crystal Decisions;
Tech Ed 2003 at Auckland; Preview of CR10; Recover Excel Add In if it
disappears; Book review of Visual Basic.NET Strategies, Migration and Code
by Dan Appleman; What versions can share reports? Applications that
mix CR versions; Acrobat version of manuals on the CD.
- Issue 37: June 2003
- Formula for rounding up; Use Set Print
Date/Time to move your report in time; Display String format option;
Variables to interrogate data during crosstab processing; Use Cr to generate
SQL; Book Review of Code Complete by Steve McConnell; Free book for CR
developers
- Issue 36: May 2003
- Recover deleted fields from guideline
over wrap; parameter edit masks; use "Find" button to search your report;
print smiley or sad faces on your report; use summary functions on an array;
friendlier words on a cheque; not equal joins between tables; use SELECT
into to analyze patient data; use SQL commands to create audit of report
runs.
- Issue 35: April 2003
- cViewPICK, cViewIMAGE, cViewMAIL and SMTP UFL
utilities are now available ; ToWords will round a number up; Using ToWords
to print words on cheques; use a COM data source to extract your legacy
data; change color shade in reports as you go down the page; What do you
need to be a good report designer; Sort a string using a ripple sort; Use a
crosstab as a group summary; Report Analyzer 3.0 now available; Use SELECT
INTO to create summary tables.
- Issue 34: March 2003
- Round a number up; Keep Together subreports
and crosstabs; How many Thursdays between two dates; Four ways to display
dynamic Images in a report; Running Totals in a Crosstab;
- Issue 33: February 2003
- Dynamic Pick lists with cViewPICK; Where to
find the Crystal SQL designer and Crystal Dictionary Tools in CR9; Dynamic
TopN or BottomN Reports; Dynamic number of Groups in your report; Book
Review of George Peck - Crystal Reports 9; Crystal Enterprise 9 release;
Remove Duplicate Values; Display ditto (") for duplicates
- Issue 32: January 2003
- Use cView to View reports; cView
supports Crystal Reports 9.0; The different between Fix, Int and truncate on
negative numbers; Report Application Server licensing; Book review of SAMS
"Teach Yourself Crystal Reports in 24 hours"; Exporting to Excel; Full Index
by subject for previous issues; Date conversion for "24Jan2003" formatted
fields.
- Issue 31: December 2002
- Use Audit Reports to verify your other
reports; Dynamic groups and Ascending/Descending sequence using parameters;
Crystal Reports 9.0 charts, custom formulas and SQL command parameters; Set
Alias in Crystal Reports 9.0 ; Index to 2002 issues
- Issue 30: November 2002
- Crystal Reports 9.0 highlighting,
repository, and SQL commands; Background colors on a section; Easy
guide to custom colors; broadcast license requirements
- Issue 29: September/October 2002
- Crystal Reports 9.0 new features including
new explorers, new toolbars, crosstab improvements and the formula workshop;
template hint; html export hint; reports as HTML emails; which Crystal
Reports 9 edition is for you; Recrystallize your report
- Issue 28: August 2002
- Crystal Reports 9.0 released; Cr9.0
developer and sql improvements; redisplay group heading when group
continues on new page; display "continued" in repeated group
header section; combine Alerts; Summarize a summary field; avoid reset
of variables in repeated headers; dynamic TopN report; Hierarchical
group level
- Issue 27: July 2002
- Where do you place a chart on a Crystal
Report? What fields can you place on a chart? target line on a chart; use
summaries to audit your data; use colors economically; charts and
underlay; what is in version Crystal Reports 9.0? chart synchronization in
Calendar Project;
- Issue 26: March/April 2002
- A very important question to ask of every
report; use Report Alerts to audit your report; analyze your address book
with Crystal Reports; use Select Case to convert descriptions; Text File
Lookup UFL; automatic 4-4-5 account period formulas; be careful with smart
linking; Daily chart in a report
- Issue 25: January/February 2002
- Currency as a numeric label; new € symbol
you may need; utility to modify report database location, ODBC login and
printer drivers; Send multiple emails from one report; don't use reserved
words in database design; calendar project: calculating calendar days
- Index 2001
-
- Issue 24: December 2001
- Crystal Enterprise login via URL, Crystal
Enterprise Installation, HTML
Tags, calendar project introduction, adjust page number, format graphic,
index for 2001 issues
- Issue 23: November (2nd Anniversary
review)
- Remember to back up your rpt files, show
headings on drill down, file and report options in CR8.0, another age
calculation, string variables longer than 254 characters, heading list of
multi value ranges, parameters and visual basic (part 2), XML and Crystal
reports, CAST function in SQL, using original order in a group
(challenge), display a superscript in a field, NULL values in a report,
web server demonstration folders
- Issue 22: September/October 2001
- Formula for Birthday (this year) and Age (in years), XML support in
Cr8.5, conditional change of the color of a line, new products (Crystal
Analysis Professional 8.0 and Report Analyzer), Sub SELECT in SQL,
Parameters and visual basic using the OCX and RDC, conference news.
- Issue 21: August 2001
- Running total fields, conditional running totals, running total
calculations using formulas and variables, reset a running total on a page
break, how to structure report and subreport, display one word in a
different color using html text interpretation, aggregate data in SQL
using GROUP BY, control export of your report in visual basic
- Issue 20: July 2001
- PDF export in CR8.5, Speed up reports with large image fields, An easy
way to see the SQL behind your report, Crystal SQL designer, Join tables
together with UNION join, Using the Report Designer Component in Visual
Basic
- Issue 19: June 2001
- Repeat Group header on New Page, How to remove surplus blank pages from
middle of report, page headings on drill down, use Export to Report
Definition to find where that parameter is used, missing last day from
record selection, TopN in a crosstab, Report Alerts in Cr8.5, loading
record selection formula via the OCX control
- Issue 18: May 2001
- Use parameters, parameters in formulas, finding where parameters are
being used, hierarchical summaries in CR8.5, loading a parameter in Visual
Basic via the OCX control
- Issue 17: April 2001
- Set default field formats, copy format from one object to another,
Extracting file name from Path and File Name, use the Crystal OCX with
Visual Basic, using Internet newsgroups, target line on a chart, test your
expertise
- Issue 16: March 2001
- Display array values with Join and Split functions, Pick List Utility,
Working Days UFL, DLL utilities (DSX32 and Modules), Report Analyzer for
improved report management and documentation, Alert Function,
International Function Library (see
here
for example), Crystal Reports 8.5.
- Issue 15: February 2001
- Improve performance with Page N of M, range in page footer, dynamic
crosstab, parameters on the web (see
here
for example)
- Issue 14: December 2000 - January 2001
- Page breaks for a group, conditional page breaks, SSAUG conference
report, index in a page footer
- Index 2000
-
- Issue 13: November 2000
- Index to previous issues, date parameters on the Crystal Component
Server, hierarchical grouping, saving summaries, formula challenge,
missing weeks and days in a group, IsBusinessDay function in Seagate
Info 7.
- Issue 12: October 2000
- DateDiff function, calculating business days, missing date groups
- Issue 11: September 2000
- Hyperlink fields, changing selection formula on a web page, XML and
Crystal reports, useful web sites
- Issue 10: August 2000
- Date groups, customize group name, grouping on a
parameter, subreport
with no data
- Issue 9: July 2000
- Convert Null to Default, Recognising NULL in formulas, Discussion on
rounding totals, (Seagate Info) Input Directory Administration, Web
Component Server, Missing data at the beginning or end of a report
- Issue 8: June 2000
- Sort Fields, Discussion on rounding, Tool Tip Text, Text Rotation,
Missing data in a report.
- Issue 7: May 2000
- Bar code reports; how to change the
decimals to suit the number; privacy policy; how to export reports to PDF
with CR8; how to compile reports with CR8
- Issue 6: April 2000
- Using RTF and HTML in memo fields in a report; changing the data file location at run
time; using multiple similar subreports in a main report
- Issue 5: March 2000
- Release of Crystal Reports version 8. Guidelines, sorting records by surname,
printing a multiple value parameter using the FOR operator.
- Issue 4: February 2000
- "Save Data with Report", Backup your rpt files, Printing a range
parameter value and printing a multiple value parameter value
- Issue 3: January 2000:
- Drill down reports, grouping on a formula and drill down report headings
- Index 1999
-
- Issue 2: December 1999:
- Selecting from a data range with null values, record selection of future records, on
demand subreports
- Issue 1: November 1999:
- Extracting digits from a number, using the file system as a data source,
retrieving a
value from a subreport
|
Are you looking
for a highly functional report scheduler?
See
cViewSERVER
for a Windows Service solution. Benefit: The
machine does not need to be logged on
See
cViewMANAGER
for a scheduler on your desktop
Do your Users
want to just click once for a favorite report?
See
cView viewer
Are you looking
for a way to display images in your reports?
See
cViewIMAGE
Crystal Clear
Newsletter
You may
download a pdf of our back issues below
current issue
Crystal Clear 71
Jan-Mar 2010
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
Sample reports: See Crystal techniques used in a report
Sales
Calendar
Calendar Report
Running Totals in a Crosstab
Wrapping Crosstab
PDF
Drill Down
Crosstab calculations
Hierarchical Summary in a formula
|
