Jump to content
Changes to the Jaspersoft community edition download ×

Select Formula


2005 IR Help

Recommended Posts

By: roberto71 - roberto71

Select Formula

2004-11-24 23:30

It's possible to set a select formula at runtime ?

I can use parameter in where condition or order by.

 

i would like to set directly where condition and order by.

 

Is it possible ?

 

Thank You

 

 

 

 

By: Teodor Danciu - teodord

RE: Select Formula

2004-11-25 02:36

 

Hi,

 

Check the "query" sample provided.

 

Thank you,

Teodor

 

 

 

 

 

By: roberto71 - roberto71

RE: Select Formula

2004-11-25 03:34

Ty Teodor,

i have check the "query" sample.

But this use Parameter Field to customize the select.

I need to do it without using parameter fields.

 

 

 

 

 

 

By: roberto71 - roberto71

RE: Select Formula

2004-11-25 23:13

I have resolve my problem:

 

in the query string i have set:

 

SELECT * FROM MYTABLE $P!{MYPARAMFIELD}

 

at runtime i set the value of MYPARAMFIELD to:

 

where MYTABLE.MYFIELD is not null ORDER BY MYTABLE.MYFIELD

and so on..

 

now it works!

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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