Insights (Business Reporter and Analysis Models, EOI)

Hello, I have one strange thing happening with IFS. Sometimes fields in Shop Order screen are blacked out. (See screenshot.) the user can see the information if is clicked on the cell.  Any idea how I can fix this? We’re still under Apps8     With respect,    Andre 

We are using app 9 and we made lobbies. There is not any problem with data or images from the desktop. But in the web lobby, some of the data of elements are not seen. On the mobile side, Android phones show images but, iPhones are not. Also, mobile devices not shown some of the data of some elements.  Has anyone faced this?   

Hello IFS Community, Can somebody point me to the best path to find solution to the following issue?I am running Crystal Report XI R2  and my  IFS 9.  

Hello Community, I have an issue all the time when I try to run a crystal report in IFS is asking for log-in information. See Fig 1for details.I read that I need to add ( \ ) for table and (\\) for view. See Fig 2.  I already ran the script for Crystal XI R2 to be able to add the InvalidAlias and I was able to rename the tables. See Fig 3. However, when I try to run the report one more time still asking for log in information one more time.What else do I need to do? Please, I need help :-( . FIg1Fig 2Fig 3 

Hi, When creating a BR report the developer has used quick information source which containing the "DIM_ACCOUNT" and “DIM_COMPANY” standard dimensions. Inside the report design, there is a parameter for the account. Since the company is the parent of the account, They have used a company parameter as well.when the user orders that report from IEE, There is no LoV option for the account parameter. When ordering it through the business reporter excel add-on, once click the LoV option of the account parameter it will pop up the company LoV as a prerequisite. (Please note that there is a separate parameter for the company and the user should select the values for the company before selecting the account parameter)This company and account parameter LoVs properly working for some BR reports. Therefore I have compared the dimension joins of both information sources and there is no considerable changes.If you have any suggestions or information regarding this matter please let me know. LoV – L

I create report in crystal reports, after I insert in IFS through “Create new Quick Report” window.In crystal reports I enter multiple parameters. But in IFS how I pass multiple values in single parameter.

After I run a report I am getting the following message:  Any Idea how could I fix the error? 

The following error appeared at 01:19 in the morning when hardly anyone was on the system.The report is scheduled to run.Template rendering Exception:  Unexpected error while calling server method OrderXlrReport/SaveRenderedReport, Exception of type 'System.OutOfMemoryException' was thrown.. Error not related to report design. Therefore report not saved to error folder. Last successful execution log entry: Template file ORDER_INTAKE_AND_SALES_V1_1(215169) closed Any ideas how I can get to the bottom of the “System.OutOfMemoryException” error?Thank you. John 

Is it possible to create a Business Reporter report using information from multiple data sources?Any information will be greatly appreciated.Thank you.

Hello,I am developing a quick report in IFS. I know that CR_WEB_INIT has to be added however I am not able to locate it. Please advise under which category it should be. I looked everywhere especially under shaw1app.  Thank you!

I am looking to upgrade to Crystal Report version 2016, I read the Crystal Report version 2020 is not supported 100% by IFS 9. I am currently using IFS 9

I am wondering how could get the INFO SOURCE data source type to have dropdown option for parameters.  

BR Execution Server Error - Template has design errors.  View trace file for more detailsI located the Error folder and extracted the DSRD file.   Is there an easy way to find where the report is failing. Thanking you.

If the report is ran by the report designer or logged in as IFSAPP the BR report displays figures.We have checked that the report has been granted to the appropriate permission set. When the user orders the report using Order Reports the report is processed and a message is displayed prompted whether or not you wish to view the report.   On viewing the report no data is being displayed. Any ideas?

IFSSSRS extension certification question on Apps10.Please let me know if the IFS SSRS Extension is certified for SQL Server 2019 standard edition on Apps10 track. I have seen certification and installed IFS SSRS Extension on SQL Server 2016 and 2017 on Apps10, but I have not seen certification for SQL Server 2019. I have used SetupIFSReportDataExtension.exe file previously for SQL Serve 2016 and 2017 SSRS extension installation on Apps10. 

BR reports that have worked previously are erroring stating an error in design.  Having been advised that no changes have been made to the reports.  It was decided to restarted the BR Execution Server as NO BR reports have been processed since the 3rd June.   On clicking Stop the service does not stop and the following error appeared in the Log: An error occurred while trying to stop BR Execution Server.  Reported error is.  The service cannot accept control messages at this time.   How can I stop and restart the service?   The log files appear to go back to the 06/06/2021 and there are a few reports flagged as errored. Any prompts much appreciated.

Hi,I created two Custom Fields, one in the view PURCHASE_ORDER_LINE_PART and the other in PURCHASE_ORDER_LINE_NOPART. They are identical.I want to display the values in one custom field in the view RECEIPT_INFO_ALT, because in the menu ‘Register Arrivals’ both Part and No Part order lines are displayed. But I am not able to display the value from the custom fields in the menu ‘Register Arrivals’.Does someone know how to make this work? Whe are on apps10 update 7. Kind regards,Simon

Hello In our environment (https://ifspsc1-d01.demo.ifs.cloud/) the Power BI reports examples are not running. They worked fine the last days but now you receive a message, it takes to long?Other colleaguers in our DACH team have the same problem

I have two reports having barcode one is quick crystal report and other one is order report with crystal layout. In quick crystal report barcode is showing in ifs but in order report it is not showing in system. Please suggest solution. Thanks in advanceRegardsPardeep Saini     

I would like to create a report in Business Reporter that pulls together GL information plus customer order information but I can’t figure out how to create a relationship between these tables so that I can use them. How do you do this?

Hi, I tried the SQL statement: select *from business_leadAnd then receive the following error message:  Does someone know what this message means and why it occurs? Kind regards,Simon

Hi, Trying to execute an Order report in IFS 7.5 but when clicked on report preview option, it throws error as there is no XML  data Code:            ORA-20000Location:     frmInfoServiceText:            formatReport_RequestFormatting: This report has no XML dataORA-06512: at "IFSAPP.REPORT_SYS"This occurs only in case of huge data. Is there any way to rectify this?

Hello,I’m looking for help with BA Report.The user uses order report form - report opens in Excel but without any data. There are no server session details on the  IFS Business Reporter tab (“Login” button - logged on to:).What should I check first? (I suppose some important BA parameters are missing).

Is there a way I can  generate customised reports in IFS ?For Example , A quick Report is required to monitor all Cost Types. 

After we installed the new version of BR 5.0.19.0 ,one particular user gets the error “IFS BR Upgrade Utility is not installed” while loading any report..This doesn’t stop the report from loading though..IFS BR Upgrade Utility is in fact installed and we upgraded the reports using that ..Tried uninstalling and reinstalling several times,however no luck..Appreciate any info on this ...