Nilesh Patil's blog

http://forums.pentaho.com/showthread.php?26490-Getting-Help  Understanding that those of us at Pentaho are volunteering our time to help users get started with the platform, if you reach a point where reading the provided documentation and looking through the forums can't solve your problem, here's a quick best-practices way to get the most out of the forum. Start Here: http://community.pentaho.org/faq/forum_assistance.php Post information about your environment, operating system, whether you're using the Preconfigured Install (PCI), what application server you're running in, what jdbc driver you're using, what version of the platform you have, what version of the client tool you're running, etc. If you're using Tomcat for example, we need to know the exact version of Tomcat you're running. We also need to know the JDK version. Without all this information, we just have to turn around and ask you what you're running. This wastes...

ERROR [org.quartz.core.ErrorLogger] An error occured while scanning for the next trigger to fire.org.quartz.JobPersistenceException: Couldn’t acquire next trigger: Field ‘PRIORITY’ doesn’t have a default value [See nested exception: java.sql.SQLException: Field 'PRIORITY' doesn't have a default value] Solution :- Simply to set the DEFAULT of the column to 0 in following tables QRTZ_TRIGGERS                  COLUMN         PRIORITY          set default value 0 QRTZ_FIRED_TRIGGERS                  COLUMN         PRIORITY          set default value 0

In case you get this error Failed to obtain DB connection from data source ‘myDS’: java.sql.SQLException: Could not retrieve datasource via JNDI url ‘java:comp/env/jdbc/Quartz’ Solution :-  delete the following file toncat/conf/Catalina/localhost/pentaho.xml and try again.

Mysql supports a number of column types, which may be grouped into three categories: numeric types, date and time types, and string (character) types. This section first gives an overview of the types available. Please refer to the MySQL manuals for more details.  Type Use for Size TINYINT A very small integer The signed range is – 128 to 127. The unsigned range is 0 to 255. SMALLINT A small integer The signed range is – 32768 to 32767. The unsigned range is 0 to 65535 MEDIUMINT A medium-size integer The signed range is – 8388608 to 8388607. The unsigned range is 0 to 16777215 INT or INTEGER A normal-size integer The signed range is – 2147483648 to 2147483647. The unsigned range is 0 to 4294967295 BIGINT A large integer The signed range is – 9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615 FLOAT A smal...

http://www.on-reporting.com/blog/using-reporting-parameter-for-fun-and/

Execute different queries by selecting Parameter Here is the solution :- Create database “dynamicquery” and insert table which is in “dynamicQuery.sql” file which is in following link I also attached PRPT File in following link http://forums.pentaho.com/showthread.php?137913-how-to-change-query-in-PRD-3-6-by-parameter&p=333566&posted=1#post333566 Reference :- http://www.techievideos.com/videos/1156/How-to-create-dynamic-SQL-queries-in-Pentaho-Report-Designer/

The Pentaho Directory Structure: Directory hierarchy Below is an abridged Pentaho directory structure. The purpose of this diagram is to help you easily find some of Pentaho's important files and locations, which are explained below this diagram. /pentaho ../server ../../biserver-ee ../../../data ../../../licenses ../../../pentaho-solutions ../../../tomcat ../../data-integration-server ../../../data ../../../licenses ../../../pentaho-solutions ../../../tomcat ../../enterprise-console ../design-tools ../../aggregation-designer ../../data-integration ../../design-studio ../../metadata-editor ../../report-designer ../../schema-workbench ../common ../documentation ../java ../licenses ../postgresql ../scripts Top-level files These files are found in the top-level Pentaho directory: ctlscript: ( .sh or .bat ) Starts, stops, restarts, and shows the status of Pentaho services. installation-summary.txt: Contains th...