BIRT Flexible reports questions

[Georg Potthast 2]

I try to use the BIRT Flexible reports as described in the online documentation.

First I downloaded and installed the BIRT report designer for Windows. Then I made a new directory „reports“ in the designer's directory. After that I called BIRT from the main menu and selected Flexible Reports. In the „manage reports“ screen I click on the generate report button and enter „test123“ as the name of the new report and „testing“ as a description. I then click send and get a message that the test123 file has been generated.

Then, in the edit screen, I click on the „download rptdesign file“ button. A window opens and asks me if I want to save the „test.rptdesign“ file. So it did cut off the „123“ at the end. I tested this with different names, the numbers are always removed from the file name. The file is also saved on disk without these numbers. Seems like a bug to me.

So I choose a file name without numbers: „testa“ and save the testa.rptdesign file in my „reports“ directory in the BIRD designer. However, when I open this file the layout is empty. When I upload the file again and execute it, I get an empty page.

The testa design file has OFBiz as the data source. As Data Sets there is “Data Set” with „anotherDate, anotherText, etc.” How can I add the data set fields for OFBiz so I get the same report as the PDF example on the BIRT start page (exampleID exampleTypeID exampleName)? I would like to use the data that is stored in the „ofbiz\plugins\birt\data\example\ExampleDemoData.xml“ file.

[Jacques Le Roux]

Hi Georg,

Which "online documentation" did you use?

Jacques

Le 16/09/2020 à 10:31, Georg Potthast a écrit :

> I try to use the BIRT Flexible reports as described in the online documentation.
>
> First I downloaded and installed the BIRT report designer for Windows. Then I made a new directory „reports“ in the designer's directory. After that I called BIRT from the main menu and selected Flexible Reports. In the „manage reports“ screen I click on the generate report button and enter „test123“ as the name of the new report and „testing“ as a description. I then click send and get a message that the test123 file has been generated.
>
> Then, in the edit screen, I click on the „download rptdesign file“ button. A window opens and asks me if I want to save the „test.rptdesign“ file. So it did cut off the „123“ at the end. I tested this with different names, the numbers are always removed from the file name. The file is also saved on disk without these numbers. Seems like a bug to me.
>
> So I choose a file name without numbers: „testa“ and save the testa.rptdesign file in my „reports“ directory in the BIRD designer. However, when I open this file the layout is empty. When I upload the file again and execute it, I get an empty page.
>
> The testa design file has OFBiz as the data source. As Data Sets there is “Data Set” with „anotherDate, anotherText, etc.” How can I add the data set fields for OFBiz so I get the same report as the PDF example on the BIRT start page (exampleID exampleTypeID exampleName)? I would like to use the data that is stored in the „ofbiz\plugins\birt\data\example\ExampleDemoData.xml“ file.
>
>

[Georg Potthast 2]

Hi Jacques,

I used:
https://ci.apache.org/projects/ofbiz/site/trunk/pluginsdoc/birt/html5/birt.html

Georg

-----Ursprüngliche Nachricht-----
From: Jacques Le Roux
Sent: Wednesday, September 16, 2020 2:42 PM
To: [hidden email]
Subject: Re: BIRT Flexible reports questions

Hi Georg,

Which "online documentation" did you use?

Jacques

Le 16/09/2020 à 10:31, Georg Potthast a écrit :

> I try to use the BIRT Flexible reports as described in the online
> documentation.
>
> First I downloaded and installed the BIRT report designer for Windows.
> Then I made a new directory „reports“ in the designer's directory. After
> that I called BIRT from the main menu and selected Flexible Reports. In
> the „manage reports“ screen I click on the generate report button and
> enter „test123“ as the name of the new report and „testing“ as a
> description. I then click send and get a message that the test123 file has
> been generated.
>
> Then, in the edit screen, I click on the „download rptdesign file“ button.
> A window opens and asks me if I want to save the „test.rptdesign“ file. So
> it did cut off the „123“ at the end. I tested this with different names,
> the numbers are always removed from the file name. The file is also saved
> on disk without these numbers. Seems like a bug to me.
>
> So I choose a file name without numbers: „testa“ and save the
> testa.rptdesign file in my „reports“ directory in the BIRD designer.
> However, when I open this file the layout is empty. When I upload the file
> again and execute it, I get an empty page.
>
> The testa design file has OFBiz as the data source. As Data Sets there is
> “Data Set” with „anotherDate, anotherText, etc.” How can I add the data
> set fields for OFBiz so I get the same report as the PDF example on the
> BIRT start page (exampleID exampleTypeID exampleName)? I would like to use
> the data that is stored in the
> „ofbiz\plugins\birt\data\example\ExampleDemoData.xml“ file.
>
>

[Jacques Le Roux]

Hi Georg,

Sorry I planned to answer you early. My main OS (Win 7) crashed after 6 years of good and reliable service. Fortunately I have a daily and weekly
backups. After 3 days of work I'm back with almost the last state before crashing.

I still plan to answer you but I need to relax a bit ;)

Jacques

Le 16/09/2020 à 16:03, Georg Potthast a écrit :

> Hi Jacques,
>
> I used:
> https://ci.apache.org/projects/ofbiz/site/trunk/pluginsdoc/birt/html5/birt.html
>
> Georg
>
> -----Ursprüngliche Nachricht----- From: Jacques Le Roux
> Sent: Wednesday, September 16, 2020 2:42 PM
> To: [hidden email]
> Subject: Re: BIRT Flexible reports questions
>
> Hi Georg,
>
> Which "online documentation" did you use?
>
> Jacques
>
> Le 16/09/2020 à 10:31, Georg Potthast a écrit :
>> I try to use the BIRT Flexible reports as described in the online documentation.
>>
>> First I downloaded and installed the BIRT report designer for Windows. Then I made a new directory „reports“ in the designer's directory. After
>> that I called BIRT from the main menu and selected Flexible Reports. In the „manage reports“ screen I click on the generate report button and enter
>> „test123“ as the name of the new report and „testing“ as a description. I then click send and get a message that the test123 file has been generated.
>>
>> Then, in the edit screen, I click on the „download rptdesign file“ button. A window opens and asks me if I want to save the „test.rptdesign“ file.
>> So it did cut off the „123“ at the end. I tested this with different names, the numbers are always removed from the file name. The file is also
>> saved on disk without these numbers. Seems like a bug to me.
>>
>> So I choose a file name without numbers: „testa“ and save the testa.rptdesign file in my „reports“ directory in the BIRD designer. However, when I
>> open this file the layout is empty. When I upload the file again and execute it, I get an empty page.
>>
>> The testa design file has OFBiz as the data source. As Data Sets there is “Data Set” with „anotherDate, anotherText, etc.” How can I add the data
>> set fields for OFBiz so I get the same report as the PDF example on the BIRT start page (exampleID exampleTypeID exampleName)? I would like to use
>> the data that is stored in the „ofbiz\plugins\birt\data\example\ExampleDemoData.xml“ file.
>>
>>
>

[Georg Potthast 2]

Hi Jacques,

thank you for your message. I am sorry to hear you had a system crash. I
should make backups with my PC soon I guess. Still looking forward to be
able to use the BIRT flexible reports

Georg

-----Ursprüngliche Nachricht-----
From: Jacques Le Roux
Sent: Saturday, September 19, 2020 12:07 PM
To: [hidden email]
Subject: Re: BIRT Flexible reports questions

Hi Georg,

Sorry I planned to answer you early. My main OS (Win 7) crashed after 6
years of good and reliable service. Fortunately I have a daily and weekly
backups. After 3 days of work I'm back with almost the last state before
crashing.

I still plan to answer you but I need to relax a bit ;)

Jacques

Le 16/09/2020 à 16:03, Georg Potthast a écrit :

> Hi Jacques,
>
> I used:
> https://ci.apache.org/projects/ofbiz/site/trunk/pluginsdoc/birt/html5/birt.html
>
> Georg
>
> -----Ursprüngliche Nachricht----- From: Jacques Le Roux
> Sent: Wednesday, September 16, 2020 2:42 PM
> To: [hidden email]
> Subject: Re: BIRT Flexible reports questions
>
> Hi Georg,
>
> Which "online documentation" did you use?
>
> Jacques
>
> Le 16/09/2020 à 10:31, Georg Potthast a écrit :
>> I try to use the BIRT Flexible reports as described in the online
>> documentation.
>>
>> First I downloaded and installed the BIRT report designer for Windows.
>> Then I made a new directory „reports“ in the designer's directory. After
>> that I called BIRT from the main menu and selected Flexible Reports. In
>> the „manage reports“ screen I click on the generate report button and
>> enter „test123“ as the name of the new report and „testing“ as a
>> description. I then click send and get a message that the test123 file
>> has been generated.
>>
>> Then, in the edit screen, I click on the „download rptdesign file“
>> button. A window opens and asks me if I want to save the „test.rptdesign“
>> file. So it did cut off the „123“ at the end. I tested this with
>> different names, the numbers are always removed from the file name. The
>> file is also saved on disk without these numbers. Seems like a bug to me.
>>
>> So I choose a file name without numbers: „testa“ and save the
>> testa.rptdesign file in my „reports“ directory in the BIRD designer.
>> However, when I open this file the layout is empty. When I upload the
>> file again and execute it, I get an empty page.
>>
>> The testa design file has OFBiz as the data source. As Data Sets there is
>> “Data Set” with „anotherDate, anotherText, etc.” How can I add the data
>> set fields for OFBiz so I get the same report as the PDF example on the
>> BIRT start page (exampleID exampleTypeID exampleName)? I would like to
>> use the data that is stored in the
>> „ofbiz\plugins\birt\data\example\ExampleDemoData.xml“ file.
>>
>>
>

[Georg Potthast 2]

I did some more testing but I do not know what I do not understand or do
wrong.

When I generate a report I select „Choose report topic: example“, enter the
name „example“ as the report name plus a description and click „send“.

This generates the file
G:\ofbiz-2\runtime\uploads\birtRptDesign\example_0.rptdesign.

When open this file with the BIRT report designer or download this file and
open it, the Initialize, Open and Fetch scripts are completely different
from the ones in the „plugins\birt\webapp\birt\report\example.rptdesign“
file which I think is the master. I assume both files should be the same?

I get the following scripts:

Initialize:
importPackage(Packages.org.eclipse.birt.report.engine.api);
importPackage(Packages.org.apache.ofbiz.entity);
importPackage(Packages.org.apache.ofbiz.service);
importPackage(Packages.org.apache.ofbiz.base.util);
importPackage(java.util);
module = "G:/ofbiz-2/runtime/uploads/birtRptDesign/newtest_0.rptdesign";
Debug.logInfo("###### In initialize ", module);

Open:
importPackage(Packages.org.apache.ofbiz.birt);
Debug.logInfo("#### In open", module)
try {
    listRes = dispatcher.runSync("callPerformFindFromBirt",
UtilMisc.toMap("userLogin", reportContext.getParameterValue("userLogin"),
"locale", reportContext.getParameterValue("locale"), "reportContext",
reportContext));
    if (ServiceUtil.isError(listRes)) {
         Debug.logError(ServiceUtil.getErrorMessage(listRes));
    }
}
catch (e) { Debug.logError(e, module); }
records = listRes.get("records");
countOfRow = 0;
totalRow = records.size();

Fetch:
if (countOfRow == totalRow) return false;
line = records.get(countOfRow);
longDescription = line.get("longDescription"); row["longDescription"] =
longDescription;
exampleTypeId = line.get("exampleTypeId"); row["exampleTypeId"] =
exampleTypeId;
anotherDate = line.get("anotherDate"); row["anotherDate"] = anotherDate;
exampleDate = line.get("exampleDate"); row["exampleDate"] = exampleDate;
exampleId = line.get("exampleId"); row["exampleId"] = exampleId;
comments = line.get("comments"); row["comments"] = comments;
statusId = line.get("statusId"); row["statusId"] = statusId;
description = line.get("description"); row["description"] = description;
anotherText = line.get("anotherText"); row["anotherText"] = anotherText;
exampleName = line.get("exampleName"); row["exampleName"] = exampleName;
exampleSize = line.get("exampleSize"); row["exampleSize"] = exampleSize;
countOfRow ++;
return true;

However, e.g. the fetch script in the
„plugins\birt\webapp\birt\report\example.rptdesign“ file is:

if (countOfRow == totalRow - 1) return false;

example = examples.get(countOfRow);
exampleId = example.getString("exampleId");
exampleTypeId = example.getString("exampleTypeId");
exampleName = example.getString("exampleName");

row["exampleId"] = exampleId;
row["exampleTypeId"] = exampleTypeId;
row["exampleName"] = exampleName;

countOfRow ++;
return true;


When I run the report with output as html/text I get the message:
The following items have errors:

Table (id = 35):
+ DataSet "Example" is not defined in report.
+ A BIRT exception occurred. See next exception for more information.
ReferenceError: "dataSetRow" is not defined.

However, I get it to run when I copy the
„plugins\birt\webapp\birt\report\example.rptdesign“ file into the
„G:\ofbiz-2\runtime\uploads\birtRptDesign„ directory and rename it to
„example_0.rptdesign“. Then I get the same report as the example PDF
available in the „Main“ button.

[Jacques Le Roux]

Hi Georg,

Sorry, I saw your last message this morning but I lost it (issue with my machine). If needed please resend, TIA

Le 19/09/2020 à 21:16, Georg Potthast a écrit :

> Hi Jacques,
>
> thank you for your message. I am sorry to hear you had a system crash. I should make backups with my PC soon I guess. Still looking forward to be
> able to use the BIRT flexible reports
>
> Georg
>
> -----Ursprüngliche Nachricht----- From: Jacques Le Roux
> Sent: Saturday, September 19, 2020 12:07 PM
> To: [hidden email]
> Subject: Re: BIRT Flexible reports questions
>
> Hi Georg,
>
> Sorry I planned to answer you early. My main OS (Win 7) crashed after 6 years of good and reliable service. Fortunately I have a daily and weekly
> backups. After 3 days of work I'm back with almost the last state before crashing.
>
> I still plan to answer you but I need to relax a bit ;)
>
> Jacques
>
> Le 16/09/2020 à 16:03, Georg Potthast a écrit :
>
>> Hi Jacques,
>>
>> I used:
>> https://ci.apache.org/projects/ofbiz/site/trunk/pluginsdoc/birt/html5/birt.html
>>
>> Georg
>>
>> -----Ursprüngliche Nachricht----- From: Jacques Le Roux
>> Sent: Wednesday, September 16, 2020 2:42 PM
>> To: [hidden email]
>> Subject: Re: BIRT Flexible reports questions
>>
>> Hi Georg,
>>
>> Which "online documentation" did you use?
>>
>> Jacques
>>
>> Le 16/09/2020 à 10:31, Georg Potthast a écrit :
>>> I try to use the BIRT Flexible reports as described in the online documentation.
>>>
>>> First I downloaded and installed the BIRT report designer for Windows. Then I made a new directory „reports“ in the designer's directory. After
>>> that I called BIRT from the main menu and selected Flexible Reports. In the „manage reports“ screen I click on the generate report button and
>>> enter „test123“ as the name of the new report and „testing“ as a description. I then click send and get a message that the test123 file has been
>>> generated.
>>>
>>> Then, in the edit screen, I click on the „download rptdesign file“ button. A window opens and asks me if I want to save the „test.rptdesign“ file.
>>> So it did cut off the „123“ at the end. I tested this with different names, the numbers are always removed from the file name. The file is also
>>> saved on disk without these numbers. Seems like a bug to me.
>>>
>>> So I choose a file name without numbers: „testa“ and save the testa.rptdesign file in my „reports“ directory in the BIRD designer. However, when I
>>> open this file the layout is empty. When I upload the file again and execute it, I get an empty page.
>>>
>>> The testa design file has OFBiz as the data source. As Data Sets there is “Data Set” with „anotherDate, anotherText, etc.” How can I add the data
>>> set fields for OFBiz so I get the same report as the PDF example on the BIRT start page (exampleID exampleTypeID exampleName)? I would like to use
>>> the data that is stored in the „ofbiz\plugins\birt\data\example\ExampleDemoData.xml“ file.
>>>
>>>
>>
>

[Georg Potthast 2]

Here is my message again, slightly extended. Yes, I need help with this.

I did some more testing but I do not know what I did not understand and do
wrong.

When I generate a report I select „Choose report topic: example“, enter the
name „example“ as the report name plus the description and click „send“. So
I assume I selected the master "example.rptdesign" to generate my report.

This generates the file
G:\ofbiz-2\runtime\uploads\birtRptDesign\example_0.rptdesign.

When open this file with the BIRT report designer or download this file and
open it, the Initialize, Open and Fetch scripts are completely different
from the ones in the „plugins\birt\webapp\birt\report\example.rptdesign“
file which I think is the master. I assume these files should be the same?

I get the following scripts:

Initialize:
importPackage(Packages.org.eclipse.birt.report.engine.api);
importPackage(Packages.org.apache.ofbiz.entity);
importPackage(Packages.org.apache.ofbiz.service);
importPackage(Packages.org.apache.ofbiz.base.util);
importPackage(java.util);
module = "G:/ofbiz-2/runtime/uploads/birtRptDesign/example_0.rptdesign";
Debug.logInfo("###### In initialize ", module);

Open:
importPackage(Packages.org.apache.ofbiz.birt);
Debug.logInfo("#### In open", module)
try {
    listRes = dispatcher.runSync("callPerformFindFromBirt",
UtilMisc.toMap("userLogin", reportContext.getParameterValue("userLogin"),
"locale", reportContext.getParameterValue("locale"), "reportContext",
reportContext));
    if (ServiceUtil.isError(listRes)) {
         Debug.logError(ServiceUtil.getErrorMessage(listRes));
    }
}
catch (e) { Debug.logError(e, module); }
records = listRes.get("records");
countOfRow = 0;
totalRow = records.size();

Fetch:
if (countOfRow == totalRow) return false;
line = records.get(countOfRow);
longDescription = line.get("longDescription"); row["longDescription"] =
longDescription;
exampleTypeId = line.get("exampleTypeId"); row["exampleTypeId"] =
exampleTypeId;
anotherDate = line.get("anotherDate"); row["anotherDate"] = anotherDate;
exampleDate = line.get("exampleDate"); row["exampleDate"] = exampleDate;
exampleId = line.get("exampleId"); row["exampleId"] = exampleId;
comments = line.get("comments"); row["comments"] = comments;
statusId = line.get("statusId"); row["statusId"] = statusId;
description = line.get("description"); row["description"] = description;
anotherText = line.get("anotherText"); row["anotherText"] = anotherText;
exampleName = line.get("exampleName"); row["exampleName"] = exampleName;
exampleSize = line.get("exampleSize"); row["exampleSize"] = exampleSize;
countOfRow ++;


However, the scripts in the
plugins\birt\webapp\birt\report\example.rptdesign file, which I think is the
master, are:

Initialize:
importPackage(Packages.org.apache.ofbiz.base.util)
module = "example.rptdesign";

Open:
examples = null;
try {
    examples = delegator.findList("Example", null, null, null, null, false);
} catch (e) {
    Debug.logError(e, module);
}
totalRow = 0;
countOfRow = 0;
if (examples) {
    totalRow = examples.size();
}return true;

Fetch:
if (countOfRow == totalRow - 1) return false;

example = examples.get(countOfRow);
exampleId = example.getString("exampleId");
exampleTypeId = example.getString("exampleTypeId");
exampleName = example.getString("exampleName");

row["exampleId"] = exampleId;
row["exampleTypeId"] = exampleTypeId;
row["exampleName"] = exampleName;

countOfRow ++;
return true;


When I then run the report with output as html/text I get the message:
The following items have errors:

Table (id = 35):
+ DataSet "Example" is not defined in report.
+ A BIRT exception occurred. See next exception for more information.
ReferenceError: "dataSetRow" is not defined.


However, I get it to run when I copy the
„plugins\birt\webapp\birt\report\example.rptdesign“ file into the
„G:\ofbiz-2\runtime\uploads\birtRptDesign„ directory and rename it to
„example_0.rptdesign“. Then I get the same report as the example PDF
available in the „Main“ button. I can also download that and upload it
again. It will work.

So it seems to me that the example_0.rptdesign file is not generated
properly. At least you cannot generate a report from it without
modifications which are not mentioned in the BIRT flexible reports
documentation.



-----Ursprüngliche Nachricht-----
From: Jacques Le Roux
Sent: Thursday, September 24, 2020 6:50 PM
To: [hidden email]
Subject: Re: BIRT Flexible reports questions

Hi Georg,

Sorry, I saw your last message this morning but I lost it (issue with my
machine). If needed please resend, TIA

[Georg Potthast 2]

I kept on testing BIRT flexible reports. When I generate a report like this:
select „Choose report topic: example“,
enter the name e.g. „myexample“ plus a description,
click „send“ and download the generated report.
The downloaded myexample.rptdesign has no layout and the Data Set includes
all the fields in the entity definition for entity-name="Example" in
\plugins\example\entitydef\entitymodel.xml.
I can drag a new table into the main window and specify „Data Set“ as the
Data Set. Then I can select exampleId, exampleTypeId and exampleName from
the list of fields. If I save this report design then and upload it, it will
show the report result as provided in the example at the main button.

This works but it is not mentioned as the procedure to use in the online
documentation. I expected that the downloaded file includes a layout which
the master would provide.

[Jacques Le Roux]

Hi Georg,

I found these errors in OFBiz log (or console):

2020-10-03 19:07:48,910 |jsse-nio-8443-exec-4 |ServiceDispatcher             |T| Sync service [birt/prepareFlexibleReportSearchFormToEdit] finished in
[1] milliseconds
2020-10-03 19:07:48,924 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
  namespace of 'http://ofbiz.apache.org/Widget-Form'.
2020-10-03 19:07:48,924 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 1. Error
message: cvc-elt.1.a: Cannot find the declaration of element 'forms'.
2020-10-03 19:07:48,926 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
  namespace of 'http://ofbiz.apache.org/Widget-Form'.
2020-10-03 19:07:48,929 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
  namespace of 'http://ofbiz.apache.org/Widget-Form'.
2020-10-03 19:07:48,931 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
  namespace of 'http://ofbiz.apache.org/Widget-Form'.
2020-10-03 19:07:48,933 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
  namespace of 'http://ofbiz.apache.org/Widget-Form'.
2020-10-03 19:07:48,935 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
  namespace of 'http://ofbiz.apache.org/Widget-Form'.

I had some old files in my Birt\workspace\Report Builder dir. I picked one and it worked as before. So I guess the problem is really these errors above.

I'll have a deeper look ASAP

Thanks for your interest in the BIRT Flexible reports  :)

Jacques

Le 26/09/2020 à 13:47, Georg Potthast a écrit :

> I kept on testing BIRT flexible reports. When I generate a report like this:
> select „Choose report topic: example“,
> enter the name e.g. „myexample“ plus a description,
> click „send“ and download the generated report.
> The downloaded myexample.rptdesign has no layout and the Data Set includes all the fields in the entity definition for entity-name="Example" in
> \plugins\example\entitydef\entitymodel.xml.
> I can drag a new table into the main window and specify „Data Set“ as the Data Set. Then I can select exampleId, exampleTypeId and exampleName from
> the list of fields. If I save this report design then and upload it, it will show the report result as provided in the example at the main button.
>
> This works but it is not mentioned as the procedure to use in the online documentation. I expected that the downloaded file includes a layout which
> the master would provide.
>

[Jacques Le Roux]

Hi Georg,

Good news, with https://issues.apache.org/jira/browse/OFBIZ-12039 I fixed the issue.

I was then able to follow the doc to "Insert the Layout" from the "Data Set" in "Data Explorer" from the "Report Builder" and it worked as before

You just need to update your working copy with this fix and it should be alright

Enjoy!

Jacques

Le 03/10/2020 à 19:17, Jacques Le Roux a écrit :

> Hi Georg,
>
> I found these errors in OFBiz log (or console):
>
> 2020-10-03 19:07:48,910 |jsse-nio-8443-exec-4 |ServiceDispatcher             |T| Sync service [birt/prepareFlexibleReportSearchFormToEdit] finished
> in [1] milliseconds
> 2020-10-03 19:07:48,924 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,924 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 1. Error
> message: cvc-elt.1.a: Cannot find the declaration of element 'forms'.
> 2020-10-03 19:07:48,926 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,929 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,931 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,933 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,935 |jsse-nio-8443-exec-4 |UtilXml                       |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
>
> I had some old files in my Birt\workspace\Report Builder dir. I picked one and it worked as before. So I guess the problem is really these errors
> above.
>
> I'll have a deeper look ASAP
>
> Thanks for your interest in the BIRT Flexible reports  :)
>
> Jacques
>
> Le 26/09/2020 à 13:47, Georg Potthast a écrit :
>> I kept on testing BIRT flexible reports. When I generate a report like this:
>> select „Choose report topic: example“,
>> enter the name e.g. „myexample“ plus a description,
>> click „send“ and download the generated report.
>> The downloaded myexample.rptdesign has no layout and the Data Set includes all the fields in the entity definition for entity-name="Example" in
>> \plugins\example\entitydef\entitymodel.xml.
>> I can drag a new table into the main window and specify „Data Set“ as the Data Set. Then I can select exampleId, exampleTypeId and exampleName from
>> the list of fields. If I save this report design then and upload it, it will show the report result as provided in the example at the main button.
>>
>> This works but it is not mentioned as the procedure to use in the online documentation. I expected that the downloaded file includes a layout which
>> the master would provide.
>>

[Georg Potthast 2]

Hi Jacques,

thank you for the fix! I will test it end of this week. However, does this
cause the downloaded rptdesign files to contain a layout now or shall they
have no layout and just contain a data set?

Georg

-----Ursprüngliche Nachricht-----
From: Jacques Le Roux
Sent: Sunday, October 4, 2020 12:07 PM
To: [hidden email]
Subject: Re: BIRT Flexible reports questions

Hi Georg,

Good news, with https://issues.apache.org/jira/browse/OFBIZ-12039 I fixed
the issue.

I was then able to follow the doc to "Insert the Layout" from the "Data Set"
in "Data Explorer" from the "Report Builder" and it worked as before

You just need to update your working copy with this fix and it should be
alright

Enjoy!

Jacques

Le 03/10/2020 à 19:17, Jacques Le Roux a écrit :

> Hi Georg,
>
> I found these errors in OFBiz log (or console):
>
> 2020-10-03 19:07:48,910 |jsse-nio-8443-exec-4 |ServiceDispatcher
> |T| Sync service [birt/prepareFlexibleReportSearchFormToEdit] finished in
> [1] milliseconds
> 2020-10-03 19:07:48,924 |jsse-nio-8443-exec-4 |UtilXml
> |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema
> document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,924 |jsse-nio-8443-exec-4 |UtilXml
> |E| XmlFileLoader: File Internal Content process error. Line: 1. Error
> message: cvc-elt.1.a: Cannot find the declaration of element 'forms'.
> 2020-10-03 19:07:48,926 |jsse-nio-8443-exec-4 |UtilXml
> |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema
> document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,929 |jsse-nio-8443-exec-4 |UtilXml
> |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema
> document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,931 |jsse-nio-8443-exec-4 |UtilXml
> |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema
> document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,933 |jsse-nio-8443-exec-4 |UtilXml
> |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema
> document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
> 2020-10-03 19:07:48,935 |jsse-nio-8443-exec-4 |UtilXml
> |E| XmlFileLoader: File Internal Content process error. Line: 20. Error
> message: TargetNamespace.2: Expecting no namespace, but the schema
> document has a target
>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
>
> I had some old files in my Birt\workspace\Report Builder dir. I picked one
> and it worked as before. So I guess the problem is really these errors
> above.
>
> I'll have a deeper look ASAP
>
> Thanks for your interest in the BIRT Flexible reports  :)
>
> Jacques
>
> Le 26/09/2020 à 13:47, Georg Potthast a écrit :
>> I kept on testing BIRT flexible reports. When I generate a report like
>> this:
>> select „Choose report topic: example“,
>> enter the name e.g. „myexample“ plus a description,
>> click „send“ and download the generated report.
>> The downloaded myexample.rptdesign has no layout and the Data Set
>> includes all the fields in the entity definition for
>> entity-name="Example" in \plugins\example\entitydef\entitymodel.xml.
>> I can drag a new table into the main window and specify „Data Set“ as the
>> Data Set. Then I can select exampleId, exampleTypeId and exampleName from
>> the list of fields. If I save this report design then and upload it, it
>> will show the report result as provided in the example at the main
>> button.
>>
>> This works but it is not mentioned as the procedure to use in the online
>> documentation. I expected that the downloaded file includes a layout
>> which the master would provide.
>>

[Jacques Le Roux]

Hi Georg,

The downloaded rptdesign files does not contain a layout and just contain a data set.

 From that as I somehow said below:

    <<in the "Report Builder" "Insert the Layout" from the "Data Set" in "Data Explorer" >>

You may also follow https://ci.apache.org/projects/ofbiz/site/trunk/pluginsdoc/birt/html5/birt.html#_different_areas_of_the_screen_and_their_role

Please let me know if it's clear enough. Else I'll improve the documentation, feel free to suggest improvements.

Thanks

Jacques

Le 05/10/2020 à 08:05, Georg Potthast a écrit :

> Hi Jacques,
>
> thank you for the fix! I will test it end of this week. However, does this cause the downloaded rptdesign files to contain a layout now or shall
> they have no layout and just contain a data set?
>
> Georg
>
> -----Ursprüngliche Nachricht----- From: Jacques Le Roux
> Sent: Sunday, October 4, 2020 12:07 PM
> To: [hidden email]
> Subject: Re: BIRT Flexible reports questions
>
> Hi Georg,
>
> Good news, with https://issues.apache.org/jira/browse/OFBIZ-12039 I fixed the issue.
>
> I was then able to follow the doc to "Insert the Layout" from the "Data Set" in "Data Explorer" from the "Report Builder" and it worked as before
>
> You just need to update your working copy with this fix and it should be alright
>
> Enjoy!
>
> Jacques
>
> Le 03/10/2020 à 19:17, Jacques Le Roux a écrit :
>> Hi Georg,
>>
>> I found these errors in OFBiz log (or console):
>>
>> 2020-10-03 19:07:48,910 |jsse-nio-8443-exec-4 |ServiceDispatcher |T| Sync service [birt/prepareFlexibleReportSearchFormToEdit] finished in [1]
>> milliseconds
>> 2020-10-03 19:07:48,924 |jsse-nio-8443-exec-4 |UtilXml |E| XmlFileLoader: File Internal Content process error. Line: 20. Error message:
>> TargetNamespace.2: Expecting no namespace, but the schema document has a target
>>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
>> 2020-10-03 19:07:48,924 |jsse-nio-8443-exec-4 |UtilXml |E| XmlFileLoader: File Internal Content process error. Line: 1. Error message: cvc-elt.1.a:
>> Cannot find the declaration of element 'forms'.
>> 2020-10-03 19:07:48,926 |jsse-nio-8443-exec-4 |UtilXml |E| XmlFileLoader: File Internal Content process error. Line: 20. Error message:
>> TargetNamespace.2: Expecting no namespace, but the schema document has a target
>>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
>> 2020-10-03 19:07:48,929 |jsse-nio-8443-exec-4 |UtilXml |E| XmlFileLoader: File Internal Content process error. Line: 20. Error message:
>> TargetNamespace.2: Expecting no namespace, but the schema document has a target
>>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
>> 2020-10-03 19:07:48,931 |jsse-nio-8443-exec-4 |UtilXml |E| XmlFileLoader: File Internal Content process error. Line: 20. Error message:
>> TargetNamespace.2: Expecting no namespace, but the schema document has a target
>>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
>> 2020-10-03 19:07:48,933 |jsse-nio-8443-exec-4 |UtilXml |E| XmlFileLoader: File Internal Content process error. Line: 20. Error message:
>> TargetNamespace.2: Expecting no namespace, but the schema document has a target
>>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
>> 2020-10-03 19:07:48,935 |jsse-nio-8443-exec-4 |UtilXml |E| XmlFileLoader: File Internal Content process error. Line: 20. Error message:
>> TargetNamespace.2: Expecting no namespace, but the schema document has a target
>>  namespace of 'http://ofbiz.apache.org/Widget-Form'.
>>
>> I had some old files in my Birt\workspace\Report Builder dir. I picked one and it worked as before. So I guess the problem is really these errors
>> above.
>>
>> I'll have a deeper look ASAP
>>
>> Thanks for your interest in the BIRT Flexible reports  :)
>>
>> Jacques
>>
>> Le 26/09/2020 à 13:47, Georg Potthast a écrit :
>>> I kept on testing BIRT flexible reports. When I generate a report like this:
>>> select „Choose report topic: example“,
>>> enter the name e.g. „myexample“ plus a description,
>>> click „send“ and download the generated report.
>>> The downloaded myexample.rptdesign has no layout and the Data Set includes all the fields in the entity definition for entity-name="Example" in
>>> \plugins\example\entitydef\entitymodel.xml.
>>> I can drag a new table into the main window and specify „Data Set“ as the Data Set. Then I can select exampleId, exampleTypeId and exampleName
>>> from the list of fields. If I save this report design then and upload it, it will show the report result as provided in the example at the main
>>> button.
>>>
>>> This works but it is not mentioned as the procedure to use in the online documentation. I expected that the downloaded file includes a layout
>>> which the master would provide.
>>>
>

[Jacques Le Roux]

Le 05/10/2020 à 09:25, Jacques Le Roux a écrit :
> <<in the "Report Builder" "Insert the Layout" from the "Data Set" in "Data Explorer" >>

This is after having created your report; saved it in the Report Builder dir and opened it in the Report Builder.

Then to create the layout in your report: in "Data Explorer" open "Data Sets" (click on it); right click on the only "Data Set" and use "Insert the
Layout"; save your change.

This is the "Simple design without break" option as explained in the doc. There are other more advanced options explained in the doc.

HTH (I know it's not as easy as it look once you have done it 1st time)

Jacques

[Georg Potthast 2]

Thank you Jacques,

I will be travelling for a couple of days, so I cannot try that now. But I will end of this week.
Since I am a contributor, I can change the wiki documentation so that I would understand it and you could modify what I wrote if needed.

Georg

> Jacques Le Roux <[hidden email]> hat am 05.10.2020 09:44 geschrieben:
>
>  
> Le 05/10/2020 à 09:25, Jacques Le Roux a écrit :
> > <<in the "Report Builder" "Insert the Layout" from the "Data Set" in "Data Explorer" >>
>
> This is after having created your report; saved it in the Report Builder dir and opened it in the Report Builder.
>
> Then to create the layout in your report: in "Data Explorer" open "Data Sets" (click on it); right click on the only "Data Set" and use "Insert the
> Layout"; save your change.
>
> This is the "Simple design without break" option as explained in the doc. There are other more advanced options explained in the doc.
>
> HTH (I know it's not as easy as it look once you have done it 1st time)
>
> Jacques

[Jacques Le Roux]

Great!

Le 05/10/2020 à 11:19, Georg Potthast 2 a écrit :

> Thank you Jacques,
>
> I will be travelling for a couple of days, so I cannot try that now. But I will end of this week.
> Since I am a contributor, I can change the wiki documentation so that I would understand it and you could modify what I wrote if needed.
>
> Georg
>
>> Jacques Le Roux <[hidden email]> hat am 05.10.2020 09:44 geschrieben:
>>
>>  
>> Le 05/10/2020 à 09:25, Jacques Le Roux a écrit :
>>> <<in the "Report Builder" "Insert the Layout" from the "Data Set" in "Data Explorer" >>
>> This is after having created your report; saved it in the Report Builder dir and opened it in the Report Builder.
>>
>> Then to create the layout in your report: in "Data Explorer" open "Data Sets" (click on it); right click on the only "Data Set" and use "Insert the
>> Layout"; save your change.
>>
>> This is the "Simple design without break" option as explained in the doc. There are other more advanced options explained in the doc.
>>
>> HTH (I know it's not as easy as it look once you have done it 1st time)
>>
>> Jacques