Insights (Business Reporter and Analysis Models, EOI)

You can ask anything you wonder about IFS 10 Lobby. I can answer any questions you may have about IFS 10 LOBBY. Element design, data design, where patterns, references, page creation, authorization, etc. I would be happy to help.

Hello, I would like to output a logo that is retrieved from the database via a select query and 2 parameters (company and language).Since it can happen that PNGs are not available for all combinations, I would like to output a standard logo for this case using the NVL function. The select statement works in PL/SQL-Developer.Unfortunately, no PDF is generated in the Report Designer Preview. Only the rendering cursor is displayed briefly, but nothing happens, no PDF, no error message. Is a nested select or the use of the NVL function not possible?Is there anything else to consider that I have overlooked?Or is there perhaps another way? Here is my select statement: SELECT NVL((SELECT image FROM Report_Logos_Tab WHERE SUBSTR(image_name,1,4)=:1 AND SUBSTR(image_name,-6,2)=:2), (SELECT image FROM Report_Logos_Tab WHERE image_name = '0000-Logo-en.png')) FROM dual; These are the parameters: tns:PURCHASE_ORDER_PRINT_REP/tns:PO_HEADERS/tns:PO_HEADER/tns:C_SITE;tns:PROCESSING_INFO/tns:FORMATTING_

Hello, I am curently using IALs views with Quick reports in crystal. this works fine but when I try to use the IALs views in crystals layout in IFS these doesn’t work. I saw in a doc that sometimes it is better to create customs views in IFSAPP instead of IALs in IFSINFO (like IALs) so could you please give me an advice ? Thanks Frédéric

I’ve connected Tableau to IFS using the Oracle connector but I only see partial data once connected. Not sure what I am doing wrong and any help would be much appreciated. Cheers,

Hi, One of our customers getting the following error when trying to log in to the IFS BR. In his PC VS 2020 is installed and trusted locations are defined. What can I do to resolve the issue? Thank you in advance.

Dears, I create a new crystal report, but when I try to order report show blank page: is there a missing step?

Is there a way to restrict a report only to print the 1st page ?

Hello everyone, Looking for some insight on the title. Customer requires BR to generate in CSV format: Report is as follows: They required all approved expense sheet details grouping by Payroll ID and Rate. We had the ability to create an IAL for this data including the grouping as well. The Start and End dates are taken from the same field, Expense Date in IFS where Start Date shows the date for the oldest expense sheet and end date shows the newest expense sheet. However, where we hit a wall was the search parameters were based on the ‘Approve date’ which can carry many different dates so the grouping in the SQL did not work. We decided to create an IAL bearing all the data in the table plus the approve date and decided to perform all the other functions using Excel and it was a success. The report however now contained multiple worksheets and hidden cells of course due to the functions. The current solution we provided was to move all visible cells into a new workbook and save it as

We have a customer on 22R2, hosted in IFS cloud, looking to use Power BI. We’ve read the instructions here https://docs.ifs.com/techdocs/22r2/050_reporting/400_power_bi_int/010_setup_pbi_int/ but not sure what customer would do and what would need to be done by IFS managed cloud team. Has anyone done this? Thanks.

Supplier Payment screen (Screen shot below) is missing from Cloud verison.I have below doubts - Although, the related business transaction can be done through mixed payment but what is the reason to discountinue the process. How previous transaction can be seen in upgraded environment. Note: Similarly, corresponding screen for customer, names - Customer paymeny is also discontinued.

Hello, I’m having a problem where Custom Field data is not getting transferred over to SQL database. Here’s what i have done, 1. Relations for Facts 2. Custom Attributes for Facts 3. Access View 4. Data Source 5. Deploy to SQL Server Db 6. Data Load Run 7. FACT_BUSINESS_OPP_BI_TAB table shows as NULL for CF$_EC_NEXT_STEP 8. Querying for ‘SELECT * FROM FACT_BUSINESS_OPP_BI’ shows below, Any idea why it’s not transferring any custom field data to SQL Server?

Hello everyone, We’re managing permissions for IFS Business Reporter and we’re starting to build more and more reports within the tool. As we’re training up more report designers, we’re running into a bottleneck around permissions management since each report (and each report unpublish / publish event) has to be managed separately. Thinking about how to solve this, if the report structure within Business Reporter could be an object to manage permissions, this would permit folders to be assigned to a permission set and the report projections underneath them would be inherited by the “folder” level security object. It seems to be inline with the direction laid out in the technical documentation where a practice recommended is to build a permission set for a given department and assign permissions. The folder structure we’ve built out has naturally fallen along organizational lines and it would simplify the management of report permissions. It could also remove the tedium of restoring per

Hi BR experts, I'm preparing a report in Business Reporter, and I've encountered an issue. When the customer orders the report, they receive an empty one, but when I order the same report, I receive a report with data.I tried to recreate this issue, but I couldn't do it until I turned on the debugger. When I turned it on, I received an empty report. Have you ever encountered an issue like this?Do you have any suggestions how to solve it, I mean how to ensure that when the customer orders a report using their credentials, they receive a report with data.I would be grateful for your assistance.Best regards,Adam

I am trying to run a report out of Business Reporter, using the GL Transaction info source. If possible, I would like to use the Light Item - Entry Date as a repeater, but only by the day. The system is currently repeating each time stamp. Example, I would like everything by “8/30/24 and 8/31/24” and not “8/30/24 1:23:01PM, 8/30/24 1:23:14PM, 8/30/24 1:25:57PM”.

Hello everyone, We’re running into occurrences where we make a minor change to a business report previously published in the database removes that report projection from all permission sets other than the permission set “BR_FULL_REPORT_ACCESS”. This is requiring permissions to be modified each version of the report to restore permissions back to where they were prior to unpublishing the active report. Is anyone else running into this issue? Would love to hear how others are managing permissions related to IFS Business Reporter around changes to existing reports. We’re working off the technical documentation here.

I want to add a new field named zip_code in the IFS Report Designer. To do this, I have already added a function and XML in the RPI file. I tested the function and its parameters in SQL, and the zip_code result was returned correctly. However, after saving the RPI file, the zip_code field still does not appear in the IFS Report Designer. I have saved the changes, and there were no error indications. At this stage, I also downloaded the schema in IFS CRP and tried to add it in the IFS Report Designer, but there is no layout available to display the zip_code. Did I miss a step that is causing the zip_code field not to appear when I try to add it?

I get an error when previewing a Report Studio - Designer layout in Build Place. IFS Cloud Version 24R1SU0 Can't I use a Report Studio - Designer layout in Build Place? Error:The Print Job can not be printed due to Redis queue failure. Contact System Administrator The capture below is Report ID:MODULE_REP.

Does anyone know how to build IFS Cloud specific user related RLS into the Tabular models?

I'm testing a Business Reporter , and I've encountered an issue. they receive an empty one. I would be grateful for your assistance

hello, We have a business reporter with 2 parameters: year and period. We will use the scheduled reports option to schedule this report and enter context variables (e.g. #year#, #last month#). using function parameters, we need to figure the year period (yyyymm) which will be used to filter on various report columns (e.g. last period, last year current period etc.). The issue is that if we enter year:2024 and period:7, how can we get business reporter to convert these 2 parameters to year-period value 202407 instead of 20247. Any suggestions? This is in Apps 10 (version 5.0.27).

I have noticed, when trying solve a users acccess issue for a BR report, that while in IFS Explorer, users can only see and run BR reports that their IFS access allows them to.However, if someone logs in with the standalone Business Reporter client on their PC, they can access and run all the BR reports in the system, regardless of their IFS user security settings, so the security settings are bypassed altogether.Is this a bug, or is there something that needs configuring in the system to ensure they can only see and run the same reports in the BR client that they have access to in the IFS Explorer client?IFS Explorer client version: apps 10 update 14, in house installation. Business Reporter client: Apps 10, version 5.0.24 Thanks

BR Reports refuse to be rendered as a PDF although these settings were done: There was an issue with PDFs which should have been resolved by BR version 23.2.0 (EIZBR-2617), but I am using version 24.1.1 in this case and still I am getting would-be PDFs as ordinary Excel workbooks.

Hi All, One of our customers would like to connect an existing SQL server data warehouse to their IFS Cloud. What would be the best approach to do this? We are looking into solutions like, using the APIs, information sources or using IFSINFO user combined with IALs but haven’t figured out a recommendation from IFS to do this. Thank you all for your input.

Hello experts According to the IFS Business Reporter designer’s guide we have a helpful functionality called “Highlight” in the Business Reporter. It should highlight the design rows, column and cell criteria with the press of a button and therefore assist during the report creation. Before: ​​​​ After: Problem: When I try to use the highlight functionality it doesn’t work. I am in the Design Mode and click on the Highlight button, but nothing happens: Does anyone have an idea what the issue could be? It happens to me on Apps 10 as well as on IFS Cloud. Many thanks in advance! Best regards, Lukas

Hello, We have a report we developed but has a strange column pulling no data, but cannot figure out how to eliminate the unnecessary column