How to create dynamic SQL queries in Pentaho Report Designer


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/

Comments

Popular posts from this blog

Changing the Java VM Memory Limits in Pentaho BI

error in pentaho 5.0.1 - authentication via url parameters for iframe

CAS with Pentaho Community Edition