Project

General

Profile

Feature #3869

enhance JasperReports support with sub-reports and ProDataSets

Added by Greg Shah over 5 years ago. Updated about 4 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:

0%

billable:
No
vendor_id:
GCD
version_reported:
version_resolved:

Related issues

Related to Base Language - Feature #3342: implement a facility to easily run a JasperReports report definition from 4GL code, passing data queried/calculated in that 4GL code Closed

History

#1 Updated by Greg Shah over 5 years ago

  • Related to Feature #3342: implement a facility to easily run a JasperReports report definition from 4GL code, passing data queried/calculated in that 4GL code added

#2 Updated by Greg Shah over 5 years ago

For sub-reports see the discussion starting at #3342-77.

ProDataSet support seems like a natural enhancement. The idea is that instead of mapping a single query to a report definition, we can map the ProDataSet's multiple queries using the defined relations. This is dependent upon sub-reports and also on the main work for getting ProDataSets running (#3809).

The objective for these features is to be able to easily implement very complex reports without requiring extra definitions in the 4GL. The original implementation met this requirement for the single query case.

#3 Updated by Greg Shah about 4 years ago

The following are some answers by Stanislav to some questions related to Jasper and multiple queries.

Is it possible to use more than one table with a report in Jasper directly?

Yes.

Does Jasper allow more than one data source to be associated with a report?

Yes. I haven't tried subreports capability, but it should help. Also this article describes several other ways to get the job done:

https://community.jaspersoft.com/wiki/how-use-multiple-data-sources-jaspersoft-studio-or-jasperreports-server

As separate queries associated with the FWD data source?

Not implemented at this point.

Technically our QueryJasperDataSource is a Jasper data source, so it should be possible with a few changes related to wrapping. But I guess Jasper can bring problems that I'm not aware of.

In a single query associated with the FWD data source?

Like "open query q for each person, each address where address.pers-id = person.pers-id."?

Yes.

Also available in: Atom PDF