[OFBIZ-5070] Problems With BIRT Reports

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Trunk
• Fix Version/s: 12.04.06
• Component/s: birt
• Assignee: Jacques Le Roux
• Reporter: Jacopo Cappellato
• Created: 10/Nov/12 18:07
• Updated: 01/Dec/14 09:20
• Resolved: 01/Dec/14 09:20

Description

Following are results of testing BIRT across four revisions in an effort to identity where BIRT reports work and where they do not.

Four critical revisions were identified:
1. r1003469 introduced BIRT reports in accounting which no longer work.
2. r1293999 upgraded the BIRT version after which some reports no longer worked
3. r1361130 moved BIRT from framework to specialpurpose breaking other reports
4. r1407740 is the current release for compairson

In the current release the BIRT ofbiz-component.xml was altered to mount BIRT reports and the BIRT Examples (which are no longer in the Example ment) were invoked manually (https://localhost:8443/birt/control/main).

Test results follow:

Revision BIRT Report Name WIDGET Test Result Comment
r1003469 11/01/2010 Hans Bakker added accounting reports
AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign ReportFinancialSummaryScreens.xml Pass
PaymentAcctgTransEntry.rptdesign AccountingMenus.xml Pass
BalanceSheet.rptdesign ReportFinancialSummaryScreens.xml Pass
HTML example.rptdesign ExampleMenus.xml Pass
PDF example.rptdesign ExampleMenus.xml Pass
HTML chart.rptdesign ExampleMenus.xml Pass
PDF chart.rptdesign ExampleMenus.xml Pass

r1293999 2/26/2012 Hans Bakker upgrade BIRT to 3.7.2
AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign ReportFinancialSummaryScreens.xml Fail Page Blank
PaymentAcctgTransEntry.rptdesign AccountingMenus.xml Pass
BalanceSheet.rptdesign ReportFinancialSummaryScreens.xml Fail Page Blank
HTML example.rptdesign ExampleMenus.xml Pass
PDF example.rptdesign ExampleMenus.xml Pass
HTML chart.rptdesign ExampleMenus.xml Pass
PDF chart.rptdesign ExampleMenus.xml Pass

r1361130 7/13/2012 jacopoc Moved the "birt" component from framework to specialpurpose
AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign ReportFinancialSummaryScreens.xml Fail Page Blank
PaymentAcctgTransEntry.rptdesign AccountingMenus.xml Fail Form opens without data
BalanceSheet.rptdesign ReportFinancialSummaryScreens.xml Fail Page Blank
HTML example.rptdesign ExampleMenus.xml Fail Table (id = 10):
+ A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["exampleId"] (Element ID:10)
PDF example.rptdesign ExampleMenus.xml Fail Form opens without data
HTML chart.rptdesign ExampleMenus.xml
Table (id = 32):
+ A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["exampleTypeId"] (Element ID:32)

Chart (id = 49):
+ A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["exampleTypeId"] (Element ID:49)

Chart (id = 50):
+ A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["exampleTypeId"] (Element ID:50)
PDF chart.rptdesign ExampleMenus.xml Fail Form opens without data

r1407740 Trunk As Of 11/10/2012
AcctgTransEntriesSearchResultsInvoiceAndPayment.rptdesign ReportFinancialSummaryScreens.xml Fail Page Blank
PaymentAcctgTransEntry.rptdesign AccountingMenus.xml Fail Form opens without data
BalanceSheet.rptdesign ReportFinancialSummaryScreens.xml Fail Page Blank
HTML example.rptdesign ExampleMenus.xml Fail Table (id = 10):
+ A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["exampleId"] (Element ID:10)
PDF example.rptdesign ExampleMenus.xml Fail Form opens without data
HTML chart.rptdesign ExampleMenus.xml
Table (id = 32):
+ A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["exampleTypeId"] (Element ID:32)

Chart (id = 49):
+ A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["exampleTypeId"] (Element ID:49)

Chart (id = 50):
+ A BIRT exception occurred. See next exception for more information.
Invalid javascript expression: dataSetRow["exampleTypeId"] (Element ID:50)
PDF chart.rptdesign ExampleMenus.xml Fail Form opens without data

Issue Links

• is related to: OFBIZ-4849 YUI Compressor conflict with BIRT
• relates to: OFBIZ-4849 YUI Compressor conflict with BIRT
• relates to: OFBIZ-5876 404 error with birt previews.