Help Center

Installation

Requirements

Requirements

  • Operation System:
    • Windows: Windows 10, Windows 8, Windows 7, Windows XP
    • Windows Server: Windows Server 2019, 2016, 2012 R2, 2012, 2008 R2, 2008
  • Minimum Memory: 2GB
  • The download (setup) includes all the necessary requirements:
    • ​Microsoft .NET Framework 4.5.2
    • SAP Crystal Reports Runtime Engine for .NET Framework 13.0.21.2533
    • SQL Server 2014 Express LocalDB (with SP1)
  • Smart Report Organizer requires a specific version of SAP Crystal Reports Runtime.
    • Smart Report Organizer 2021 V4.XX requires: SAP Crystal Reports Runtime 13.0.21.2533
    • Smart Report Organizer 2018 V3.XX requires: SAP Crystal Reports Runtime 13.0.21.2533
    • Smart Report Organizer 2018 V2.100 requires: SAP Crystal Reports Runtime 13.0.21.2533
    • Smart Report Organizer 2017 V1.135 requires: SAP Crystal Reports Runtime 13.0.21.2533
    • Smart Report Organizer 2017 V1.128 requires: SAP Crystal Reports Runtime 13.0.16.1954
  • ​The setup automatically installs and upgrades sap runtime, which can cause problems if other software on the same computer uses/requires different versions of sap runtime.
  • It is not allowed to use Smart Report Organizer on Windows Terminal-Server-Enviroment (eg. Citrix or Microsoft Remote Desktop Platform).
  • Testet on:
    • Windows: Windows 10, Windows 8, Windows 7, Windows XP
    • Windows Server: Windows Server 2019, 2016, 2012 R2, 2012, 2008 R2, 2008

Installation

Installation

  1. Download ZIP: https://www.smartreportorganizer.com/home/download
  2. Unzip ZIP File.
  3. Run Setup.exe
    • The setup will automatically install all requirements:
      • SQL Server 2014 Express LocalDB (with SP1) 
      • SAP Crystal Reports Runtime
      • Microsoft .NET Framework
    • The setup create a shortcut on desktop:
      • Smart Report Organizer 2021
  4. Done! Now you can run Smart Report Organizer and add your first job ...

Troubleshooting

If the application does not work or fails during installation please check:

Please note

  • Smart Report Organizer requires a specific version of SAP Crystal Reports Runtime.
  • ​The setup automatically installs and upgrades sap runtime, which can cause problems if other software on the same computer uses/requires different versions of sap runtime.

Install, Uninstall, Update & Move

Smart Report Organizer 2021 has the following applications installed after successful installation:
Requirements
If the application does not work or fails during installation, then you can also install all nessasary applications manually.

Install (automatically):

  1. Download and Install: Download Page

Install (all nessasary applications manually):

  1. Download + Install: Microsoft .NET Framework (4.5.2)
  2. Download + Install: Microsoft SQL Server 2014 Express LocalDB
  3. Download + Install: SAP Crystal Reports runtime engine for .NET Framework (32-bit) (13.0.21)
  4. Download + Install: Smart Report Organizer 2021

Uninstall:

  1. Backup database (if desired): Documentation: Backup Database
  2. Uninstall (when not required by any other application): Microsoft SQL Server 2014 Express LocalDB
  3. Uninstall (when not required by any other application): SAP Crystal Reports runtime engine for .NET Framework (32-bit)
  4. Uninstall: Smart Report Organizer 2021

Update (to the latest version):

  1. Check requirements: Documentation: Requirements
  2. Make sure you have the right license for the latest version or purchase an upgrade:  Documentation: Upgrade License
  3. Backup database to be sure: Documentation: Backup Database
  4. Download the newest version here: Download Page
  5. Close Smart Report Organizer Windows Application.
  6. Stop Smart Report Organizer Windows Service if started. Useful link to find the service name: Documentation: Windows Service Settings
  7. Simply install the new version over the old one.

Move (to new computer):

  1. Backup your database from the old computer: Documentation: Backup Database
  2. Download & Install SRO on the new computer.
    (Make sure you have the right license for the latest version or purchase an upgrade:  Documentation: Upgrade License
  3. Activate your new installation with your existing license which you can find in your account here: My Account
    (If necessary, please use the "Need help? [Contact]" button in your account. Please allow 0-3 working days for a response.)
  4. Close SRO on the new computer.
    (If the Windows service has already been set up, make sure that it is not started.)
  5. Copy both database files from the old computer to the new computer:
    1. C:\Program Files (x86)\DataZimmermann\Smart Report Organizer\Db.mdf
    2. C:\Program Files (x86)\DataZimmermann\Smart Report Organizer\Db.ldf
  6. ​Run SRO on the new computer and if everything works as expected, then uninstall SRO on the old computer. (Each license can only be used once)

Backup database

Backup folder width database

For example, create a backup by simply copying the folder: C:\Program Files (x86)\DataZimmermann\Smart Report Organizer\

  • Close the Application: Smart Report Organizer
  • Stop the Windows service if started: Smart Report Organizer - Service
  • Make a copy of the folder:
    • C:\Program Files (x86)\DataZimmermann\Smart Report Organizer\
  • Save the folder to another disk.

Backup database

Create a backup by simply copying both database files: Db.mdf + Db_log.ldf

  • Close the Application: Smart Report Organizer
  • Stop the Windows service if started: Smart Report Organizer - Service
  • Copy both database files:
    • C:\Program Files (x86)\DataZimmermann\Smart Report Organizer\Db.mdf
    • C:\Program Files (x86)\DataZimmermann\Smart Report Organizer\Db.ldf
  • Save both database files to another disk.

Transfer database (with all jobs & settings) to a new computer:

  • Install Smart Report Organizer on new computer.
  • Make sure that the application (and the Windows service) is not started on the new computer.
  • Copy the two previously saved database files (from the old computer) into the directory of the new computer:
    • Safe your backup from the old computer (Db.mdf + Db.ldf) to the path of the new computer: C:\Program Files (x86)\DataZimmermann\Smart Report Organizer\

How to solve runtime problems

How to solve runtime problem

  • Description:
    Error message when opening a report and automatic delivery does not work.
    The problem can be solved by simply re-installing the runtime.
  • Error Messages:
    Message1
  • Solution:
    1. Restart your computer or server. (Don't skip this point!)
    2. Download: SAP Crystal Reports runtime engine for .NET Framework (32-bit) (13.0.21)
    3. Run: CRRuntime_32bit_13_0_21.msi with admin permissions.
    4. Click [Reinstall]:
      SAP Crystal Reports runtime engine
    5. Problem is solved now.

License

Buy & Activate license

Activate license

When you start Smart Report Organizer 2021 for the first time, you receive the following message:

Your copy is activated

Now you can choose between:

  • Free Version (3 Scheduling-Jobs)
  • Full Version (Unlimited Scheduling-Jobs)

Step by step: Free Version

  • Simple press the [Activate free version] button.

Step by step: Full Version

  • 1. Buy License here: Shop
  • 2. After your purchase, you can find your new license in your account here: MyAccount
  • 3. Start the Smart Report Organizer to see your Request-Key < screenshot step (2)
  • 4. Store your Request-Key in the license in your account to receive your License-Key: MyAccount
  • 5. Store the License-Key in the Smart Report Organizer and press [OK]: < screenshot step (4)
  •  
  • License activation

Here is the activation process at a glance:

License process

License Upgrade

License upgrade

Compare the different versions here:

  • If you have an Smart Report Organizer 2016/2017, you can upgrade to 2018 Standard license via webshop here.
  • If you have an Smart Report Organizer 2018 Standard license, you can upgrade to Business license via webshop here.
  • If you have an Smart Report Organizer 2018 license, you can upgrade to 2021 Annual license (1 Year) via webshop here.
  • If you have an Smart Report Organizer 2021 Standard license Annual license (1 Year), you can upgrade to Business Annual license (1 Year) via webshop here.

After the upgrade has been purchased, please allow 0-2 working days for the license to be upgrad in your account.

 

Features (Why Standard or Business?)

Free Version

The number of jobs that can be created is limited to a certain number.

Standard Version

  • Number of jobs: Up to 100 delivery jobs.
  • Windows service: Run as a service in the background, even when no one is logged on.

Business Version

  • Number of jobs: Unlimited (The business version has no limit on the number of jobs you can create.)
  • Windows service: Run as a service in the background, even when no one is logged on.
  • Additional Export Options (xls, xlsx, csv)

  • FTP Upload Feature

Settings

Mail (SMTP) settings

Mail (SMTP) settings

To send emails from Smart Report Organizer you need to first configure a smtp server:

  1. In Main Window select [settings]
    1. Server: The Name of the mail-server. (Example: smtp.chello.at)
    2. Username: Your email address
    3. Password: Your password
    4. Port: The Port (Example: 25)

Example for gmail

Example for Office365

  • Mail settings office365
  • Tip: If you get the following error message, you have to make sure that the reports are not sent at the same time: "4.4.2 STOREDRV.ClientSubmit; sender thread limit exceeded ..."

Note: Please contact your server administrator for the correct settings.

Windows service settings

Windows service settings

In Smart Report Organizer it is recommended to use scheduling with windows service.
(With the windows service, the application can be closed and no one has to be logged on to the computer.)

Step1: In Windows Services (press [WinowsKey]+[R] and run services.msc), find and double click Smart Report Organizer - Service to change properties.
windows service
Step2: In the Log On tab, change the account to the same user which also uses the Smart Report Organizer application and click [Apply].
It is required that the Windows service use the same username as the application. Otherwise, the application can not be started while the service is running!
windows sevice step2

Step3: In the General tab, change the startup type to Automatic, click [Apply] again and then click [Start].
windows service step3

Correct account name for the windows service:

windows service step4

After successfully changing the settings, you see the service running here:
windows service step6

In Smart Report Organizer you can see and control the service here: 
windows service step7

Make sure all reports and export paths use UNC paths: Windows service cannot access mapped drives.
Examples:

  • Report path: F:\Reports\Report01.rpt does not work, use \\Server01\Reports\Report01.rpt instead.
  • Export path: F:\Reports\Report01.xls does not work, use \\Server01\Reports\Report01.xls instead.
  • Just for access (.mdb) connections: Connection with databasename: F:\test.mdb does not work, use \\Server01\test.mdb instead.

(Windows service runs in its own security context & starts before the user logs into the computer & cannot access your mapped drives.)

 


Note: Please contact your system administrator for more information.

FTP settings

FTP settings

To upload the reports to an FTP server, you have to configure the connection like this:

 

ftp server

When using an FTP tool (for example, FileZilla FTP Client), make sure that the FTP connection from your computer itself works.

Wake-Up feature

Wake-Up feature

Smart Report Organizer must be actively running to delivery your jobs.

Under [Control Panel\All Control Panel Items\Power Options] you can either disable the "Put the computer to sleep" feature from your operating system, or you can enable the Wake-Up feature in Smart Report Organizer.

The Wake-Up feature will wake up your computer 5 minutes before the next report has to be delivered.

To test this feature:

  • Save all open documents on your computer.
  • Be sure (!) you want to set your computer to sleep mode.
  • Click on the button: [Go to sleep & wake up in 1 minute]

 Note: If successful, the computer will wake up after about 1 minute.

Wake Up feature

If the Wake Up feature doesn't work, it doesn't necessarily mean that your hardware doesn't support it.
It's possible that some Windows setting is preventing the system from waking up.
To make sure that the settings are correct, please check:

  • Control Panel
  • Power Options
  • Change Plan Settings
  • Change Advanced Power Settings
  • Sleep
  • Allow Wake Timers
  • Enable

wake up feature

Configure your first Job

Add a job ...

Adding a job

  1. Click [Add]
  2. Click [Browse]
  3. In the file browser window navigate to the Crystal Report file and click [Open]
  4. Change "Name" if needed.
  5. Add a "Description" if needed.
  6. Click [Save]

add job

You have added a new job.

Configure Job Schedule Settings

Configuring schedule options

  1. Double click a Report Job to open the settings window.
  2. In the Register [Schedule] click on [Active]
  3. Choose:
    • Every Minute:  to send a report every "x" minutes. (for example every 15 minutes)
    • Hourly:  to send a report every "x" hours.
    • Specific Day: to send a report on a specific day.
    • Daily:  to send a report every "x" days at a certain time.
    • Weekly:  to send a report every "x" weeks at a certain time.
    • Monthly:  to send a report every "x" months at a certain time.
    • Specific Day of Month: to send a report on a specific day at a certain time.

Notes:

  • You can exclude individual weekdays or months.
  • The next delivery time is always calculated starting from the set time. (Example: Hourly / 2 hours / 05:00 will send a report 05:00, 07:00, 09:00...)

Configure Job Destinations Settings

Configuring destinations

  1. Double click a Job to open the settings window.
  2. Click on Register: [Destination]
  3. Click [Add] to add or [Modify] to modify an export destination

Export to file

  1. Click [Select export path ...] to open the folder browser window and navigate to the destination folder.
  2. Change [Filename] if needed. Note: Do not enter a file extension here. The file extension will be added automatically.
  3. Choose file options:
    • [Add 1. parameter to filename]:  if possible the first set parameter will be added to the end of the filename
    •  [Add current date & time to filename]: if possible the current date & time will be added to the end of the filename
  4. Choose format options:
    • [PDF]: Export the report in PDF format.
    • [Excel]: Export the report in Excel format.
    • [Excel(Data Only)]: Export the report in Excel format without formatting.
    • [Word]: Export the report in Word format.
    • etc.

Export & email a file

  1. Choose [Send mail] to attach a file to an email.
    • Note: You must set email options in Register: [Email]
    • Note: You must configure SMTP-Settings under [MainWindow] / [Settings]
  2. Choose mail options:
    • [Add 1. parameter to email subject]: if possible the first set parameter will be added to the end of the [subject] line.

Export & print

  1. Click [Select a printer ...] to open the printer browser window and navigate to the desired printer.

Note: For one job you can add multiple destinations with different settings at once.

Configure Job Parameters Settings

Configuring parameters

For more flexibility you can use a Report with Parameters.

  1. Double click a Report Job to open the settings window.
  2. Click Register: [Parameter]
    • Parameter:  Add a Report Parameter.
    • Dynamic Parameter: For Date or DateTime Parameters, you can choose between static or dynamically calculated parameters.
    • Multiple Parameters: If your report uses parameters with "Allow multiple values", then several values can be entered here.

Dynamic Date Feature Notes:

  • Dynamic Date Feature will always be calculated when the job starts.
    • Example:
      • Choose [Today(Days)] with Offset [+3] to calculate the date in 3 days.
      • Choose [Monday(Weeks)] with Offset [+3] to calculate the first Monday in 3 weeks.
  • Dynamic Date Feature only works for Date or DateTime parmeters.
  • Dynamic Date Feature will not work for Date-Range parameter (Allow range values = True or Allow multiple value = True)
    • In this case simply use 2 Date Parameters instead of 1 Date-Range-Parameter:
      parameter
    • parameter datefrom dateto
  • Dynamic Date Feature always works with a time of 00:00:00, even when working with DateTime. ​This will be problematic if you try to calculate a a time span!
    If the time does not matter, then just filter (for example): DATE({YourTable.YourDatetimeField}) in DATE({?DatetimeFrom}) to DATE({?DatetimeTo})
    But if the report should filter the records by time, then you have to specify date and time in separate parameters.
    Example:
    • DayFrom                                     Date Parameter
    • DayTo                                          Date Parameter
    • TimeFrom                                    Time Parameter
    • TimeTo                                        Time Parameter
    • DateTimeCalculatedFrom           Formula Field with:                  DATETIME({?DayFrom}, {?TimeFrom})
    • DateTimeCalculatedTo                Formula Field with:                  DATETIME({?DayTo}, {?TimeTo})
    • Report Filter:                               {YourTable.YourDatetimeField} in {@DateTimeFromCalculated} to {@DateTimeToCalculated}
      Example Report

Sort order parameters:

  • The order of the parameters is defined in the Crystal Reports itself.

Configure Job Connections Settings

Configuring connections

When a report is added, all available connection settings from the report will be added to the [Connections] register.
If your report requires login credentials, you can enter them there.
You can also override the connections settings if needed.

Recommendation:
Crystal Reports is not required on the computer but it is highly recommended:
You can easily determine if ODBC driver or ODBC settings are missing which are needed for the report.

Microsoft SQL Server - example:

  • Windows Authentication mode:
    Connection Settings
  • (No user or password is required and Integrated Security must be enabled.)
  • SQL Server and Windows Authentication mode:
     Connection Settings Step2
  • (It requires user and password and Integrated Security must be disabled.)

For ODBC connections please use 32-Bit:

Odbc Settings

 

Example: Access via ODBC:

Odbc Settings Step2

Example: Microsoft SQL Server via ODBC:

Odbc Settings Step3

Configure Job Email Settings

Configuring email settings

For the e-mail to work you must observe the following 3 points:

  1. Configure SMTP-Settings in [Main-Window] / [Settings].
  2. Configure a destination in Register [Destination] with the [Send mail] option.
  3. Configure a Sender and Recipient email address in register [Email]

HTML Email:

An example of an HTML email looks like this:

Email Example

Use the following code:

<!DOCTYPE html>
<html>
<head>
    <meta content='text/html; charset=utf-8' http-equiv='Content-Type'>
    <style type='text/css'>
        body {
            font-family: "Calibri","sans-serif";
            color: black;
        }
        .medium {
            font-size: 9pt;
            font-family: "Calibri","sans-serif";
            color: #666666;
        }

        .small {
            font-size: 9pt;
            font-family: "Calibri","sans-serif";
            color: #666666;
        }

        .xsmall {
            font-size: 9pt;
            font-family: "Calibri","sans-serif";
            color: #666666;
        }
    </style>
</head>

<body>
    Hello!<br />
    <br />
    Here is your report...<br />
    <br />
    <div class="medium">
        Kind Regards<br />
        <br />
        Department | Company<br />
        Street | Postcode City | Country<br />
        <b>Phone:</b> <span class=blue>+12 23456789 | <strong>Email:</strong> <a href="mailto:example@example.com">example@example.com</a></span>
    </div>
    <div class="small">
        <strong>VAT: </strong>
    </div>
    <br />
    <div class="xsmall">
        <strong>Disclaimer:</strong><br />
        <strong>EN:</strong> The information contained in this communication from the sender is confidential.<br />
        It is intended solely for use by the recipient and others authorized to receive it.<br />
        If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.
    </div>
</body>
</html>

Here:

Email Example Code

Run your jobs ...

Run you jobs ...

You can choose between 2 export modes:

  1. Application Scheduling (Free Version)
  2. Windows Service Scheduling (Standard & Business Version) (Recommended) (See: How to configure windows service)

Correct:

Scheduling Modus Start Stop

Wrong:

Scheduling Modus Stop Stop

 

 

Update a job ...

Update a job ...

If the source report (.rpt file) is modified (Parameters or connections have been changed) then the job needs to update the parameters and connection setinngs. You can do this by clicking the [Refresh] button in the top right corner of the job settings:

  1. Click [Modify] job.
  2. Click [Update/Refresh] Button in top right corner.

Update Job

Note:

  • In this case you must check the settings in the following registers: [Parameter] + [Connection]
  • The settings in the following registers are not affected: [Schedule] + [Destination] + [Email]
     

Copy a job ...

Copying jobs

  • Right click and select [Copy] to copy all selected jobs including all settings.

 

Delete a job ...

Removing a Job

  • Right click and select [Delete] to remove all selected jobs. (Warning: This action cannot be undone!)

Copy settings ...

Copy scheduling settings from one job to another

  1. Select a job with the desired settings.
  2. Click [Copy settings ...] to copy all settings from the source job in the cache.
    Note: Upon clicking on a job, you will notice the button [Insert settings ...] is now enabled.
  3. Select one or more jobs that you whish to copy the settings to.
  4. Right click and choose which settings to you want to insert:
  • Choose: [Insert schedule settings] to copy all schedule settings from the source report.
  • Choose: [Insert mail settings] to copy all mail settings from the source report.
  • Choose: [Insert destination settings] to copy all destination settings from the source report.

Manually display and export a job

Manual viewing and exporting

  • Viewing: Right-click on a job and click [View Report] to show the report immediately.

  • Exporting: Right-click and select [Export] to export all selected jobs immediately.

 

Log window

Log

In the log window you can see every report export: When was the report created and to whom it was sent.
If the export did not work, you will see the error message in it, which can be very helpful to you in solving the problem.

Delete logs:

  • Click [Delete] to delete all selected log records.
  • Click [Delete All] to delete all log records at once.   

(Please delete logs regularly. Otherwise, this can have a negative impact on performance.)