Automating TrackIt! Reports

Automating TrackIt! Reports - The Easy Way (Works for other Crystal Reports)

Rainforest Software makes a utility "crexport.exe" that can automate a Crystal Report with parameters.  Here's how:


  1. If not already installed, install the .NET Framework 4.0.  This comes bundled with modern versions of Windows and most likely is already installed.
  2. Install the 32-bit Crystal Reports runtime here. (64-bit won't work for TrackIt! reports, but may work for others).
  3. Download and extract "crexport.exe" to a folder on your desktop
  4. From TrackIt's report section, click "Work Order Status by Technician" and in the top left click "Export Report".
  5. Save this report to the same directory as "crexport.exe".
  6. Download the "CorFlags.exe" utility to the same directory as "crexport.exe"
  7. Open a command prompt.  Using CorFlags, Switch "crexport.exe" to run in 32-bit only.
    corflags /32BIT+ crexport.exe
  8. Get the TrackItRpt (or TrackItRpt_1) password from your dba or from TrackIt! Support.
  9. If TrackIt is installed, a 32-bit ODBC connection should already be on the PC for the TRACKIT_DATA database.  If not, create one.  This must be 32-bit ODBC.
  10. Run the crexport utility against the RPT file, where "-s Trackit" matches the ODBC name.
    crexport.exe -P TRACKIT_PASSWORD -U TrackItRpt -s Trackit -F HD_StatusbyTechnician.rpt -O HD_StatusbyTechnician.xls -E xls -a "Date_ Entered_Range:(2013-04-24,2013-04-25)"
  11. *Note: "Date_ Entered_Range" has a space in it.  This needs to match the field names in the RPT files exactly.  If you are unsure what the field names are, use a 30 day trial of Crystal Reports to view the Parameter Fields.
  12. *Note:  If the report is currently open in Crystal Reports, you will recieve an error:
    Misc Error: Load report failed
    Type "crexport -?" for help
  13. *Note:  Not all reports will work.  Make sure to test crexport fully before running on a Production Server as there are some reports that cause it to eat up CPU and Memory.

To email (SMTP) these reports to recipients once they've been generated, you may wan to look into Blat.

-Tres


Comments

Post a Comment

Popular posts from this blog

Dell Zino HD Remote Standard

Image
Took me hours and multiple calls to Dell Technical Support to find this information out. The Dell Zino HD uses the following IR standard for the Remote Sensor on the front: UPD6124A Here is the PDF specification:  http://www.datasheetcatalog.org/datasheet/nec/UPD6600A.pdf The support representative said most universal remotes use one of these two standards: RC5, RECS80 Unfortunately, this causes issues when trying to use a universal remote (example: XBOX 360 Universal Remote) with the Dell Zino HD.  A USB External IR sensor is needed to work with most universal remotes.  This is very confusing, as both devices list as a standard "Microsoft eHome Infrared Tranciever". What this means is that no remote -- other than the one that shipped with your device -- will work with your Dell Zino HD!  Scroll down to see my work-around. Since the Dell Zino HD only comes with 4 usb ports, the external sensor may have to be plugged in to the front of the device, which is partic
Read more

iPod Touch iPhone 3G Ubuntu 9.10 in 5 minutes

Image
"Lucid (Ubuntu 10.04) has 'out of the box', zero-configuration support in Rhythmbox for the iPod touch running firmware 3.12/3.13. It does not require jailbreaking, though I have personally discovered it will work with both a "stock" and a jailbroken iPod touch." - Raffisson Studio Changes (skip this) : Mar 28, 2010: Added link to French tutorial in step 1. Mar 16, 2010: Added Amarok 2.3 notes pe r Gary Feb 23, 2010: Removed "-dev" packages and made some small changes per farfouille64 feedback. Feb 19, 2010: Bifster found a similar tutorial. Worth trying if you have issues. Here's the link: easy way to sync your iphone Feb 19, 2010: Step 11 added DFB 's RythmBox plugin suggestion. Confirmation working with firmware 3.1.3! Thanks DFB! Feb 15, 2010: Step 11 added AJ's unicode work-around. Thanks AJ! Feb 11, 2010: Step 10 modified to automatically add user to group "fuse". Thanks for the
Read more

Pidgin - Microsoft Office Communicator

Image
Update: 11/15/10 - Added ICONV.DLL, LIBXML2.DLL work-around for Windows. Update: 05/01/10 - SIPE 1.10 is out. Tutorial updated. Update: 01/27/10 - SIPE 1.7.1 is out. Download it here . Update: 08/20/09 - SIPE 1.6.0 seems to be available, so I've updated this article with some 1.6.0 comments in red below. Steps: Downloading and installing the latest Pidgin for your platform. - Windows: For first time users, the installer will require GTK to be installed. - Windows: Recommended: Install automatic spell-check (Aspell) for your language, which needs to be selected during install. (Requires a connection to the internet). Download and install the latest SIPE ( SI mple P rotocol E xchange) for your platform. - Windows: The plugin will come bundled as a zip file with a MSI installer. Run the MSI installer. This will install the plugin to "Program Files\Pidgin" - Linux: If a precompiled version (usually ".DEB" or ".RPM" is not ava
Read more