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

Reference :-

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:\...