Pentaho Reporting (Classic) | Forum profile

Quote: Originally Posted by pled76 (1) Only the report header is corrupt. Other sections and headers are correct. We tried basic templates with no change to them and to the fonts properties. So it seems as the bug either in basic template or in the PDF exporting code (taken from Jaspersoft). Well, our PDF export uses iText, not jasperreports. Actually, we have a perfectly sane reporting engine and do not need to use a 3rd party tool to print...

Quote: Originally Posted by karthik Hi, I have designed the reports using Pentaho Report Designer 3.5 , I have three reports connected using hyperlink option, I am passing one parameter (say parameter A) from report #1 to report #2, now I want to pass the same parameter (parameter A, which is coming through url) from report #2 to report #3 using hyper link. Please let me know how to achieve this in Pentaho report designer 3.5. Thanks in...

Hey again, I have a question regarding some odd behavior I can't seem to find on the forums. I'm using DB2 via a native JDBC connection and run a sql string like Code: select * from myTable where ${myParam} is not null or select * from myTable where myTable.myDateField > Date(${myParam}) Anyway, I can pretty easily get around the second one by just using java.sql.date parameters, but I'm trying to test for null params....

Good afternoon! Whether it is possible in PRD3.5 to create the prpt-report which was displayed in html not on many page? Reports in PRD3.0 (xaction-reports) were displayed in a bi-server entirely without page navigation. For example report XY-charting is displayed entirely, and the report button-multi-parameter is on many page. The prpt-report by one page is necessary to me. I am sorry for my English. I hope, the question is clear.

The solutions for me was to get the right "jar" in the right place. 1) Go to http://sourceforge.net/projects/jtds/ and download the latest Open source JDBC driver 2) Extract jtds-1.2.4.jar to ~\biserver-ce-3.5.0.stable\biserver-ce\tomcat\common\lib. Probably should do that for ~\biserver-ce-3.5.0.stable\administration-console\jdbc too. 3 Restart the BI Server (and PAC). Should work now. Thanks, David

Hi to all.... friends I am using metadata connection. I want the multiple values of a field in my report. so what comparision value should I select in Query editor and what should I put in value.(suppose that name of parameter is "first")

Eureka! The problem was with the type I assigned to the parameter. In the database is defined as a bigint and I previously set it to Number or Integer (the right choice is Long). Unfortunately when previewing inside Report Designer it worked right, and no message error was given when accessing from the user console. Regards, f.

(1) Only the report header is corrupt. Other sections and headers are correct. We tried basic templates with no change to them and to the fonts properties. So it seems as the bug either in basic template or in the PDF exporting code (taken from Jaspersoft).

Hi, I have a chart as a "legacy" chart, i guess because it came over from 3.5 The rotated labels on the axis are completely wrong - upside down But i can't find where to edit this property? However as it's legacy, should I now re-do this chart in the new way? Presumably this will expose the new charting options such as control of axis min/max values, and format etc? Thanks! Dan

Many thanks to dankins for tracking this one down. The problem appears to be a bug in 3.5GA Report Designer (he confirmed that it is fixed in later version of the designer). I only had to publish my report to the server and it works. So to summarize: 1) use the content-field report element 2) Populate the attribute value with your column that contains URL 3) it will not work in designer (3.5GA), publish to your pentaho server and it works.