Total members 11894 |It is currently Sun Nov 24, 2024 4:28 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





Any body has experiance using BIRT report ?
I have one report parameter.
I just want to create if the user specify the report parameter, the sql will
execute sql with where clause (ex: select * from user where userid=?), but
if no report parameter specify, i want to execute the sql without where
clause. (Ex: select * from user)
Is this possible ?




Author:
Proficient
User avatar Posts: 280
Have thanks: 1 time

specify query in the Data Set's beforeOpen method, like


this.queryText = "SELECT * FROM " + params["myParam"]

_________________
Please recommend my post if you found it helpful


Author:
Proficient
User avatar Posts: 228
Have thanks: 0 time
Post new topic Reply to topic  [ 2 posts ] 










Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com