Pentaho Community Forums - Pentaho Reporting

Query scripting in report designer

bcoutts — Tue, 18 Jun 2013 21:08:07 GMT

I want to query the database for all records whose name is in a user-supplied list of names. I want to do this via query scripting, by generating a where clause that checks if the record matches something in the user-supplied list. However, I can't seem to find any documentation on query scripting in report designer; the official tutorial only mentions it in passing, and googling doesn't turn anything useful up. Ideally I'd like something that explains how query scripting works in general, but right now I just need to know how to access the value of a parameter to the report from within the script.

Right now I have this code:

Code:

String value = dataRow.get("param_name")

Where param_name is the name of the parameter in the report. However, when I actually run the report and supply the parameter, value is still null.

tl;dr: Can anyone tell me how to access parameters from within a query script, and/or tell me where I can find documentation, a tutorial, or an example of query scripting in PRD?

Need quick help to calculate percentage in Report Analyzer

talktoswapna — Tue, 18 Jun 2013 18:30:53 GMT

I have the following data:

Student_name Subjects Marks %
John Maths 60 60% (60/100)*100)
Science 30 30%
Social 10 10%

This is the general approach to calculate the percentage and the same is working on Pentaho Report analyzer tool with this data.

But when I filter out to select only two subjects (Maths, Science) then the percentage is calculating as:

Maths 60 66.6%
Science 30 33.3%

It is calculating the percentage based on the distribution of selected values.

is it not possible to get same actual values as Maths: 60% and Science 30% if I deselect other values in Pentaho Report Analyzer?

Help with formula for variable length rectangle

MarkS — Tue, 18 Jun 2013 16:38:10 GMT

Hi All,
This might seem like a simple request, but I'm banging my head on the wall so I thought I'd ask for help.

I want to creat a rectangle in report designer that changes length with data input, so I wrote this formula = ([ordered_gross_2013]/100) * (525/100)) in the max-width area of the style section, just like the Inventory List report example in the welcome area of report designer, but for some reason the rectangle width doesn't change. I'm sure it's something simple I'm overlooking but any help would be appreciated.

Thanks.

Parameter Datatype for multiple Values in PRD

student — Tue, 18 Jun 2013 14:03:20 GMT

Hi,

Can anybody tell me what is the Datatype for a multiple Parameter?

I have a Dashboard with a multiselectable Static List of Strings. I mapped the selection as a parameter to the report.
But in the Report Designer i dont find any Datatype for the Parameter such as Array or List or sth.

Thx :)

Need to pass a value from Report Designer to MySQL query. Is that possible?

Neels — Tue, 18 Jun 2013 13:48:48 GMT

Hi Taqua,

I am trying to make a report for one of our customer's requirement where we have to show the Total Amount in Words for various fields. I can convert number to words in mysql using a function written by us. But the challenge is, I have to sum up the fields of different records and then convert it to words. This summing up can be done easily in Report Designer by using ItemSumFunction (say Total_Sum) while in the mysql query it is equal to impossible. Is there any way of passing this Total_Sum value from the Pentaho to my mysql query.

Pl note that I am using a Subreport to carry out this part of my logic.

If you need, I can send youSubreport image.jpg the entire file.

Attached Images

Subreport image.jpg (40.5 KB)

Pentaho Hive2 Connection through Report Designer

gorav_goyal — Tue, 18 Jun 2013 10:38:10 GMT

Hi

Using Pentaho trial version for evaluation. In Report Studio, trying to create a HIVE2 connection but getting no response..

Got to know with some of the blogs that through Report Designer trial version, we cant connect to Pentaho HIVE2. Is it correct

Thanks
Gorav Goyal

Column freeze in pentaho html reports

spandana — Tue, 18 Jun 2013 08:59:54 GMT

Hi,

A report which contains 10 Columns. So if the user scroll left to right (First column to the last column), the first column should be freezed(in html).How to freeze column in report.

is it possible to run Classic Reporting Engine on IIS?

codex — Mon, 17 Jun 2013 18:51:47 GMT

Just started a new job in a .NET shop after doing a lot of Java. Told them about how great Pentaho reporting was. I've previously embedded the PRE in web pages and was wondering, since the classic engine runs independently of an app server, is it possible to embed PRE the same way. Unsure if it runs on the client or if it's running primarily on the server. I did some searches but not much turned up since it embedding the engine does not seem overly popular as it is. Does anyone know of a Pentaho level open source community product for .NET if that's not possible? Or are we stuck paying scads of money for the .NETy products?

Cheers and thanks!

Dashboard Auto Refresh - blank screen lag time

nmiles — Mon, 17 Jun 2013 15:04:36 GMT

Hello,

Does anyone have experience with this?

I've created a report in Report Designer and then added it to a Dashboard. The dashboard is a single report and set to refresh every 60 seconds.

When the report refreshes, the screen goes blank for a good 5 seconds (or longer) before returning again with refreshed data. Is there a way to minimize this blank screen time? The SQL query returns data instantaneously, and only returns 40 or so rows, so it is not a factor of waiting on the database. I have tried the refresh at the Dashboard general settings - properties level, and also at the report level. Both give pretty much the same results.

The reason I am looking for this, is this report is constantly viewed on a big screen to show current results. Having a blank screen 5 out of 60 seconds (almost 10% of the time) does not look good.

Thanks,
Nick

Y-axis range in bar chart

_enrico_ — Mon, 17 Jun 2013 13:14:45 GMT

Hello,

I hope you can help me with my problem.

I have a report with a bar chart, created with Pentaho Report Designer 3.9.0. The Y-axis-range and the interval for helping lines is set automatically by Pentaho. To see the automatic result I attached a litte screenshot.

report.jpg

My problem is that I want the y-axis-range to be higher, so that there is an interval with one helping line above my highest y-value.
In the example the range should be 0-100. So that the helping line on top is higher than my highest value.
There I have also attached a screenshot (with a fix setting of the range to 0-100)

report2.jpg

But i can't set the range fix to 0-100, because the range of my values differs a lot.

What can i do ?
Is there an option like "make on interval more ..." ? :-)

Thanks,
Enrico.

Attached Images

report.jpg (10.2 KB)
report2.jpg (11.6 KB)

Combine cells report to excel.

snake179 — Mon, 17 Jun 2013 06:46:06 GMT

Hi everybody,

I have a problem with Pentaho Report Designer. I have a report that contains fields with lot of words and Excel not combine cells with properly.
I would like to config a dynamic size or something that could combine cells when be necessary.

I attached a picture for your comprehesionreport.png

Many thanks! I wish you could help me.

Attached Images

report.png (3.8 KB)

passing group by parameter from master report to subreport

paranormalos — Sat, 15 Jun 2013 17:17:13 GMT

Hi,

I use json as the datasource for my master report with only one collection.
I group rows by field in my Report Group. Geting table details with everything I have after grouping I can't make
explanation section for these rows (which in Details) in Group Footer.

I tried to place a subreport in Group Footer with Band set to Block but the problem is that I can't iterate through rows as I did in Details section, because I'm losing Grouping parameter and I get all rows without grouping.

It might sound stupid but can you suggest how to path rows to subreport with grouping condition from Master report?

Thanks in advance.

Chart Post-Processing Script for Adding Dataset

sean.omalley — Fri, 14 Jun 2013 21:00:44 GMT

I have a query that returns one row of data and I am trying to plot the data on a chart with multiple series. I am unable to use the dataset collectors in the chart interface, so I thought I could create the dataset using a post-processing script. I've been unsuccessful so far. Here is my script:

Code:

import org.jfree.data.category.CategoryDataset;

import org.jfree.data.category.DefaultCategoryDataset;



DefaultCategoryDataset defaultcategorydataset = new DefaultCategoryDataset();

                defaultcategorydataset.addValue(10D, "Series 1", "Category 1");

                defaultcategorydataset.addValue(4D, "Series 1", "Category 2");

                defaultcategorydataset.addValue(15D, "Series 1", "Category 3");

                defaultcategorydataset.addValue(14D, "Series 1", "Category 4");

                defaultcategorydataset.addValue(-5D, "Series 2", "Category 1");

                defaultcategorydataset.addValue(-7D, "Series 2", "Category 2");

                defaultcategorydataset.addValue(14D, "Series 2", "Category 3");

                defaultcategorydataset.addValue(-3D, "Series 2", "Category 4");

Any ideas?

Many Thanks,
Sean

Cannot get JNDI datasources working in report designer

bcoutts — Fri, 14 Jun 2013 19:42:33 GMT

I'm trying to configure PostgreSQL datasources to work from JNDI. I copied over a working default.properties file from another machine to ~/.pentaho/simple-jndi/default.properties, but when I test them in report designer, I get a stack trace leading to a NullPointerException. I can connect to the databases from the command line, and through report designer by connecting directly without JNDI, using the same information/credentials used in the default.properties file. Is there some log file for report designer I can consult?

Is there any way I can get more info about why it's failing? It seems to fail in exactly the same way if I simply use the wrong JNDI name in report designer, and a NullPointerException is an extremely unhelpful error message.

EDIT: I've been working on it a bit more, it doesn't look like it cares what I define the connection type as, it gives me the exact same error if I specify postgresql, mysql, or even the ones for which I don't have drivers. It's as if it isn't reading the default.properties file in ~/.pentaho/simple.jndi. I have also tried renaming the file to default.ini, and removing all comments per a suggestion I saw on the forums, but to no avail.

I'm running 64-bit Ubuntu 12.10, with PRD 3.9.1., using PostgreSQL 9.1.9.

What to do in PRD when using a Java TableModel

clic — Fri, 14 Jun 2013 13:34:00 GMT

This might be a simple question, but I don't know what to do in PRD when passing in a Java TableModel.
I thought I have to make a Table data source and name the columns exactly as they are named in the TableModel. But the report preview showing up in my Java application is empty.
So doesn't it work that way ??

Basically I'm doing the following:

Code:

TableModel tm = ResultSetTableModelFactory.getInstance().createTableModel(rs) ;     //  generate a TableModel

DataFactory df = new TableDataFactory("Query 1", tm) ;                                        //  generate a DataFactory 

report.setDataFactory(df)                                                               //  setting the DataFactory of the report object

the report object is generated like this:

Code:

final ClassLoader classloader = this.getClass().getClassLoader();

final URL reportDefinitionURL = classloader.getResource("tablemodel_report.prpt");

final ResourceManager resourceManager = new ResourceManager();

resourceManager.registerDefaults();

final Resource directly = resourceManager.createDirectly(reportDefinitionURL, MasterReport.class);

return (MasterReport) directly.getResource();

Pleeease help!!
thanks.

Displaying the pentaho generated reports to the user

mrsanketh — Fri, 14 Jun 2013 10:55:43 GMT

Hi All,

Can you please help me, how to display the report generated using the pentaho tool should be shown to the End User. Basically, I just need to understand, how to display the report after building the report? Please forward me the steps in doing so..Thanks a lot in advance.

embedding pentaho reports in liferay portlet

divyaR — Thu, 13 Jun 2013 12:34:39 GMT

hi ,

i am presently working on a project which has the following requirement

main project :-

i have a portlet whic accepts a certain values with help of a drop down . say date, category , severity , format(pdf/html/excel)

requirement :- the values accepted here should go to pentaho report and display report accordingly below this portlet in an iframe .
ps:- this project runs with the help of liferay tomcat .

project 2 ( small project)

this project already can genrate pentaho reports with eclipse using Apache tomcat.
ps:- here i am hardcoding all the values to be pushed to pentaho report and the pentaho report opens up in a new tab using a URL ..
the flow being used here is that :-
i create following three classes
1.) xml parser class
2.) parametermap class
3.) generator class

then i make a service class for function defination of above

and then finally use a controller to handle all the functioning wherei hard code all the values

i am also making a folder for prpt reports under web-inf for report fetching .

so my task is to integrate the sub project with the main project and i have no freaking idea how to do it !

urgent help required..
!
:o

problem :-

Subreport parameter not available in main report

lbecker — Thu, 13 Jun 2013 10:54:15 GMT

Hi

Using Reporting Designer 3.9.1-GA. 16112

I am using a sub report and need a result from the sub report to be available in the main report. I have set up an "export Parameter" in the sub report.

SubReportParameter.jpg

I can however not find the sub report parameter in the main report. Is there something else I need to do?

Thanks
Louis

Attached Images

SubReportParameter.jpg (16.2 KB)

java.util.prefs.BackingStoreException: Failed to write config

MSorvo — Thu, 13 Jun 2013 10:31:33 GMT

Hi,

I'm starting to get error while saving the report. I tried to look what the problem might be but I'm getting no clue. Version I'm using is 3.8. I've check the path but there's nothing. Can anyone help with this or give any tips where to start looking?

Error message:

Code:

java.util.prefs.BackingStoreException: Failed to write config C:\Users\msorvo\.pentaho\report-designer\user\org\pentaho\reporting\designer\recent$002dfiles\prefs.properties

    at org.pentaho.reporting.designer.core.settings.prefs.BinaryPreferences.syncSpi(BinaryPreferences.java:205)

    at org.pentaho.reporting.designer.core.settings.prefs.BinaryPreferences.flushSpi(BinaryPreferences.java:248)

    at java.util.prefs.AbstractPreferences.flush2(Unknown Source)

    at java.util.prefs.AbstractPreferences.flush(Unknown Source)

    at org.pentaho.reporting.designer.core.settings.RecentFilesModel.store(RecentFilesModel.java:112)

    at org.pentaho.reporting.designer.core.settings.RecentFilesModel.getFilesAsList(RecentFilesModel.java:99)

    at org.pentaho.reporting.designer.core.settings.RecentFilesModel.getRecentFiles(RecentFilesModel.java:61)

    at org.pentaho.reporting.designer.core.ReportDesignerFrame$RecentFilesUpdateHandler.settingsChanged(ReportDesignerFrame.java:631)

    at org.pentaho.reporting.designer.core.ReportDesignerFrame.createMenuBar(ReportDesignerFrame.java:1157)

    at org.pentaho.reporting.designer.core.ReportDesignerFrame.(ReportDesignerFrame.java:1033)

    at org.pentaho.reporting.designer.core.ReportDesigner$CreateReportDesignerFrame.run(ReportDesigner.java:137)

    at java.awt.event.InvocationEvent.dispatch(Unknown Source)

    at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

    at java.awt.EventQueue.access$000(Unknown Source)

    at java.awt.EventQueue$1.run(Unknown Source)

    at java.awt.EventQueue$1.run(Unknown Source)

    at java.security.AccessController.doPrivileged(Native Method)

    at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)

    at java.awt.EventQueue.dispatchEvent(Unknown Source)

    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

    at java.awt.EventDispatchThread.run(Unknown Source)

Page break after group, except for the last group

Joris — Thu, 13 Jun 2013 07:50:33 GMT

Hi everyone
In PRD I do a page break after a group footer. It works fine but of course, add an empty page after the last group.

How can I make the page break work for every group but the last?

thks for your help

Formats of automated reports

francisco-reyes — Thu, 13 Jun 2013 02:17:30 GMT

My company is starting to get up to speed with Pentaho for some reporting we will be doing for a client.
From what I am getting reported from my developers it seems the available formats when doing automated reports run with kitchen are: xml, json, sql, text, xls

We need to create some reports every night and we need to have the output in HTML or have a place where the client can go to see the reports. Is that doable? What should we be looking at?

Any pointers greatly appreciated

[Edit] Corrected name of tool

layout.xml file modification using WinZip

ShaileshS — Wed, 12 Jun 2013 10:08:07 GMT

I am stuck in one issue in Pentaho Report designer.below are the details.

I am modifyning the .prpt file outside the Pentaho Report designer by modifying the layout.xml file but after compression it is showing "Unable to open the file as valid report defination" error.Below are the steps i am following.

1.Extract .prpt file using WinZip software

2.modify layout.xml file and save it.

3.Compress all the files using WinZip software.

4.Change the extension of the compressed file from .zip to .prpt.

5.open the file in Pentaho Report studio.

Please let me know if this is the regular practice to change the pentaho report outside the Pentaho report designer environment.
Also please let me know how can i resolve the above error.

Report with external image (URL from DB)

Emerge — Tue, 11 Jun 2013 22:31:39 GMT

Hi,

I'm learning PDI and PRD.

I want to put an external image in one report. I read the path of this image with the Report Wizard. I have this data:

My image path is 'poster'.

I want to use this path and add an image to my report. If I add an image and put a path like this 'http://www.pentaho.com/images/pentaho_logo.png' it works, but I want to use the path that I've read from my database.

How can achieve this??

Thanks!

Custome Settings/Parameters in a report

mvaccarello — Tue, 11 Jun 2013 16:45:24 GMT

We have a generic reporting capability that some users want to have certain customizations/options available. For example, one group prefer to have reports default to current month/year. Other users would prefer the most recent month.

If we had a setting/variable such as "CurrentMonth" and had it set to 1 or 0 (true/false) we could set the default with a simple IF clause. We have some other similar customizations that users have preferences for as well.

We don't want to use Environment Variables via the CreateEngine properties file because this file could be overwritten on updates. We were trying to figure out how to have our own properties/settings file. We haven't found a solution exactly like that. We don't want to query a database every time either. So, our current thought is to create a datasource to an XML file that could be pointed to by all reports and then could get the values they need from the XML file.

We are open to some suggestions or other ideas that are easier or better ...

THANKS

Multiple reports in one

Duncanmaster — Tue, 11 Jun 2013 13:59:00 GMT

Hi everyone,
i'm wondering if it's possible to create a report that include other existing reports and execute them like they were subreport.

Let me explain better:
Let's assume that I've 3 reports.
And suppose that I want a single PDF with the result of all 3 reports inside.
There's a way to create a new report that can execute the previous 3 reports like they were subreports, passing them specific parameters? or something similar?? :P

Actually I can accomplish this scheduling all involved reports and then merging pdf files with an application :/

I know, it's a strange question :P but it's more a curiosity that a real problem :D

Thanks ^_^

Adjust height of parameter area in the Swing PreviewDialog

clic — Tue, 11 Jun 2013 10:26:27 GMT

Hello,
I'm wondering if I can change the height of the area where the parameters are displayed in the Swing PreviewDialog?
The reason is, that the area is to small and always have to adjust the height manually to see my parameters.

I read something that the corresponding class may be the ParameterReportControllerPane .. !?

thank you!!

max number of datasource connexions

nad — Tue, 11 Jun 2013 10:20:58 GMT

Re-hi :),
It's me again. Just a little question: how much datasources could we set with pentaho report designer and pentaho server.
If somebody knows.....
Thanks

Querrying multiple databases with Pentaho Report Designer

nad — Tue, 11 Jun 2013 10:15:05 GMT

Hi all,
I would like to know if it is possible for PRD to execute a sql querry wich will be applied to many datasources ( around 60 datasources ) .
I have seen that to have information about a database , we have to set the jdbc connexion and after write some queries which will display the wanted result .
But to do my report ( if I have to use this method) I would have to write the same querry 60 times (for all my datasources), and it is simply impossible because I have a lot of reports to do

If anyone has a suggestion, I'm all ears.
Thank you for your availibility :).

Use java.sql.Connection object from Java application

clic — Tue, 11 Jun 2013 10:14:56 GMT

Hello,
I'm using the Swing Preview dialog to view my reports (designed in PRD) out of a Java application.

Is it possible somehow to use an existing java.sql.Connection object as the JDBC connection?

I need this because I have many different database connections (with 'dynamic' database names) and I don't want to have the credentials beeing exposed in some kind of PRPT or JNDI file.

The other option I was thinking of is to access the connection properties via JavaScript in PRD - but unfortunately I couldn't find any detailed information on the web...

Thanks very much!!

customize parameter list box

venusuresh — Mon, 10 Jun 2013 23:54:18 GMT

I need a single select list box to be stretched out a bit more than the default size. i couldn't find any property that does that. Can it be programmed to customize the look and feel of a single select list box

call subreport from a report

venusuresh — Mon, 10 Jun 2013 23:50:45 GMT

Is it possible to call a subreport by clicking on one of the row values of a subreport

pagination or scrolling inside inline subreport

venusuresh — Mon, 10 Jun 2013 20:55:25 GMT

i have an inline subreport looking like a window, where i have to display rows of data. Since it's a window, it can only display 15 records at a time. so i am trying to implement pagination to display the remaining records. so far, i haven't seen any feature supporting the above. so wondering if an inline subreport can have pagination or atleast a scrolling capability.

subreport executing multiple times based on parameter values

venusuresh — Mon, 10 Jun 2013 20:31:31 GMT

i created a subreport that runs off a query with from three different parameters (which are dropdowns). Based on the first parameter, second parameter gets populated. Based on the second, third parameter, and based on the third parameter, subreport gets populated. Here is the issue. if the third parameter has 10 values in the drop down, subreport is executed 10 times. I also figured out that when the second parameter is chosen, subreport is executed 10 times with empty values. So i'll have to restrict the subreport from getting executed only once.

Test if a parameter matches a database value using ILIKE

bcoutts — Mon, 10 Jun 2013 17:30:22 GMT

I'm writing a report in report designer. One of the fields is name, and I essentially want to do this in my query:

Code:

WHERE tbl.field ILIKE '%${name}%'

However, I can't figure out a way to make this work in pentaho. The above query simply fails (I assume pentaho doesn't replace variables if they're in quotes). I can't do "WHERE ILIKE tbl.field ('%' || ${name} || '%'), because this fails when the name field is empty. If I apply a post-processing formula to surround the parameter with %s, the input textbox keeps getting filled with %s every time a field is updated. If I try using an open formula to represent %name%, it doesn't work because open formulae are calculated after the query is done.

I'm using Pentaho 4.8, on 64-bit Ubuntu 12.10; the database I'm connecting to is running PostgreSQL 9.0.13.

tl;dr: How can I have a SQL WHERE clause that is true if and only if an input parameter is contained in a database field?

Integration of Pentaho Reports with Eclipse

Priyanka17 — Mon, 10 Jun 2013 12:19:48 GMT

I am trying to integrate Pentaho reports with Eclipse with the help of pentaho reporting sdk engine. Reports are getting deployed succesfully till there is no subreport and function in it.
Sub reports are not getting deployed if a parameter is defined in it. Error is coming as ReportDataFactoryException. If I remove parameters, sub report is working fine too.
Please help me by guiding that where i am going wrong.

How to reduce space between bars in bar chart?

anushareddy — Sat, 08 Jun 2013 06:10:21 GMT

hi anyone could help me to reduce space between bars in bar chart?

Conditional SUM in Pentaho Reports 3.9

gonzaloruzafa — Fri, 07 Jun 2013 22:03:52 GMT

Conditional SUM in Pentaho Reports 3.9

I have a problem.

I am not being able to calculate a conditional sum function.

For example, a table like this

Name Apples

Brad 5
Mike 2
Brad 1
Peter 4

I want to get the a function to calculate

-the sum of apples just for Brad (7)
-sum of apples just for Brad (7) minus the sum of apples just for Peter (4). Result (7-4=3)

Anyone could help me?

Thanks

Not displaying Integer field value in number field

Nawwu — Fri, 07 Jun 2013 12:45:46 GMT

I have a custom JDBC driver that I use to access data from our custom database.

The problem is I am able to preview the data successfully and able to display String data in a string-field too but I am not able to disaply Integer data in number-filed (I am able to do it in string-field though).

What could be the reason ?

Thanks

passing a multi value parameter within a stored procedure

Mihai — Fri, 07 Jun 2013 10:14:25 GMT

Hello everyone,

I created a stored procedure in MySql for processing my data.
In Pentaho Reporting I want to use a multi-value parameter.

In data sources I have a query which calls for the procedure:
call procedure_name(${param1},${param2})

How can I use a multi value parameter in this query?
For now the only solution that I have is to write the whole query in Pentaho Reporting. But I want to avoid that, by calling the procedure.

Thanks in advance,

Pour data form Application Java(Swing ) into Report of Petaho

petervn — Thu, 06 Jun 2013 16:57:57 GMT

Title:Pour data from Java Application(Swing ) into Report of Petaho

Example I have a ArrayList listCustomer;
and i have report (*.prpt) which is designed to show listCustomer.
I want to pour listCustomer into report
How to pour listCustomer into report ?
---
If you have a demo to explain my problem ,pleage give me :).
Please help me thank you much.

How to use functions(sum,avg etc,.) in bar charts?

anushareddy — Thu, 06 Jun 2013 05:08:48 GMT

Anybody could tell me How to use functions(sum,avg etc,.) in bar charts?

In report wizard we have option for applying functions before preview option, like that is there any way to do for bar chart? or else i have to it in query itself?

CrossTab reporting using Report Designer or other tool in Pentaho

Abhinav1singhal — Wed, 05 Jun 2013 21:06:23 GMT

Hi All,

We are trying to generate crosstab reports in Pentaho using report designer 4.8 . This feature is experimental and we don't want to use an experimental feature.

Please let us know if anyone has tried generating crosstab reports, using Pentaho Report designer and not using experimental crosstab feature?

Regards,
Abhinav

Radar Chart chart doesnt fill up the grid

vinecz — Wed, 05 Jun 2013 14:57:29 GMT

Hi,

this is a simple doubt about the Radar Chart,

i have this image

spider_chart.png

how could i configure this image to fill up the grid area like that

thanksspider_fill.png

please help me

Attached Images

spider_chart.png (11.3 KB)
spider_fill.png (10.3 KB)

Data doesnt show up in my Chart

vinecz — Wed, 05 Jun 2013 14:52:35 GMT

Hi Folks,

i've created this bar chart in my PRD 3.9.1 and something wrong is happening.

i have data to show up in my first bar but 'case my size-font is 12 px doesnt works.

if i down the size-font to 8 px will work, but nobody can see the numbers.

how could i configure my chart to show up the numbers even with low size of my bar.

have a look the image:

chart.png

please, help me

Attached Images

chart.png (10.7 KB)

Dynamic connection (PRD-3657 and PRD-2854)

YGuenane — Tue, 04 Jun 2013 09:39:35 GMT

Hi,

At the moment I have two identical Pentaho instances to provide identical reports. The only difference is the connection source. I have labeled my JNDI connection CONN on both instances and configured it differently on each instance respective PAC. Unfortunately this implementation can't scale really well since one customer will mean one pentaho instance.

The idea here would be to have a single pentaho instance and somehow pass the JNDI/JDBC informations as parameters, this - for my needs - would scale much better.

Based on Taqua's last comment on this ticket - PRD-2854 - passing JNDI as a parameter is not an option. However it is said :

Quote:

Given that JNDI customization can be done via scripting now

I have been looking at the three examples on PRD-3657, they all seem to only deal with the datasource via the computeQuery function (ie. the query) but not the connection itself.

My question is : is there anyway to dynamically select a specific connection on runtime, be it via a script (Global Scripting?) or via any other way ?

I am using Pentaho 4.8 and Pentaho Reporting 3.9.1.

Thank you,

Parameter Doesnt Works [ Urgent ]

vinecz — Mon, 03 Jun 2013 22:45:57 GMT

Hi Folks,

i have a parameter in my PRD that doesnt now working.

This parameter has a Dropdown list that returns this string '2013/05' that means 'YYYY/MM'.

after get this value selected in the dropdown list i set up it in my query with ${p_year_month}.

my parameter has datatype STRING, ok ?

but doesnt not work.

someone could help me ?

PRD Open formula Substitute more than one character

Joris — Mon, 03 Jun 2013 13:12:27 GMT

Hi everyone
In one of my report I have text without space. Instead of space they have _ or -
So i'm using the function SUBTITUTE to replace it

Code:

=SUBSTITUTE([nom_Projet]; "_" ;" ")

With this I only replace _
So the question is, can I substitute with a single function the two characters?

The other solution that I found is kind of dirty (in my opinion): I do it with two functions. The first function replace the "_" and the second function use the text of the first one and remove "-"

How to set up non mandatory parameters?

anushareddy — Mon, 03 Jun 2013 11:27:41 GMT

Hi,

Anybody could explain me how to set up non mandatory parameters in report designer?

How to have ranking in my report

sukesh_k — Mon, 03 Jun 2013 07:09:18 GMT

Hi,

I need to create a report with ranks. Heard that this is not possible in Pentaho.

Could you please let me know if this is really not possible.

Also let me know how to have drilling enabled in my report ?

This prompt value is of an invalid value

wim — Sun, 02 Jun 2013 19:52:56 GMT

Hi all,
I got this error :Element overlaps with other content and will note be printed in table-exports.
Have you any idea,what does it mean? whene I try to publish the report an an other error appear in the user console This prompt value is of an invalid value.
Here's the log:
2013-06-02 20:17:58,577 WARN [org.pentaho.reporting.libraries.base.boot.PackageManager] Unresolved dependency for package: org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaModule
2013-06-02 20:17:58,658 WARN [org.pentaho.reporting.libraries.base.boot.PackageSorter] A dependent module was not found in the list of known modules.
2013-06-02 20:18:12,803 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] c8efd75d-cbb0-11e2-a425-2d49cf696209:SOLUTION-ENGINE:scheduler.xaction: Action Sequence execution failed, see details below
| Error Time: dimanche 2 juin 2013 20 h 18 CEST
| Session ID: scheduler.xaction
| Instance Id: c8efd75d-cbb0-11e2-a425-2d49cf696209
| Action Sequence: scheduler.xaction
| Execution Stack:
EXECUTING ACTION: Scheduler (org.pentaho.platform.engine.services.solution.PojoComponent)
| Action Class: org.pentaho.platform.engine.services.solution.PojoComponent
| Action Desc: Scheduler
| Loop Index (1-based): 0
Stack Trace:org.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - [fr_18] Activity failed to execute
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1325)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
at org.pentaho.platform.scheduler.QuartzExecute.execute(QuartzExecute.java:198)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

2013-06-02 20:18:16,280 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:18,724 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:19,127 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:20,117 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:20,713 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:21,090 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:21,447 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:21,702 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
2013-06-02 20:18:21,737 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
2013-06-02 20:18:21,897 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:22,300 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:23,595 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:23,789 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:24,076 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:24,476 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:24,931 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:25,300 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:25,623 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:25,847 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
2013-06-02 20:18:25,875 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
2013-06-02 20:18:26,048 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:18:26,370 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2013-06-02 20:24:37,177 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value 'null'
2013-06-02 20:24:37,277 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Libelle commission' with value 'null'
2013-06-02 20:24:37,492 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value 'null'
2013-06-02 20:24:37,493 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Libelle commission' with value 'null'
2013-06-02 20:24:42,602 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2012'
2013-06-02 20:24:42,605 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Libelle commission' with value 'null'
2013-06-02 20:24:45,292 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value 'null'
2013-06-02 20:24:52,814 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2012'
2013-06-02 20:25:08,352 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2012'
2013-06-02 20:25:11,230 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2013'
2013-06-02 20:25:23,560 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2012'
2013-06-02 20:25:26,901 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2013'
2013-06-02 20:25:32,506 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value 'null'
2013-06-02 20:34:22,148 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2012'
2013-06-02 20:34:25,339 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2013'
2013-06-02 20:34:28,289 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2012'
2013-06-02 20:50:39,415 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2012'
2013-06-02 20:54:11,248 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2013'
2013-06-02 21:03:08,262 ERROR [org.pentaho.platform.repository.solution.SolutionRepositoryBase] SolutionRepository.ERROR_0023 - Invalid publish location: Root Folder
2013-06-02 21:05:02,375 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value 'null'
2013-06-02 21:05:02,383 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Libelle commission' with value 'null'
2013-06-02 21:05:02,524 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value 'null'
2013-06-02 21:05:02,526 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Libelle commission' with value 'null'
2013-06-02 21:05:06,516 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value 'null'
2013-06-02 21:05:09,375 WARN [org.pentaho.reporting.engine.classic.core.parameters.DefaultReportParameterValidator] Parameter validation error: No such value in the result for 'Année' with value '2012'
Any help pleaase?
Thanks in adavance

Report takes too much time redering in excel

Jayesh — Fri, 31 May 2013 13:47:47 GMT

Hi,

I have 21K odd records in DB. My report has 30 fields and header to display. It takes almost 8 to 10 mins to display report in excel.

I am using SQL server as DB. Data is getting retrieved from a stored proc. DB returns same data in around 26-30 secs. I am using JNDI connection at pentaho side.

Why is it taking so long? Is there any way to make it faster?

Regards,
Jayesh

Sharing reports developed with Pentaho EE

hoovlermichael — Thu, 30 May 2013 17:44:30 GMT

Hey all, Was wondering if it's possible to use Report Designer in the Pentaho Enterprise Edition to develop a report, and then be able to share that with organizations who may only have the open-source tools installed, assuming those organizations have access to the source data as well. Has this been done by anyone before, and did you encounter any issues in doing it? Thanks!

Mondrian OLAP and formula in PRD reports

Smoodo — Thu, 30 May 2013 15:50:18 GMT

My report uses an MDX query as a data source. I have no problems with grouping or showing data on screen. What I wanted to do is use one of the fields returned from Mondrian in a formula, specifically to alter the visibility of the element on canvas. The formula I tried is

=IF([Income Statement].[Account Number] >= 900000; true(); false())

The formula simply does not work. No warnings, no errors, just silently not performing the task. Any guidance towards a solution or method of troubleshooting would be appreciated.

OLAP_and_Formula.jpg

Attached Images

OLAP_and_Formula.jpg (27.5 KB)

Resource-field definition

dadapenta — Thu, 30 May 2013 09:44:36 GMT

In my resource bundles file this is the definition for a resource-message field:
res_msg_field_1=Report date: $(report.date, date, dd MMMM, yyyy - HH:mm)

How I define a resource-field in the resource bundles file?

Thanks

Is it possible to create dynamic prpt ?

Timy — Wed, 29 May 2013 12:51:44 GMT

Hi All ,

I have been using static prpt templates to generate reports till now .Now I have challenge to use dynamic templates to generate PDFs and Excels .I have the query and list of columns to be displayed .At least is it possible with the xml data input ?

Please suggest me if you have any idea ..

Thanks & Regards,
Timy K

Linking directly to Adhoc Report Builder and specific data source

Nhoeft — Tue, 28 May 2013 16:33:04 GMT

Does anyone know how to link directly to the Adhoc Report Builder, and if possible a specific data source within the builder. Currently, when I try to do this from an outside link, it brings me to the logon page. I would like to be able to pass the credentials through without the user seeing the logon screen. This seems like it should be fairly straight forward, but I am having a hard time getting it working and have found very little reference to how to do it correctly.

Any help would be greatly appreciated.

Thanks,

N

Cant publish a report from Pentaho Report Designer

nmalepati — Tue, 28 May 2013 02:58:10 GMT

Hello All,

I was successfully able to create a report using pentaho report designer but not able to publish that report. When I try to publish the report by clicking File -> Publish I see a pop-up screen(attached) with fields URL, Timeout, User and Password. Mentioned below are the values supplied to those fields.

URL: http://localhost:8080/pentaho
Timeout: 30
User: Joe
Password: password

After I click "OK" it try's to validate login info and nothing happens. I also checked publisher_config.xml file and it had "password" as the password.

Anything needs to be done before publishing the report from report designer? Let me know if you need any more info to solve this issue.

Pentaho_1.jpg

Attached Images

Pentaho_1.jpg (31.6 KB)

New in report designer

Aldarius — Mon, 27 May 2013 15:54:32 GMT

I'm new at this type of programs to do reports and have problems with some "large" sub-queries. I used in other report a sub-query with another table that only has 14 string values * 2 fields, so not a big deal at all. But this table, dw.equipament, have 113 rows and that makes the things slow. The main query is this:

select comarca as lloc, poblacio, categoria, num_equipaments,
poblacio/(select count(distinct(e.id_cat_equip)) from dw.equipament e, dw.oferta o,
dw.poblacio p where temps = ${temps} and (p.comarca = lloc and
o.id_poblacio = p.id_poblacio) and e.id_cat_equip = o.id_cat_equip) as sumatori
from dw.oferta o, dw.poblacio p, dw.equipament e where temps = ${temps} and
((p.provincia = ${zona} or p.comarca = ${zona}) and o.id_poblacio = p.id_poblacio) and
(${tipus}='Tots' and o.id_cat_equip = e.id_cat_equip)

union

select comarca as lloc, poblacio, categoria, num_equipaments,
poblacio/(select count(distinct(e.id_cat_equip)) from dw.equipament e, dw.oferta o,
dw.poblacio p where temps = ${temps} and (p.comarca = lloc and
o.id_poblacio = p.id_poblacio) and ((trim(e.grup) = trim(${tipus}) or
trim(e.categoria) = trim(${tipus})) and e.id_cat_equip = o.id_cat_equip)) as sumatori
from dw.oferta o, dw.poblacio p, dw.equipament e where temps = ${temps} and
((p.provincia = ${zona} or p.comarca = ${zona}) and o.id_poblacio = p.id_poblacio) and
(${tipus}!='Tots' and (trim(e.grup) = trim(${tipus}) or
trim(e.categoria) = trim(${tipus})) and o.id_cat_equip = e.id_cat_equip)

group by lloc, categoria
order by lloc, categoria

I calculate that new field, sumatori, as in the first report that combines two measures I say that doing Sum(Running) in the group footer was adding more than needed. For example, in a location with a population of 500K and 4 categories for "equipament" there was 4 rows that are same in the location, so was adding 2M to the population, and I want to sum only 500K for that one. With that field, sumatori, every one of that rows would have 500K / 4 categories = 125K. That variable was not going to appear in the report but used for the Sum(Running) later. My question is: is there a way to not have duplicate parts? I suppose that people will say "put a sub-query" but have tried to put a group inside the group and the result is the same, so don't know how to do it. My objective is transform what currently I have in this:

report.jpg

As with 113 rows in equipment right now is insanely slow and want to forget that "sumatori" field. Thanks in advance.

Attached Images

report.jpg (56.4 KB)

inline sub-report data not loaded

alihonarmand — Sun, 26 May 2013 10:18:05 GMT

Hi,

I have problem using sub-reports in inline mode. Data on inline sub-reports are not loaded or at least not viewed, while in case I use banded sub-reports everything works fine. The whole report is a simple test report which includes a sub-report. I have passed a parameter from the master report to the sub-report.
I should add that I use pentaho report designer v.3.9.1 community edition
regards,

A. Honarmand

Using parameters in MDX queries

paulo.f.rezende — Sun, 26 May 2013 02:48:55 GMT

Hello guys,
I have a MDX datasource that I want to use parameters.
I have two questions:
1 - You can use parameters in MDX queries?
2 - How do I get to ranges in MDX to get the results that a larger date entered?

... sorry for bad english ..

my best regards guys

Hola a todos

mayrelis — Sat, 25 May 2013 20:16:31 GMT

Soy nueva en la implementacion de reportes utilizando pentaho. Tengo creado mi primer reporte y cuando voy a publicar el reporte en el pentaho server me da el error que veran a continuacion y quisiera saber si me falta algun paso, ya instala el jdk y configure las variables entornos del sistema y tengo corriendo el tomcat del pentaho BI server, agradezco cualquier ayuda que me puedan dar.
org.pentaho.reporting.designer.extensions.pentaho.repository.util.PublishException: Publish failed, please see server logs for further details.
at org.pentaho.reporting.designer.extensions.pentaho.repository.util.PublishUtil.publish(PublishUtil.java:247)
at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.PublishToServerTask.run(PublishToServerTask.java:119)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:705)
at java.awt.EventQueue.access$000(EventQueue.java:101)
at java.awt.EventQueue$3.run(EventQueue.java:666)
at java.awt.EventQueue$3.run(EventQueue.java:664)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:675)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:211)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:128)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:117)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:113)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

Export options restriction.

Naseeruddin — Fri, 24 May 2013 07:40:32 GMT

Hi Team,

Can we restrict the export options in Pentaho report designer?
When we click on the exort option(green arrow buttion) , we get various export options like pdf,excel Excel,Excel 2007 etc.
I want only Excel to display in that list. Is it possible? If possible can you please suggest how to achieve the same.

Thank you.
Naseer.

Lock excel cells

Naseeruddin — Fri, 24 May 2013 07:35:44 GMT

Hi Team,

When i export to excel i want the cells to be locked (non editable) so that the user does not change the data in the excel report.

Can you please help on the same ASAP like How to keep the cells locked(non editable) after the report is exported to Excel.

Thank you in advance.

Naseer.

Reusing sub-reports in multiple reports

briantd — Thu, 23 May 2013 23:50:40 GMT

Is it possible to reuse sub-reports? I'd like to create a library of sub-reports for use as building blocks, but am unclear as to whether this is even possible.

Thanks,
-Brian

What I should use for reporting, design studio or report designer?

thangpm — Thu, 23 May 2013 23:22:56 GMT

Hi all,

I'm a newbie in pentaho. I'm studing design studio and report designer to create reports with chart.
I don't know what is best choice and what is different between design studio and report designer in reporting.

Anyone can help me to figure it out?

Thanks,
Thang.

Maximum Number of Columns in Adhoc Report

birtPentahoUser8 — Wed, 22 May 2013 20:12:51 GMT

I have an adhoc report where we would like to include more than 100 columns and export it as Excel/CSV for analysis. However, whenever I add more than 100 columns, the report's resultset suddenly becomes 0 rows and no data is returned. I have turned my log4j debug level up to DEBUG, but no new error message appears in the log file. I did extract the SQL query from the log files and the query is valid and returns 16 rows with 100+ columns when run directly against mysql. However, the adhoc tool still displays no data in the report's output.

Is there a maximum number of columns in an adhoc report? If so, is the limit 100 columns?

Report designer 3.9.1.: Embedded call to engine produces charts in pdf not html

mnl — Mon, 20 May 2013 23:02:12 GMT

When invoking the reporting engine in embedded fashion (using sample code from 3.9.1. sdk) and putting all the jar files from the lib directory of report designer and the lib directory of the report designer SDK, the pdf output file contains all the subreport embedded bar charts but the html version did not - it is blank white space!

Both version show the report header and the banded tabular output after the subr-reports and other fields in the master report.

There are no warning at all; The sdk sample program was modified in eclipse, i.e. AbstractReportGenerator and its derived class. So nothing special about the engine invocation from java.

Is there a way to set a debug mode where the java embedded call to the reporting engine will tell us why he is ignoring drawing the bar graphs in the 4 embedded sub-reports when the output format is html mode?:confused:

Is it missing jar files or something else? There are no warnings

Environment Centos, report designer 3.9..1, sdk also 3.9.1. Eclipse Helios Java

I have one doubt about function MultiValueQuery

vinecz — Mon, 20 May 2013 13:15:32 GMT

Sr,

howz going ?

I'm using a MultiValueQuery in my parameter to return the values of my another query.

i have just one Column with 7 lines and my return just show the first value of my parameter.

and my question is how to show all of my results using multivaluequery. or if have another way to get it.

im waiting this answar asap.

thanks