Home / Questions

Questions[pentaho]

Martin Hope
Lorenzo Martín
Asked: 2020-11-30 11:49:37 +0800 CST
  • 1

I am using pentaho report and I need to use several queries exactly the same but with different values. (The fields are the same, their values ​​are not) I have tried to use a subReport to which I assign the second query, but the result is that for each row of the master report it makes me all the rows of the subReport.

I put the subReport in the details of the main report.

I also put the fields of the subReport in the detail of the subReport.

What I need is a report that goes something like this

Consulta1            Consulta2

2017                  2020
2034                  3323

I have tried to make a formula with this value =MULTIVALUEQUERY("miquery") but it only takes the first value of the query and repeats it to me as many times as the main query

pentaho
Martin Hope
Lorenzo Martín
Asked: 2020-11-16 02:08:14 +0800 CST
  • 2

Hello, I am using pentaho report and I would like to make a graph with the results of a summation that is already done in the report. I would like to know how I can take those values. I imagine that we will have to make a numeric field to store the data.

Nombre    Nivel     Valor 1     Valor 2
----------------------------------------
NOmbre1   2          545          214
NOmbre2   3          23423         23423
NOmbre3   2          234            3434
NOmbre4   6          234            234

etc........

The question is: How could I take value1 and value 2 depending on the level? Something like... =IF([Nivel]=2) To my Number1 field I assign Value1 and to my Number2 field I assign Value2

Take two values ​​from the same row depending on the Level value

pentaho