Related Subreports - Same number of rows.

[juanpa909]

Hi, sorry if my question is a bit silly.. I'm starting with Pentaho.

I'm building a report made up of two subreports which are "related" in some kind. Here's what I want to do: There are two subreports within the main report. Each of them has its own query, and both are quite similar. I want the report to list clients whit two measures, but these measures can't be obtained from the same query. Thing is that sometimes number of rows of both queries are not equal, because some clients have no value for one of the measures. For example.

Query 1 returns:

CLIENT MEASURE1
ClientA 10
ClientB 14
ClientC 17


Query 2 returns:

CLIENT MEASURE2
ClientA 114

ClientC 17

In this case, query 2 has no records for ClientB. What I want to do is to "force" MEASURE2 to show in ClientB row, let' say with "null" or cero or any other arbitrary value. Is there a way to tell PRD that keeps in the same line rows that are for the same Client?

Thanks in advance

[Taqua]

No, as you said: The subreports are not related and are not driven by the same query.

You may want to use Kettle, our ETL tool, to create a transformation that joins your two queries into one output. Then you can use the Kettle-Data-source inside PRD to get that (now single) data-stream in one single report. And then you can lean back and say: Case solved.

[juanpa909]

Ok Taqua, I'll try to work around this issue through a kettle-data-source. Thanks for the help.