Insights (Business Reporter and Analysis Models, EOI)

When a user prints a crystal report, the report needs to show the user name. Application 10.

Hi, We have SSO enabled login mechanism and would like to login to Business Reporter excel add-in using IFSAPP.We don’t see the login page even if ‘Use Single Sing-On box is unchecked.Any ideas? Thanks,Sree

Hi all,  I have two questions. how do you create a new lov for a report? I know it is possible to create a parameter that has the lov deposited, how do you do that? thanks in advance,Lena 

I am trying to create a data source in datasource designer based on a query that I am designing in query designer. The end result should be a list of all Work Orders with a Work Leader that is missing a specific competence.In Query designer, I am able to retrieve a list of ongoing Work Orders with Work Leaders and I am also able to retrieve a list of competence per Work Leader but I fail to remove the Work Orders for those with a Work Leader that has the specific competence.The filter in Query Designer seems to be applied as a final step which makes it hard to just get a list of the specific competence at hand, and eliminates the possibility to use left outer join and search for null values.Is there anyone that knows a good way to solve this challenge?

We were running the BA Execution Server on a Windows 2012 VM in three environments (Test, Acceptance and Production).In the Test environment we upgraded the Windows Server 2012 to Windows Server 2019 and the BA Execution Server was running like a dream.Unfortunately, after doing the same upgrade in the Acceptance environment (2012 to 2019), the BA Execution Server will start, but reports are not fully rendering. We get the same error message each and every time:Error occured when opening report: System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'C:\IFS_BAES\Work\1064471\SER_1.xlsx'. There are several possible reasons:• The file name or path does not exist.• The file is being used by another program.• The workbook you are trying to save has the same name as a currently open workbook.   at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPasswor

Hello,Is it possible to setup a Power BI report to run as a quick report in IFS Cloud?

Hello,I’m trying to set up tabular models IFS_INCIDENT_ANALYSIS and IFS_SALARY_REVIEW_ANALYSIS and it seems it’s missing Fact IDs referenced by above Tabular Models. It gives below error when trying to deploy tables and views to SQL Server, This environment does have some inactive components. Could you please explain the reason behind this behavior? what are the expected components that need to be active?

Hello,Below error is received when running a data load run,DataLoadScriptORAToSS - Copy Data from Oracle to SQL Server - 2 - ERROR: ORA-28000: The account is lockedAny idea why?

How can I create a column for Year to date and Prior Year to date for a designated period.  for example I want YTD thru period 7.  this is what I tried but the totals aren’t correct.  

For performance issues it is better if we can sort the columns by time . but how can we do it in the Dev Tool ?

Hi ,Can Macro be used in Business Report. looks like it is not saved when I save the report.I need to hide a column based on it’s value. Thanks 

Hello, I need to get Pdf report sent to the default Printer .when the shipment’s status change to Closed . Thanks,  

Hello community,I need to set a default value in quick report parameter.Here is my query in quick report:                            “  select *                               from customer_order                               where order_no = '12345'                                   and customer_no like '&customer_order.customer_no' “Result of “select *  from customer_order  where order_no = '12345'  “ in SQL :When executing on ifs, I got the list of all customers, it doesn’t take the filter into consideration :  Is there a solution for this please?Thanks in advance!

A beautiful good afternoon, I am currently trying to add a column from the receipt_Info view that seems to be somewhat customized. Usually I would use the “SQL Column” from the “System Info” Panel.But this one is not a regular term like “STATE” that can be used there but instead “&AO.[...]API.Decode(&AO.[...]API.[...](a list of parameters from the view)”.Can I integrate that column somehow into the information source and if so how?Best regards,Benny (Edit: typo)

Hello all, When I try to export to excel my report I am getting the following error - what does this mean please ? 

Dear All,Can anyone tell me how to Set/show GL Account balance in three column cuurent month Balance, Last month Balance, Last year Balance in business reporter? 

In the filter Criteria, I would like to include all Revenue accounts except 3034, 3037, and 3040.  however, I’m finding it only allows me to exclude one account.    Is there another way to accomplish this? 

Hi  I’m trying to get a total for multiple sections and getting an error.   Limit the range in the formula to a single section.     Is there a way I can total more than one section. here’s an example.   we are breaking benefits out to list some accounts by site but want a total for all benefits  

Hi, Is there any way to do the calculations like count, max, min using measure items in IFS business reporter? As per the point 1, I have dragged debit balance column to the report. After running it will show sum of debit balances of the accounts as per the point 2. I want to get max amount of debit balance for each account. Thank You.Regards,Deepal.   

Hi all,We are preparing for the upgrade from IFS9 to IFS10 and in the process we would like to clean up unused items as much as possible.Over the years we have created a lot of quick reports and we lost track on their functionality and whether they are still used or not.Is it possible to enable some sort of history logging on them so we can get an idea about who are still using them or at least get an insight on if and how many times reports are used?Thanks in advance for any help.Remy

Does documentation exist that maps tables and views between Apps 10 and Cloud? Needing it for a data warehouse project.

Is there a way to enable bundle execution for the “Report” action type in a custom menu? For quick reports, this is easily achieved, but doesn’t seem to be an option for Business Reporter reports. For context, I have a BR report that accepts a string with multiple values for an argument when run from the “Order Report” dialog and a custom menu that works fine with just a single value, but I’m struggling to figure out how I can get a custom menu to work when highlighting multiple rows and sending all rows as an argument value.

Hi,Does anyone know why this error is raised when scheduling a report? What are the specific permissions this user should have or how to grant access to this specific report to this user?  

How might Pen Drive Recovery import MSG contacts into Standpoint without burning through much time and exertion? How is feasible to import the information in mass without going through any inconveniences or dangers of Standpoint being crashed or contacts being altered? Indeed, there are different strategies that you might find on the web yet the inquiry is are these techniques effective? You will find that out in this blog.We as a whole realize that a MSG document is a solitary message record that contains every one of the messages, contacts, schedules, and so forth in it. In the event that you independently make a MSG record for contacts, just a single contact will be saved in a .msg document. In some cases, clients might need to import .msg contacts into Viewpoint 2010, 2013, 2016, and 2019, which is the reason we are referencing helpful arrangements here.There will be two simple techniques made sense of in this blog. One is an immediate strategy for bringing in the information which

Footer and Header, Labels  of order report can do Hindi Language in report designer