Total members 10261 | Gratitudes |It is currently Wed May 23, 2012 7:43 am Login / Join Codemiles


All times are UTC [ DST ]




Post new topic Reply to topic  Quick reply  [ 2 posts ] 
Author Question
 Question subject: BIRT reporting
PostPosted: Thu Oct 23, 2008 12:36 am 
Offline
Proficient
User avatar

Joined: Sun Oct 19, 2008 3:47 pm
Posts: 281
Has thanked: 0 time
Have thanks: 1 time

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 ?


TOP
 Profile Send private message  
Reply with quote  
 Question subject: Re: BIRT reporting
PostPosted: Thu Oct 23, 2008 12:37 am 
Offline
Proficient
User avatar

Joined: Sun Oct 19, 2008 3:53 pm
Posts: 229
Has thanked: 0 time
Have thanks: 0 time
specify query in the Data Set's beforeOpen method, like


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


TOP
 Profile Send private message  
Reply with quote  
Post new topic Reply to topic Quick reply  [ 2 posts ] 
Quick reply


  

All times are UTC [ DST ]


Users browsing similar posts

Users browsing this forum: No registered users and 1 guest



Jump to:  
Previous Question | Next Question 




Home
General Talks
Finished Projects
Code Library
Games
Tutorials

Java
C/C++
C-sharp
php
Script
JSP/Servlets
Ajax
ASP/ASP.net
Google SEO
Database
Communications
Phpbb3 styles
Photoshop tutorials
Flash tutorials
Find a job






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team