CrystalPower is a free script that creates Crystal reports based on report parameters provided by the user. It interacts with the user or optionally it can run unattended. It uses the Crystal Report Runtime facilities to produce reports in various formats.
Users of CrystalPower can edit the original login information defined in reports created with Crystal Reports XI or earlier, so they can run on systems without the actual Crystal Reports software. The edited information is saved in a configuration file, and used along with any report parameters.
The current version can be downloaded here.
It runs under the following Windows Systems:
- Windows 10 / 8 / 7 / XP - Windows Servers 2012 / 2008 / 2003
First time PowerShell users may need to Set-ExecutionPolicy RemoteSigned if prompted during setup.
CrystalPower is distributed as CrystalPower.zip
file. Unzip it in a <directory> and run the setup.cmd
in your <directory>. This will ensure the proper Crystal
Report Runtime (CRBasicVS2008 free) is installed.
Version 1.3.6 - Updates for Windows 10, ShellServe and Checksum - SHA256: 07F2A7B1D298CB546D2A563BD2E624BAF37EB6FA264D57B02EF4851D956718AD Version 1.3.5 - Enables web service for registered ShellCrystal users Version 1.3.3 - Adds option to send email with attached report Version 1.3.2 - Maintenance release with enhanced setup Version 1.3.1 - Maintenance release with fixes Version 1.3 - Saves report parameters and can run reports in unattended mode Version 1.2 - Includes a report Drag-and-Drop feature and Help(F1) Version 1.1 - Bug fixes Version 1.0 - April 25, 2011.
The installation includes a sample Energy.rpt file to introduce users to CrystalPower.
Here are some examples of how to start running and using CrystalPower.
How to run from the command line
1) PShellExec CrystalPower.ps1.bin 2) PShellExec CrystalPower.ps1.bin -a:"C:/Reports/myReport.rpt" 3) PShellExec CrystalPower.ps1.bin -a:"C:/Reports/myReport.rpt,-v"
In the first example CrystalPower the user needs to select
a report file or a saved configuration.
In the third example, the -v argument indicates the resulting report output file is not to be displayed automatically for viewing.
How to run a report with saved parameter values
With version 1.3 of CrystalPower report parameters are saved in a Config sub-directory allowing users to run reports in unattended mode.
1) PShellExec CrystalPower.ps1.bin -a:"C:/Reports/sample.config" 2) PShellExec CrystalPower.ps1.bin -a:"C:/Reports/sample.config,-x"
In the first example, CrystalPower starts with a sample.config file, and uses report parameters saved from a previous report run. A .config file contains parameter values for a given report and it can be renamed later, thus allowing for multiple parameter combinations when needed.
The second example, executes CrystalPower with a sample.config without any user intervention, using the parameter values from the .config file, allowing users to run reports in unattended mode.
How to Email a Report
Users can email their CrystalPower reports by adding an entry to their config files:
<En> <S N="Key">:Email:</S> <S N="Value">C:\Docs\Reports\Config\sendCommand.txt</S> </En>
The sendCommand.txt text file referenced above, contains an easily formatted Send-MailMessage command ending with an -attachment option, just as shown below:
Send-MailMessage -to "Carl<email@example.com>" -from "jane<firstname.lastname@example.org>" -subject "Daily status" -body "Project report is attached" -smtpserver "smtp1.local" -attachment
How to Embed Reports and Automate Delivery
By combining a CrystalPower unattended run and attaching a report file in an email, as shown above, users can schedule automatic report deliveries via the Windows Task Scheduler. A sample task schedule CrystalPowerJobSample.xml is included. It can be imported into the Windows Task Scheduler and modified according to user's requirements.
CrystalPower users can also embed their reports in SugarCRM® or SuiteCRM® via the ShellCrystal extension.
Tweets by @infoSpectrumInc
© 2011-2018 infoSpectrum Inc. All trademarks and names are property of their respective owners.