next »

[Carl P.]

Hello,

We are testing our application with Genero 5.00.02 on Windows with SQL Server. I've been looking at the Genero Report Writer documentation and I've found the ability to use Sub Reports:

https://4js.com/online_documentation/fjs-grw-manual-html/#gst-topics/c_grw_sub_reports_bdl_application.html

This will solve a big problem for us because we have one report that is 1,956 KB and takes about an hour and a half to open in Genero Studio. The module that it reports on contains about 30 screens of information.

To test Sub Reports I've decide to start small with a report that only has 3 screens of data. I've changed the 4GL based on the documentation and the demo reports so that I have a main scheme_report() which calls: scheme_details(), scheme_bank_details() and scheme_rti_details().

I've also split the 4RP file so that the main py_schr1 references py_schr1_scheme_details, py_schr1_scheme_bank_details and py_schr1_scheme_rti_details.

Running it for the first time produced nothing. I set the GREDEBUG to 9 and ran it again. Now I get an error message in the VM log file:

ERROR com.fourjs.report.stylesheet.rtl.ScopeExtenderStyleSheet - failed to consume token end element OnEveryRow

I've tried to narrow the problem down by just having the Sub Reports produce a line of text and I've tried changing the main report to just produce one Sub Report. But no luck.

I'm posting this on the off chance that someone could see a glaring error.

Attached is a ZIP file containing the log, 4GL, RDD and 4RP files.

Thanks,

Carl

[Alex G.]

Hi Carl,

From a first glance it looks like your report is fine and should work so that I need some time to find out why it isn't working. I will have a deeper look at this first thing on Monday morning (tomorrow is a bank holiday here).
In the mean time can you please set the environment GREDATAFILE to some file (e.g. /tmp/gredatafile.xml) and run the report once more and upload the resulting file here.

Could you please also upload the .4rp and .rdd of the report that takes 30 minutes to load.

Thanks a lot in advance,

Alex 

[Carl P.]

Hi Alex,

This is a link to a Dropbox folder containing all the files:

https://www.dropbox.com/scl/fo/a4q1rcu5g4jyas5vahfm6/AHDYsYMQm6CzwnugsAiROic?rlkey=vzmxuht7cenu95cc3jqzw6rdm&dl=0

The folder now contains a gredatafile.xml data file and a pem_memr.rdd/pem_memr3.4rp file.

Let me know if you need anything else.

Thanks,

Carl

[Alex G.]

Hi Carl,

Just quickly this. The problem you are experiencing is FGL-4401.
You can fix it by adding a PRINT statement (e.g. "PRINT 42") before any "START REPORT" statement in the report.

Regards,
Alex
 

[Alex G.]

Hi Carl,

Issue FGL-4401 will be addressed but I assume that the workaround that I proposed, is working for you.
Regarding the slowness, I have registered issue GST-19703.

Best regards,
Alex

[Carl P.]

Hi Alex,

Yes, that workaround has solved the problem and I am now getting a report.

Thanks,

Carl