Jump to content
Changes to the Jaspersoft community edition download ×

Dynamic Query


2005 IR Help

Recommended Posts

By: Gopalakrishnan - gopkrish3

Dynamic Query

2005-02-14 00:42

Hi

Will jasper report support dynamic SQL query?

That is, Is it possible to construct the SQL Query itself dynamically at the run time

 

Thanks

T.Gopalakrishnan

 

 

 

 

By: C-Box - c-box

RE: Dynamic Query

2005-02-14 10:54

Just show a dialog that asks the user for the needed parameter (dates, numbers, strings etc) and build your SELECT Statement from that input and pass that query as a string within the parameter map as a parameter that you can use within the report for example as $!P{myQueryParam}

 

hth

C-Box

 

 

 

 

By: Gopalakrishnan - gopkrish3

RE: Dynamic Query

2005-02-14 19:26

Thanks C-Box

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...