Friday, February 22, 2013

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/

No comments:

Post a Comment

Create MongoDB service in Windows OS

1) Open Command Prompt 2) Create directory for Database and Logs                    mkdir c:\data\db                     mkdir c:\...