RSS Feed
Knowledgebase : Report Runner Batch > Articles
   

VIDEO TUTORIAL FOR MANUAL INSTALL: https://support.jeff-net.com/index.php?/Default/Knowledgebase/Article/View/53/5/video---installing-report-runner [https://support.jeff-net.com/index.php?/Default/Knowledgebase/Article/View/53/5/video---installing-report-...
QUESTION: My Crystal report won't run. What's the problem? ANSWER: There are a number of possible reasons: 1) Does it work in Crystal Reports? This is always the starting point. If your answer is "I don't have Crystal Reports" or "I don't know Crystal...
QUESTION: My scheduled reports won't run but it works fine when I run them manually. What's the problem? PRE-ANSWER: It is important to understand there is ZERO difference between how a batch is run manually or scheduled using Report Runner Batch. Z...
Other than "Thank you!" and "You guys are great!", the most common phrase we hear doing support is "BUT IT WORKS IN CRYSTAL REPORTS!"... here is the LOOOOOONNNNNNNNGGGGG answer to that phrase/question... --- First off, we understand that it works in C...
In release 2013.90, we developed scheduling reports and added them to our System Reports directory. Our System Reports (End of Batch Notification, Batch Message, and now these scheduling reports) get installed with the full installer, but not the updater ...
We have many customization options for our software products. We use simple INI files to make these settings available. JNRRV.INI is the settings and customization file for Report Runner Viewer. JNRRB.INI is the settings and customization file for Rep...
This document is written to remove any grey areas in our licensing and support policies. This is not a "legal jargon" document. It is an attempt to give an extra clear, detailed, explanation of what is covered in your licensing, what we will and will not ...
PROBLEM: The error "Cannot find table 0" can occur when you delete all records in an XML file, and then try to open it and read it. We have seen this happen when users delete all of the records in the Scheduler XML-based database (including deleting our "...
PROBLEM: If you get an access violation in IRSETUP.EXE while trying to run our installer   SOLUTION: Make sure you are using an ADMINISTRATOR level ID with Add/Remove Programs (or the likes) to run the installer If that doesn't work, check your DEP ...
ERROR: A Number, Currency Amount, Boolean, Date, Time, Date-Time, or String Is Expected Here EXPLANATION: You're getting the error message "A Number, Currency Amount, Boolean, Date, Time, Date-Time, or String Is Expected Here". In general, this happens w...
INQUIRY: I want to schedule my Crystal Reports templates at night time and on the weekend. Is there a way to batch up my reports and do this? SOLUTION: You want our Report Runner Batch [http://jeff-net.com/products/crystal-reports-scheduler-automation] ...
ERROR: Microsoft ODBC Error - Logon Failed. I can't view my report. EXPLANATION: After clicking the VIEW button the report is processed and then this error appears... "Logon Failed. Details : IM002:[Microsoft][ODBC Driver Manager] data source name not fo...
QUESTION: How do I know what version I am on? ANSWER: There are two (2) ways to verify your version of Report Runner. * Simply select the HELP menu at the top and then select the DEBUGGING button. A drop down menu will be available for you to se...
Problem: Report can not be found (Error: Report file does not exist) Solution: If it's saying the report file doesn't exist, you are probably trying to run a report off the network and not the computer the service or scheduled task is running on. Tha...
PROBLEM: If you set an Administrator Password during your Report Runner installation for Report Runner Batch (or for the Administrator application) and find you no longer want this Sign On option (or you do not remember the password), this is how to chang...
We have a built-in utility to the Report Runner executable (Report Runner Unified.Exe) to update your Report Runner Batch XML files externally. This is necessary for updating your XML files dynamically and then running your Batch XML file on-demand via th...
Problem: If you have a report being sent as a CSV file via Report Runner Batch (JNRRB) and have the problem where the report has " around the text fields. When you output the file to CSV from Crystal there are no speech marks at all in the file...
PROBLEM: This error message "Invalid Export DLL or Export Format" exporting to Excel XLS is generally triggered by Crystal Reports templates connecting to Oracle via the Oracle ODBC driver (instead of Microsoft Oracle ODBC driver). There is an issu...
INQUIRY: What authorities/permissions are needed for the Report Runner Batch User when creating and running a scheduled task? ANSWER: A Report Runner Batch User manually running a batch needs read/write access for primarily two things: 1) All sett...
Problem: Unwanted/duplicate text characters (such as the letter "t") are being added to the report when exported to PDF. A printed report and exporting to text seems to be fine.  Solution: After doing some Googling, this is a k...
INQUIRY: How do I set up or configure my GMail SMTP Server for Report Runner Viewer or Report Runner Batch? --- SOLUTION: * Set your SMTP server to whatever it is (smtp.jeff-net.com) * Set your email account to whatever it is (bob@jeff-net.com...
PROBLEM: I'm having a challenge with bundling emails. I want to group like emails together. One batch bundles fine, and the other batch does not work. How can I fix this? SOLUTION: The trick to the "bundling" of attachments is making sure the ...
QUESTION: How do I set up a report to be sent via text message? ANSWER: You simply create a report that when exported via text, it exports only your text message (your custom alert... like a stock count or total critical tickets, etc). Then set th...
QUESTION: Is there any way to remove the message "Generated by Jeff-Net Report Runner Batch" from the footer section in the emailed reports? ANSWER: In your JNRRB.INI [https://support.jeff-net.com/index.php?/Knowledgebase/Article/View/98] file (in R...
If you're getting installation errors installing the Crystal Reports runtime engine, running our FULL Report Runner installer, make sure you're installing with administrator permissions, and please try the following two steps... Note: If you are simply ...
QUESTION: Is there a way to test an OLE DB connection? I'm trying to run a report on a new machine and it is getting a database connection error. ANSWER: Yes. As long as you know the OLE DB connection information from your report (you can see this in Cr...
QUESTION: Is there a way to get volume discounts on licensing? ANSWER: For Report Runner Viewer, it's already built into the webstore. The more you buy, the less your licenses will cost. You might ask, well if I buy 15 now and 10 later, can I get the 25...
Q: Will Report Runner Run On Windows X Operating System? A: To answer this question, we need to answer based on the version of our software that you're using. We will give a short answer first, then give a long answer as to why. 2016 USERS: 2013 (prev...
Effective August 1, 2012, we have increased pricing of legacy software (versions 8.5, 10, 11, and 2008). We are increasing prices to cover additional costs of licencing time and support. THERE ARE NO ADDITIONAL LICENSING COSTS TO MOVE TO THE NEW RELEASE (...
QUESTION: How do I obtain the log file for Report Runner Viewer or Report Runner Batch? --- ANSWER: We are here to help you! When you contact us for support, we will always request the log file to know how to best serve you with your particular re...
PROBLEM: Windows Task Scheduler Fails With Error Code 2147943785 SOLUTION: This is usually due to a permissions issue. It's due to the user that is running the scheduled task not having the Log On As Batch Job assignment. To fix it, have your Network Ad...
QUESTION: How can I send secure certificate signed mail (S/MIME) from Report Runner Batch? ANSWER: Just follow these steps: 1) In Report Runner Batch, go to Home, Settings, Mail Settings Tab, Click on SSL/TSL/SMIME button 2) Select S/MIME 3...
ISSUE: We have a report that uses an IDAutomation barcode font. The report renders correctly, but when exported to PDF, the barcode is drastically shrunk and unscannable. In Crystal 11, this issue has been fixed with a couple of registry entries but we...
PROBLEM: When I export to PDF, my images (JPEG, JPG, PNG, BMP) are low resolution or fuzzy. How do I get them clearer and "cleaner" looking? SOLUTION: In Crystal Reports, open the report (RPT file), and go to File, Report Options, and check (turn on...
QUESTION: I am a current customer using Report Runner Batch... can I get a temp license for testing or a license for a backup server? ANSWER: First off, when you install our software on a new machine for the 1st time, it will run for 3 unique (not seque...
QUESTION: We operate in a virtual environment. We test and image various machines and deploy them to a production environment. When we do this, it breaks the Report Runner licensing. What can we do? ANSWER: We offer 4 ways to handle licensing in these e...
REPORT RUNNER VIEWER AND REPORT RUNNER BATCH (AND CRYSTAL RUNTIME ENGINE): * PROCESSOR: Intel Pentium III or higher (or equivalent processor) * MEMORY: 256 MB RAM, 1 GB+ recommended * DISK SPACE: 1 GB * OPERATING SYSTEMS: Microsoft XP SP2 or hig...
QUESTIONS: 1) How can I customize the output file name in an emailed or FTP'd job? 2) How can I put a long date or use a report variable in the email subject? 3) How can I automatically add a date/time stamp to an output file? 4) I have global dat...
PROBLEM: You need to move back to a previous service pack of the Crystal runtime engine. If you try to run an "older" installer, it will not install. ANSWER: The only way to fix this issue is by manually uninstalling the current service pack, cleani...
PROBLEM: I'm having problems logging into MAS 90 (Sage 100). Where do I put the company name to use for login? ANSWER: The company name must be put into the DSN itself. There is no way to enter it into the interface manually. SEE THIS SCREENSHOT: ...
PROBLEM: My reports connect to MySQL. The driver I use is the MySQL 5 driver (myodbc5.dll). ANSWER: The Crystal runtime engine does not work with the MySQL 5 driver. SEE THIS SAP LINK REGARDING MYODBC AND THE MYSQL 5 DRIVER: http://scn.sap.com/thr...
PROBLEM: I've typed values into the Parameters window from the Job window in Report Runner Batch. The report is failing, and it appears to not be using what I typed in. ANSWER: You're typing the values into the drop-down lists. Those drop-down...
Problem: The date expressions are not displaying for my date-based parameters. Answer: Make sure your parameters are actually a date datatype and not a string. Also make sure they are not date-time instead of date or modify the date expressions to b...
PROBLEM: I'm running a batch and internal email addresses are getting my job output, but external email addresses are failing. ANSWER: Assuming the email addresses you're using for the external tests are legit, the issue is at your email serve...
NOTE: The 64-bit edition of our software is available only to INFINITY customers. IMPORTANT: These are NOT pre-requisites for installing the 32-bit edition of Report Runner on 64-bit machines. These are pre-requisites for installing the 64-bit edition o...
SAP has a number of recommended tools for debugging Crystal Reports related DLL issues. The two we recommend from this list the most is Modules and Process Monitor. Follow this link to a KB article on SAP's website: http://scn.sap.com/community/c...
Did you know you could customize your Crystal Reports exports to Excel (XLS, XLSX) and Text (TXT) formats? Report Runner Batch (and therefore Report Runner Web Portal) allows for setting EXACT export options to match your Crystal Reports export options...
* Add all your reports/jobs to a single batch. * Set them all for File output to XLS or XLSX (whatever you're looking for); easiest to stay with default output directory, BUT BE SURE AND GIVE THE OUTPUT FILES UNIQUE NAMES * Set/Name the tab names (r...
Q: What Is Global Monitoring? A: Global Monitoring is an optional feature that enables tracking of any-and-all report running within our software. Whether it's running a report in Report Runner Viewer, or running a batch or schedule of reports in Report...
Assuming you have used the recommended storage settings for Report Runner Batch, it's very easy to move from one machine to another. * Run the full installer to install Report Runner Batch on the new machine. And be sure and RUN THE CURRENT/LATEST FUL...
You can do multiple "things" with one report, but not all in one job. Our software is very batch-centric. You can do anything, but sometimes you need to create multiple jobs in one batch. If you have a fast running report, you can simply use the CLONE opt...
It's easy to archive report output in Report Runner Batch. A common archive request is to email a report and retain a copy of it in an output folder. Just follow these simple steps: * In your Global Settings/Options, click on the Archive tab and con...
PROBLEM: Hyperlinks (URLs) are missing in Excel exports. ANSWER: "Excel Whole Report" will work, but the other export options will not. The data only exports from Crystal Reports are meant for "just the data only" and no extra formatting. That's w...
PROBLEM: You're getting an error 1064 in Crystal Reports or Report Runner, unable to log into and/or connect to database, and you use MySQL. ANSWER: Make sure you do NOT have a dash in your database/table/schema. For example "jn-database" will cause...
PROBLEM: Report output is not formatted correctly (whether printed or saved to PDF). Items are misaligned, completely unreadable (garbage output), or certain fonts are not displaying cleanly. You might even have poundsigns/hashtags where numbers should ...
PROBLEM: You need to schedule a batch to run on multiple random dates or you need to schedule a batch in a very custom way that we do not make easily available in our Scheduler interface. ANSWER: You'll need to create a CUSTOM schedule. This is how ...
PROBLEM: You want to upload and/or archive your reports to DropBox, OneDrive, or other file storage systems. ANSWER: An export to DropBox or the likes is as simple as doing a normal File export to a directory. On a machine, you have access to Drop...
PROBLEM: You're looking for a way to set extra settings for your FTP server. You want to be able to change the method to SFTP or the like and/or change the default port that FTP uses. ANSWER: Yes, you can customize FTP server settings. You do this i...
QUESTION: Is there a way to use the various jnVariables found in this jnVariables document [https://support.jeff-net.com/index.php?/Knowledgebase/Article/View/76/0/naming-output-files-date-time-stamping-and-jeff-net-variables] in Global Expressions? I s...
PROBLEM: You're getting a login error for your report that looks something like this: "Problem while checking for records in jnDoesReportHaveRecords. Message=The table 'Sheet1_' could not be found. Error in File SomeReport.rpt: The table could not be ...
QUESTION: How do I copy a job (report) from one batch to another? ANSWER: There is not an easy, built in way to do it, but you have three options: 1) Launch two Report Runner Batch instances at once so you can edit two jobs and copy/paste various f...
First off, make sure you've configured your mail settings. If you've never configured them, mail will not work at all. In Report Runner Batch, go to your Global Options/Settings, and click the Mail tab. Follow the instructions and TEST your mail settings....
In your batch-specific INI settings, you can set CC and BCC settings. There is a CC1, CC2, CC3, BCC1, BCC2, and BCC3 setting. You can actually have multiple email addresses for each setting (separated by semi-colons). NOTE, THESE BATCH-SPECIFIC SETTINGS ...
QUESTION: How do I take multiple XLS or XLSX output files and merge them into one (and have multiple tabs)? ANSWER: Follow these steps. 1) Create a batch that does either XLS or XLSX, all exporting to FILE (any directory), with unique output names...
Scheduling in Report Runner Batch is quite easy. As you know (or maybe you don't know), our Report Runner Batch Scheduler utilizes the Windows Scheduler to run the schedules. The Windows Scheduler is super reliable (it's developed by Microsoft and is buil...
There are two main options for merging PDFs: 1) You can merge all the PDFs created within a single batch 2) You can merge PDFs created externally to a batch (or from previous batches) during a burst Both options are configured using your batch-speci...
Q: What Are Batch-Specific INI Settings? A: When you open a saved batch or save a new batch, you'll see the INI button is enabled. If you click INI and right-click in the window, you'll see a TON of options to customize your batches. We keep everything ...
This is a list of registry settings the originally came from this link provided by SAP [http://ow.ly/NINSW]... --- * Crystal Reports 9 * Crystal Reports 10 * Crystal Reports XI * Crystal Reports XI Release 2 * Crystal Reports 2008 * SAP C...
Setting your license is super simple. The hardest part is copying the long key... after that... copy, paste, apply. Easy! When you order a new license or renew a license, you will receive an email from us. There will either be a text file (.TXT) or lice...
A SuperBatch(tm) is simply a batch that triggers another batch upon completion. --- HOW DO YOU CONFIGURE A SUPERBATCH? When you open an existing batch or save a new batch, you'll see the INI button is enabled. This enables you to set your batch-spec...
Anytime that pop-up screen appears asking for credentials for the Crystal runtime engine, it means that proper credentials have not been already set. That is not a pop-up from Report Runner Batch; it's the Crystal runtime engine prompting. This pop-up wil...
PROBLEM: Crystal Reports Fields Are Chopped Off Showing ##### instead of the full field value. --- ANSWER: This is not a setting in our software (and it's not a bug either). It's a Crystal Reports formatting issue. You need to widen the field us...
ERROR MESSAGE: Configuration Parser Error - Error Parsing C:WindowsMicrosoft.NETFrameworkv4.0.30319ConfigMachine.Config Parser Returned Error Code 0x80070005 --- FIX: The issue is permissions access to the machine.config file in the .Net folder....
INQUIRY: How do I set up or configure my Office365 SMTP Server for Report Runner Viewer or Report Runner Batch? --- SOLUTION: * Set your SMTP server to smtp.office365.com * Set your email account to whatever it is (bob@jeff-net.com) * Set yo...
PROBLEM: I'd like to get an SMS message ONLY if a batch fails (and some indication as to what went wrong) --- ANSWER: We have created a custom solution for this by modifying the End of Batch Notification Report. It's very important to FOLLOW THESE...
PROBLEM: There are numbers appended to my FTP and mail output file names. I need the output file names to be exact. How do I remove the numbering? --- ANSWER: Because you can process a number of reports in a batch, and by default, output filenames...
PROBLEM: Your PC can not reach our licensing server due to a firewall or some other internal policy. You need to configure a proxy server. --- ANSWER: In the file jnrr_license.ini, you can configure your proxy server settings. This file is found i...
"ERROR: YOUR CRYSTAL RUNTIME ENGINE HAS BEEN UPGRADED TO GREATER THAN SERVICE PACK 20 (SP20) AND THE APPLICATION IS EXPECTING CRYSTAL RUNTIME ENGINE SP20 OR LOWER/PREVIOUS TO BE INSTALLED." --- If you are getting the above message, please download and...
"ERROR: YOUR CRYSTAL RUNTIME ENGINE HAS BEEN DOWNGRADED TO LESS THAN SERVICE PACK 21 (SP21) AND THE APPLICATION IS EXPECTING CRYSTAL RUNTIME ENGINE SP21 OR GREATER TO BE INSTALLED."  --- If you are getting the above message, please download and run th...