Reporting and analytics FAQ — page 6
All FAQ topics / Reporting and analytics
293 questions · page 6 of 8
What are the practical requirements and caveats for running Business Reporter Execution Server (BRES) internally — does it need a specific Excel edition, and is it reliable to run unattended on a server?
Scheduled tasks/reports show a date/time in their schedule that doesn't match the time zone configured on the logged-in PC, even though most other screens in the client display date/time using the PC's local time zone — which time zone is actually being shown for schedules?
A Lobby element built on a Quick Information Source (QIS) view as its data source fails to preview with 'Page Parameter " is missing' — is this a limitation of using a QIS view as a Lobby data source?
Is there a way to bypass the interactive print/email dialog for a document like a Customer Order Confirmation and have it silently print or archive per Report Rules instead — specifically for orders that are credit-blocked, where the normal Order Type workflow (which would otherwise auto-print without the dialog) can't resume automatically?
Is there a way for Mac users accessing the Aurena client to run Business Reporter, given there's no native Mac executable for it?
Sending an email from the PDF/print dialog of an Order Report works fine when logged in as IFSAPP, but fails for an ordinary end user — permissions and events for this all look correct. What actually determines the sender/from address used?
A Crystal Report using a procedure from a custom PL/SQL Utility package as its data source loads and renders correctly when previewed directly in the Crystal Reports designer, but fails with 'The table could not be found' when run through the actual application/Crystal Web Service, even with EXECUTE granted on the package to both IFSSYS and IFSPRINT. What's the actual limitation here?
Previewing a Crystal report throws a 'Crystal Decisions Shared Util' exception on a 64-bit Crystal Web Service / Oracle Database Client / runtime setup, even after reinstalling CWS, with logs showing no clear underlying cause — what's worth checking?
Setting up a 64-bit Crystal Web Service on a new/cloned server, every configuration step appears correct (TNS entry created, Java/environment variables set, IIS configured, 64-bit CWS and runtime installed), but requesting a saved report still fails with an HTTP 500 error or 'failed to load database information' — what's worth double-checking when everything looks right on paper?
When a report in one user's Report Archive is forwarded to another user or distribution list, the recipients automatically get a system-generated email about it that users find confusing and want turned off — where is this controlled, since it doesn't appear to be a Custom Event?
Is it possible to customize the font, font size, or add extra information (like who ordered it) to the layout used by the classic client's RMB > Output/Quick Print option?
A Report Rule that correctly forces a specific layout when printing one Shop Order at a time gets completely ignored when multiple Shop Orders are selected and printed together in one combined job — what setting controls whether a Report Rule applies to a multi-record print job at all?
Report Designer stops opening any RDL layout at all — clicking to open a layout does nothing, with no error message shown — what's worth trying?
An .rdl Operational Report (like a Customer Invoice) shows the parent/holding company's name instead of the actual subsidiary company the document belongs to, even though the invoice is genuinely created for the subsidiary company in IFS — how is this corrected?
Is it possible to convert a normal table row into a genuine Table Header in Report Designer, or move an existing repeating table into the Repeating Header section?
SAP Crystal Reports Server (not IFS's own Crystal Web Service) fails to connect to the Oracle database when running reports against IFS data, even though the connection details look correct — what's worth checking regarding the Oracle client driver bitness?
A Crystal Report always prompts for a database login when run through Quick Report, instead of logging in automatically the way other reports do — what's the fix?
How are 'PDF Inserts' actually configured to attach mandatory supporting PDF documents (like terms and conditions) to an Order Report such as a Purchase Order?
'IFS Data Source' suddenly stops appearing as an available embedded connection type in Visual Studio/SSRS when working on Operational Report .rdl files, even without having made any deliberate changes (reinstalling/updating Visual Studio itself didn't fix it) — what resolves this?
Is it possible to make a Crystal Report (run via a Quick Report RMB on a Shop Order) print a number of copies equal to a field's value (like Qty Complete), with each copy showing its own sequence like '1/5, 2/5, 3/5...'?
Report Definition's RMB > Set Default Life Time controls how many days a report stays in the Archive — what does a value of 0 actually mean, and who should be responsible for setting it?
Is it possible to call a custom PL/SQL package function (like `Delivery_Route_API.Get_Description(ROUTE_ID)`) directly inside a Crystal Report Quick Report, without joining the underlying table the function itself looks up?
A Quick Print printout shows 'IFS' as the company name by default instead of the actual company's name — where is this changed?
Setting up Crystal Reports 2016 with Oracle Client 12 to connect to the IFS Oracle database fails in Crystal's own Database Expert (Oracle Server option), even though the exact same credentials connect successfully through SQL Developer — what's commonly wrong with the Oracle Client setup itself?
Crystal Web Service stops working (authentication failing) after copying/refreshing a Live database into a Test database — is reinstalling Crystal Web Service required to fix the mismatched IFSSYS password, or is there a simpler way?
Two Custom Menu items trigger the same Crystal Quick Report, but each needs a different fixed True/False value passed to a Crystal parameter (to show or suppress a Summary section) — without letting the user change that parameter at runtime. Passing a literal static True/False value to the Quick Report parameter doesn't work as expected — what's a working alternative?
Some other database platforms have an 'EXCEPTION JOIN' construct for excluding rows in one table that have no matching row in another table — what's the Oracle/IFS equivalent for a Quick Report or SQL query?
A Report Designer report has two separate result sets/tables that need to always print on separate pages — never sharing a page even if the first data set is short enough to leave room — how is this forced?
A Report Designer table splits across multiple pages — is it possible to show a running/page-scoped total (just the rows on that specific page) rather than only the overall total for the whole table?
Is there a function to add a fixed number of working days (excluding weekends, and ideally excluding configured public holidays too) to a date in a Quick Report or SQL query, rather than plain calendar-day arithmetic?
A report built with the Excel layout format shows a working print-preview on an Apps10 environment, but the same Excel layout plugin never shows a preview on an Apps9 environment — is this a configuration problem?
A Quick Report joining several tables, with correlated subqueries in the SELECT list, returns only a handful of rows but takes excessively long to execute. What general techniques help speed up this kind of query?
Building a dynamic URL string inside a Report Rule's email text (for example a link containing query parameters like `?invoice_number=CD1234&amount=200`) silently drops everything after any `=` or `&` character — quoting the string in single or double quotes doesn't help. What's the fix?
A Quick Report / Data Set expression calling a custom API method to pull in an extra field (e.g. something like `&AO.Some_API.Get_Some_Value(ORDER_NO)`) throws an error, while a very similar expression for a different field on the same record works fine. What commonly causes this?
A Lobby Link Element can successfully open the generic report dialog box for a report family (for example using a syntax like `ifsrep:ORDER_REPORT_DIALOG`) — how do you instead link directly to running one specific named report, skipping the dialog/search step entirely?
Is it possible to translate Report Designer report text, including custom strings that were specifically added into a report, and where is this actually configured?
A Quick Report's correlated subquery using `FETCH FIRST 1 ROWS ONLY` (meant to pull just the first matching supply order per part) only returns one row for the entire report instead of one qualifying row per part, even though multiple parts clearly have their own qualifying records. What typically causes this?
Setting up Crystal Reports (Designer XI or a similar version) against IFS9, what registry configuration is actually needed, and is it required for every single report?
A Quick Report currently has 12 hardcoded monthly columns — is it possible to make the report instead show a rolling window of 12 months, dynamically starting from whatever Starting Date parameter value the user enters?
No questions match. Try a broader term or reset the filters.