Stack Overflow
Stack Overflow

Questions tagged [pentaho-report-designer]

a desktop reporting tool that provides a visual design environment to create pixel-perfect reports . Please make sure your question is about *programming* not just how to use the software.

197 questions
6
votes
2 answers

Oracle SQL - How to strip leading bytes from BLOB (and return as RAW)?

I'm writing a query for a reporting tool (Pentaho Report Designer) where I need to retrieve some jpgs that are stored in the Oracle 11 database. The trick is that the jogs (stored as BLOBs) include a 12 byte header (added by another application)…
whitegoose
  • 71
  • 3
5
votes
1 answer

Pentaho: how to create complex reports

I have to build a complex report (e.g. header, text and multiple lists and charts, arranged here and there on multiple pages). Something like a complex invoice. I've found no examples on the net for such reports in Pentaho. I tried with subreports,…
Don
  • 16,928
  • 12
  • 63
  • 101
4
votes
2 answers

Pentaho Report Designer PDF export is not showing the Japanese characters

I have created a report using Pentaho Report Designer 3.9.1 and it contains Japanese characters. When I try to export the report into PDF, I am not getting the Japanese characters in PDF. Instead of Japanese characters it's showing as empty in…
Rajasekaran M
  • 163
  • 2
  • 16
2
votes
2 answers

Pentaho Report Designer - Dynamic Data Sources

I have a local instance of the Pentaho Report Designer running on my box and it has a local development database configured as its data sources. (2 datasource configs, both pointing to the same local data server; source and target…
Lorin S.
  • 754
  • 8
  • 29
2
votes
1 answer

Pentaho APIs on tomcat apache 8 server(port - 8080) giving CORs issues when called through different web app(react JS, port - 3000)

I am stuck as a point where I've to call pentaho API to authenticate user from a reactJS app. Both are on my local machine. Things I've tried so far: a) Add a proxy in reactJS config file - package.json. issue - Code hits the localhost:3000 instead…
patna_programmer
  • 41
  • 5
2
votes
0 answers

Pentaho PRD - Summing Group'ed Values w/o Using SQL (Object-Based Datasource)

In Pentaho's PRD, I am working with an object datasource (i.e. I do not have a SQL query I may edit to group the data). To realize the required report, I must group the data within the PRD (OK) and only show these grouped values (OK). How can I…
Scott Young
  • 21
  • 2
2
votes
0 answers

Pentaho Report designer - parameterization on Locale Date format (~environment designtime- Locale)

Irrespective of locale date format, I need to genereate the report with the date format of the locale which i passed in runtime. Am getting the expected results when I am editing fr in environment-designtime-locale and running it. But I want that to…
Kiruthika
  • 23
  • 6
2
votes
0 answers

Pentaho Kettle don't work after packages update on Ubuntu 14.04

The spoon was working normally until an Ubuntu update was run. After updating the . / spoon.sh command don't start the application. I accessed the update log and saw that it only updated things pertaining to postgresql as shown…
Danilo Santos
  • 21
  • 4
2
votes
2 answers

Incorrect number formatting in Pentaho Report

I'm using Pentaho Report designer 3.9 for a legacy project that has some reports that should support different languages (English, Spanish and Euskera). I have a problem with the number formatting. While in English and Spanish numbers show properly…
ferpinan
  • 161
  • 2
  • 14
2
votes
0 answers

How to Display Dynamic Columns in pentaho reporting?

Am new to pentaho reporting. My requirement was, i have 20 fields, in those 20 fields user can give any fields by choosing their own sothat it populates that columns into report Example: Columns Names: A B C D E F G H ..............till…
Sekhar
  • 21
  • 2
2
votes
1 answer

Parameter Pentaho Report Designer with MDX

I am doing a report, using Pentaho Report Designer. My datasource is a Mondrian Cube with MySQL JDBC. I am using MDX queries, and I want to put paramerize it. I have to configure a parameter with its own query. I'm having trouble relating the main…
adayall
  • 31
  • 1
  • 3
2
votes
1 answer

Pentaho Report Designer: Passing list of values as parameters to report

Report Objective: Performance analysis of players by statistics comparison Desired Report Layout Please refer to the layout and read on. The player names need to be added from a list which could be anything like entry text box, multicheck box,…
AS91
  • 527
  • 7
  • 18
2
votes
1 answer

Pentaho Report Designer error in query

I am trying to create my first report in Pentaho Report Designer. I have created a JDBC Data Source and added a query: SELECT a.* FROM (SELECT Sum(loan_receivable_detail.interest) AS interest, loan_account_opening_id FROM…
ANonmous Change
  • 798
  • 3
  • 10
  • 32
1
vote
0 answers

Date parameters in Pentaho Report designer are causing report not to show results?

I have a report in report designer connected to Teradata. I am using a date picker with the date parameters in report designer. My query in Teradata works, but in report designer, there are no results when I run it. I beleive it is due to the date…
Alyssa Wisner
  • 11
  • 1
1
vote
0 answers

Pentaho report designer 8.3: crosstab report in Report header

I'm add a test query in dataset select title as attr_value, to_char(s,'YYYY') AS dt_year, to_char(s,'mm') as dt_month, 1 as data from my_test_table, GENERATE_SERIES('2018-01-01T00:00:00'::timestamp, '2018-05-01T00:00:00', '1…
scream
  • 11
  • 2
1
2 3
…
13 14