Insights (Business Reporter and Analysis Models, EOI)

607 Topics

RutJWhalenSuperhero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter and multiple Information Sources

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

5023

3 years ago

GTGesDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

CR_WEB_INIT location

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!

3921

3 years ago

ZTC ZTC JGOTAHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Is Crystal Report 2016 supported by IFS 9? Where Could I see the list of Crystal Reports versions supported by IFS?

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

2201

3 years ago

ZTC ZTC JGOTAHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Lobby -- INFO SOURCE -- data souce -- We have IFS-9

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

962

3 years ago

RutJWhalenSuperhero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

BR Execution Server Error - Template has design errors. View trace file for more details

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.

1452

3 years ago

RutJWhalenSuperhero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

When a user runs a Business Reporter report via Order Reports not data is being displayed

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?

3965

3 years ago

SASIUSDo Gooder (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

Apps10 - SSRS Extension certification for SQL Server 2019

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.

1282

3 years ago

RutJWhalenSuperhero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Reporter Execution Server

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.

2544

3 years ago

BZNSIMONSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Create custom field in register arrivals from Part/No Part order lines

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

3208

3 years ago

FRSMDEDo Gooder (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

Power BI not running

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

3167

3 years ago

Pardeep SainiDo Gooder

asked in Insights (Business Reporter and Analysis Models, EOI)

barcode issue in ifs

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

4515

3 years ago

kyerdonDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter table relationships

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?

1751

3 years ago

BZNSIMONSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Lead SQL error

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

2092

3 years ago

Rohini SDo Gooder

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS 7.5 Order Report Error

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?

4358

3 years ago

damiangralekDo Gooder (Employee)

asked in Insights (Business Reporter and Analysis Models, EOI)

BA Report - order report - blank session details

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).

2462

3 years ago

Urvakshh.AvariDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Is there a way I can generate customised reports in IFS ?

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

1891

3 years ago

SMANUELSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS BR Upgrade Utility is not installed

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 ...

1914

3 years ago

hhy38Superhero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to visualize values with comma separation on Line Chart Element?

We are using App 9.4. We could not visualize the line chart with comma separation. We tried many types of data sources. It did not affect anything. In the pie chart, everything works fine. We tried to_number, round while getting data but still the same. How can we visualize with comma separation?

2243

3 years ago

MWitczakHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

SSRS Error

Hi all. I’m new to using SSRS for Operational Reports. In trying to develop a new report, while trying to preview the report in Visual Studio, I receive the error “Cannot set the command text for dataset ‘dsQuoteFromContract’” Has anyone else received this error? What did you do to correct it? Thank you in advance.

2191

3 years ago

Nalaka SamarasingheHero (Employee)

posted in Insights (Business Reporter and Analysis Models, EOI)

A simple Query Builder Example | Lobby

Basics:Navigate to ‘Lobby Data Source Designer’ and click + then select ‘Query Builder’. Add a name for the data source. Finding a view:Under ‘Search Views’, search Instant invoice. All the columns and references related to instant invoice will list down. Adding a column and a function:RMB on ‘Invoice No’ and select ‘Add to Columns’. Then the column will appear under the columns section. Perform the same steps for the function ‘Get_Address’. Then search the view ‘Ledger Item’ and add the column ‘Cleared Amount’ as well. Adding a where condition:RMB on ‘Invoice Id’ and select ‘Add to Criteria’. Select the operator as = and insert a selected invoice id. Adding a table join (Inner):Under the joins section, select the Left View as ‘Instant Invoice’ and Right view as ‘Ledger Item’. After that select Invoice Id and company as keys from both views. Final Setup will be as below: Query Result will be as per the attachment. And all the basic functions available for SQL Query Data source can be

3130

3 years ago

ZTC ZTC JGOTAHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Security - Quick Reports-IFS9

I can see different user in my company when they access the Reporting/Ad-Hoc Reporting they can see Explore Quick Reports. However, I can see others do not see the Explore Quick Reports options.When I try to see the data Source I found tbwQuicReportsListWhen I go to the Presentation Object Grants I can see the Permission Sets granting ‘Quick Reports’Permission Set FND_ENDUSER However, all the user in my company have FND_ENDUSER, Why other can see Explore Quick Reports and why other cannot see Explore Quick Reports?How can I make Explore Quick Reports visible to other?

3773

3 years ago

sholmesHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Apps9 Report Rules

Help! I’m new to report rules and I want the company and the customer to decide what print layout to use. I’ve created simple one expression rules that work but I’m struggling to get two expressions to work. Below is what I’ve written and the error message I’m getting. If anyone can guide me that would be very appreciated.

1453

3 years ago

paguinSidekick (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS BR Execution Server - Error

Hello,I am getting following error on starting the IFS BR Server. IFS BR Execution Server (IFS BRES) cannot run in parallel with IFS Business Reporter (IFS BR) on the same host. Please make sure to uninstall IFS BR before starting IFS BRES. IFS Business Reporter is not installed on the server. I have removed related any registry entry for the sameis there any advise RegardsPankaj

2023

3 years ago

CheSusumYDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Excel add-ins

How can I install IFS BR add-ins on App10 upd8?

3225

3 years ago

disnamDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Analytics - Object reference not set to an instance of an object

Hi ,I have BA client version 4.0.22.0 and Excel 2016 in one of the customer environment.And getting the following error when trying to open a published BA report from BA client.Full Details:System.NullReferenceException: Object reference not set to an instance of an object. at Ifs.Application.ExcelReporter.ReportDesigner.ReportParameter.GetXlrTemplateParameter() at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.SetTemplateParameters(XlrTemplate template) at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.DefineDsodDataSets(Int32& setCount, ArrayList& physicalDatasets, Boolean cacheEnabled, Int32& lastDataSetId) at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.Validate() at Ifs.Application.ExcelReporter.ReportDesigner.ReportController.LoadReport() And I noticed with a older BA client(4.0.2) , the error does not appear Is this related to an IFS bug or would like to know how to get this resolved?I am in trouble now, becau

5282

3 years ago

Page 20 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded