Archive for May, 2012

Update to server-based scheduler comparison

Saturday 19 May 2012 @ 7:28 am

I have just updated my comparison of server-based scheduling tools for 2012. These tools are similar to the desktop-based scheduling tools I write about every March, but these are designed to be run on server. This allows multiple people to schedule reports for automated delivery by Email, FTP or network folder.

There are 8 products on the list again this year with a few feature updates and price changes since last year.  The article provides a brief overview of each product.  It also links to a feature matrix that compares roughly 70 features of these tools.  There is even a feature glossary that defines all the terms. So if you need a short course in automating Crystal Reports delivery, you have come to the right place.

Using formula fields and calculations in the selection formula

Friday 18 May 2012 @ 5:18 pm

I recently needed a selection formula that automatically selected the last “half month”.   In other words if the report was run in the first half of a month it should return the last half of the previous month.  If the report was run in the last half of a month then the report should return the first half of that same month.     So I wrote the following selection formula:

if Day (CurrentDate) > 15
then ( day ({}) <=15 and {} in MonthToDate)
else (day ({}) >15 and {} in LastFullMonth)

This worked correctly, but I knew that it would not be very fast, because it would not pass the date criteria Continue Reading »
Using formula fields and calculations in the selection formula

New version of rePORTAL, and a 20% discount

Tuesday 15 May 2012 @ 2:31 pm

rePORTAL Software has just released v5 of rePORTAL, and they are offering a limited time 20% discount through June 15.

rePORTAL is a a web portal and scheduler that distributes reports from Crystal Reports as well as SSRS and FRx.  You can read about the current version in my comparison of server-based schedulers.  Within the next week the comparison will be updated for the new version.  The new features include:

  • Native support for 64 bit operating systems
  • Support output to Fax and SMS
  • Enhanced support for Crystal export options
  • The ability to launch batch and command files before or after scheduled events
  • A customizable user interface to highlight favorite items


Calculating the first weekday of the month

Saturday 12 May 2012 @ 8:34 am

One of my customers has reports scheduled to run every weekday. The rule is that all month long it should pull the dates for the current month. But once a month, at the beginning of the month, they want to run the entire previous month. So I wrote their selection formula to say “If today is the first of the month, then run LastFullMonth, otherwise run MonthToDate:

If Day (currentDate) = 1
then {DateField} in LastFullMonth
else {DateField} in MonthToDate

This worked fine for several months until we got to April.  Because the report only Continue Reading »
Calculating the first weekday of the month

New specialized tool to help you “Set Location”

Thursday 10 May 2012 @ 9:03 pm

The folks at have just released a new tool called CR Data Source which is designed to do just one thing. It lets you perform a “Set Location” on a folder full of reports, all in one stroke. The tool does just this one task, but then again it only costs $29, so it will probably be a popular choice for certain users. If you look at my review of RPT management utilities you will only find one other tool that does this, and that tool does lots of other things and costs about $400.

The current limitations are:

  • It only works with ODBC/OLEDB
  • It can only be used on reports that only have a single data source.

But even with these restrictions, the tool will still work on most reports.  And, if the tool catches on I am sure the folks at R-tag would be open to suggested improvements.  As always, if you try this tool please let me know what you thought.

Discount on purchases of Find it EZ

Sunday 6 May 2012 @ 10:17 am

If you have been considering purchasing Find it EZ then you might want to do it in the next few weeks. The developers of Find it EZ are offering my readers a 25% discount on purchases through 6/20/2012. Use this link to get the discount.

Find it EZ is a source code scanning tool that I have included in my comparison of RPT management utilities. It allows you to search your entire application, including your RPT files, for the use of specific tables, fields and text.

The current promotion is to highlight the release of version 4.0 which adds new features like team collaboration and Continue Reading »
Discount on purchases of Find it EZ


Recrystallize Pro

Crystal Reports Server