Reporting and analytics FAQ — page 4
All FAQ topics / Reporting and analytics
293 questions · page 4 of 8
IFS Business Reporter can't connect to an IFS Cloud environment — entering the server URL with a port gives one error, and without a port gives another, and the environment also shows an invalid/untrusted certificate warning when logging in through the browser.
For a SQL-type Quick Report, is there a way to make a parameter mandatory (by default they're all optional), and is there a way to set a default value for a parameter — and where is this documented?
Is there a way to limit the size of the Print Agent's own log file (printagent.0.log) so a new file gets created once it reaches a certain size, without restarting the Print Agent service in the process?
A Unicode character (like a checkmark, ✓) added to a Report Designer layout via UNISTR (e.g. UNISTR('\2713') built into the report's XML through the RDF) doesn't actually print — it either doesn't appear at all, or breaks string concatenation with surrounding text.
A newly created, re-branded Crystal Report (a renamed copy of an existing Purchase Order report, with matching schema/data/report rules and its own Report Definition entry) fails to retrieve when printed through IFS, even though the layout file is correctly placed on the server — how do you isolate whether the problem is in Crystal Web Service itself?
The IFSCRWebSetup installer (for setting up Crystal Web Service) fails to run on Windows Server 2016.
How do you match Logical and Physical printers on IFS version 9, when the 'Task Templates' screen used for this in V10 doesn't exist on V9's IFS Setup Connection page?
Print Manager shows 'Failed to getFullXML: null Caused by: null' for a report job — how do you actually diagnose what's missing in the XML generation chain, given the error itself gives no useful detail?
Is it possible to automatically select a different report layout depending on a business condition — for example, forcing a watermarked or visually distinct layout for a Purchase Order printed while still in Draft/Planned status, versus the normal layout once it's formally Approved, to prevent a draft-stage printout from being mistaken for (or misused as) an approved document?
For a field on a Report view (a _REP view, like CATALOG_NO on CUSTOMER_ORDER_CONF_REP), how do you trace back to find which underlying table or source it actually comes from, when the _REP view's own SQL in Oracle Developer only shows a reference to its result-key lines rather than the real source mapping?
Printing a report fails with a GENREPORTIO error about 'not enough space on the disk' during the XML-to-PDF transformation step, even though the report itself isn't unusually large.
After restoring a production database backup over a Test database, Crystal Reports in the Test environment stop returning any data, even though the reports themselves and their configuration weren't touched.
A Report Designer background image/watermark still doesn't appear even after correctly setting the 'Base path for Report Designer graphics on the application server' system parameter and copying the image into the report_designer_graphics folder as documented — what else is needed?
The Print Agent (.NET) Windows service fails to start after installation, even though the service account is a member of the Administrators group — the error just says it took too long to start and failed.
Is there a way to automatically email a document (like a Supplier Return) to a supplier when a specific action happens, instead of a user manually using RMB > Print and selecting an email option each time?
When selecting multiple reports to print at once (using the 'Select All' checkbox in the print dialog) and trying to change the layout for all of them, the Preview button is disabled — is this a bug?
The Report Format & Output print dialog on a customer's Apps10 Aurena environment is missing the left vertical bar/panel that appears in newer-looking versions of the same dialog — is there a patch that adds it?
In Report Designer, is it possible to generate a single barcode that encodes information from two separate fields (like both Part No and Part Description combined)?
A Report Rule has been set up to route a specific report to a particular logical printer whenever a condition is met, but the Report Format & Output dialog still shows the user's default network printer instead, even though selecting 'show all printers' confirms the logical printer is available.
A report built from an IAL-based information source has five optional filter parameters — if a user only fills in two of them and leaves the rest blank, the report should still return matching rows filtered only by the two provided values, but instead it returns nothing at all unless every parameter is filled in.
Is there a supported way to convert a number into its written-out word form (for example, 100 into 'One hundred') on a Report Designer layout, without relying on a custom SQL workaround that breaks on certain negative or large numbers (like an ORA-01854 Julian-date error)?
In IEE/Apps10, you could email the results of a Quick Report by scheduling it through an Application Server Task — since Application Server Tasks are deprecated/removed in IFS Cloud, what's the current way to email a Quick Report's results in Cloud?
After releasing a Customer Order, a confirmation report is automatically generated as a PDF in the background (routed to a No-Printout logical printer and archived as 'Printed'), which makes the Report Archive show every released order as already printed even though the client actually wants to print each one manually later — assigning the report to a new, unmapped logical printer just produces a stream of error-status rows in the print job table instead.
Report Designer results get archived into %_REP database tables that can be queried afterward — does IFS Business Reporter store its report results in the database the same way, so they could be picked up and reused for something like generating a tax-compliant XML file?
Is it possible to replace a standard IFS operational report with a custom Crystal Report, and if so, what's actually involved?
A newly created Crystal Quick Report fails to run in IFS with an error that the layout file 'could not be found in the Crystal Layout location.'
The 'Report Format & Output' popup no longer appears automatically after confirming the Customer Statement of Account screen, even though it used to — how do you get it to display again so the correct layout can be selected?
Print jobs queued through the same printer/queue aren't processing in the order their Job IDs were created — what actually controls the processing order, and is there a way to force strict Job-ID sequence?
Exporting a report to Excel (Output > Excel) shows dates after a certain point correctly on screen but Excel displays them with the wrong century — for example, a date like 03-Jun-30 exports and displays as 03-06-1930 instead of 2030 — changing the PC's regional date format to DD/MM/YYYY avoids the problem.
An Order Report's print dialog defaults to English in its language dropdown (apparently based on the logged-in user's language or the PC's locale) — is there a way to force a different specific language, like Korean, as the actual default instead?
How do you set up a Report Rule to send a Customer Invoice to a specific email address that isn't the order's normal Reference contact (who's used for confirmation emails instead), and why does the Print Dialog not show the email address even after configuring a rule?
A customer with 60+ companies, each using a different logo, needs those distinct logos to appear correctly on reports — is there a way to support multiple different company logos across many companies, or does the standard report-logo functionality only support one logo for everyone?
The 'Send email to' option in the Print window successfully sends an email with the printed report attached, but is there a way to customize the email's subject/theme, body content, generated attachment filename, or sender address?
A working Crystal Quick Report that reads several IALs starts failing with a generic 'Failed to retrieve Report. Please contact your System Administrator' error (with no further detail) as soon as an additional IAL is added that reads standard invoice tables directly — even though the report still runs fine when connecting through Crystal Developer directly as IFSAPP.
Is it possible to add fields from a Custom Logical Unit directly into a Report Designer operational report layout — the LU has been enabled, but its fields still don't appear in the report's underlying XML?
Creating an Information Source from a selected Quick Information Source (QIS) fails with an error partway through creation.
An Information Source has already been created from a QIS draft, but there's no visible option anywhere to move it back to Drafted status so it can be modified or deleted.
A Customer Order has two Charge lines, but the Invoice operational report (using the standard Charge Type / Charge Description fields) only ever shows the first one.
Connecting the Business Reporter Excel add-in to an IFS Cloud environment fails with a 'client not found' error, even after adding an IAM user and configuring the Business Reporter system parameters.
No questions match. Try a broader term or reset the filters.