Crystal Reports Exporter

Introduction

Crystal Reports Exporter is a free Windows console (Command Line) tool that enables user to export crystal Reports file without Crystal Reports installed.
Since it is a Windows console tool, you can run it using "cmd.exe" of Windows 2000/XP or "command.com" of Windows 98.
Of course, you can write a batch file to call crexport and let Windows Tasks Scheduler/Scheduled Tasks to run it at any specified time.

Release History
Date Version Remarks
26 Feb 2003 1.1.1152.38285 First release
08 Apr 2003 1.1.1190.40252 Bug fixed - Crystal Reports Exporter does not refresh Crystal Reports that without parameters.
03 May 2003 1.2.1217.18398 New feature - Allow user to pass multiple discrete or range value parameter into crexport.exe. Multiple values parameter with both discrete and range value is still not supported by this version.
01 Jun 2003 1.2.1247.16937 New feature - Allow user to pass null value discrete parameter.
26 Jun 2003 1.2.1271.40511 New feature - Allow user to specify export into separated or single HTML page.
28 Nov 2003 1.2.1419.21168 Open source. License agreement clause added into source file header. Executable compiled by Microsoft Visual Studio.net 2003

System Requirements Parameter Listing Usage
c:\Program files\rainforestNET\crexport> crexport -Uuser1 -Pmypass -S"Extreme Sample Database" -Fc:\test.rpt -Od:\test.pdf -Epdf -XFile -N1 -Asupplier -J"Active Outdoors" -M1 -Bdaterange -V(12-01-2001,12-04-2002)

The following crystal Reports "testTraining.rpt" has 5 discrete parameters and 2 range parameters.
Discrete parameters are:
  1. company
  2. customer
  3. branch
Range parameters are:
  1. Daterange
  2. Product
Single value parameters
c:\Program files\rainforestNET\crexport> crexport -Uuser1 -Psecret -FC:\Creport\Statement.rpt -OD:\Output\Statement.pdf -XFile -Epdf-S"AnySystem DB" -N3 -Acompany -J"The One Computer,Inc" -Acustomer -J"MyBooks Store" -Abranch -J"Malaysia" -M2 -Bdaterange -V(12-01-2001,12-04-2002) -Bproduct -V(AFD001,AFD005)

Multiple values parameters
c:\Program files\rainforestNET\crexport> crexport -Ftestreport.rpt -OtestOutput.doc -XFile -Edoc -Sorder.mdb -M2 -Bdate -V"(01-01-2001,28-02-2001)|(02-01-2002,31-10-2002)|(02-08-2002,31-12-2002)|" -BClient -V"(Ace Soft Inc,Best Computer Inc)|(Xtreme Bike Inc,Zebra Design Inc)|"

Email Crystal Reports with Microsoft email client(Outlook or Outlook Express)
c:\program files\rainforestNET\crexport> crexport -S"Xtreme Sample Database 9" -FReport2.rpt -OtheMatrix.pdf -XMsmail -Epdf -N1 -Acustomer -J"Morpheus and Neo|Agent Smith and Trinity|" -tinfo@mydomain.net -shello -mTestMessage -ucontact@rainforestnet.com

Note:
1. -N and -M must be defined before defining -A,-J and -B,-V parameters.
2. If your crystal Reports data source is one of the ODBC DSN (regardless of User DSN or System DSN),the DSN will be your Server Name (-S).
3. You have to enclose all the parameter value that separated by space with double quote (") except in specifying multiple values.
4. To specify multiple value parameter, you need to separate different value by "|" character and enclose the multiple values string by double quote(").
    Do not enclose any individual value of multiple values by double quote(") even it is separated by space.
    Do not insert "|" infront of the first value of multiple values parameter.
5. To email to multiple recipients, Use semi-colon (;) to separate multiple email addresses. ie. -tinfo@mydomain.net;ask@anotherdomain.com

If you found any bug or you have any question on "Crystal Reports Exporter", please post your question in my forum.