Eclipse Community Forums: BIRT » Using BIRT Parameter with LIKE

Help

Home

Home » Eclipse Projects » BIRT » Using BIRT Parameter with LIKE

Show: Today's Messages :: Show Polls :: Message Navigator

Using BIRT Parameter with LIKE [message #893568]

Wed, 04 July 2012 11:22

Missing name Missing name is currently offline

Missing name Missing name
Messages: 58
Registered: October 2011

Member

I want to have parameter COMPANY where it will show me records for some specific company if I select it or to show me records for all companies if I did not select any.
So I suppose I must create parameter which would not be required and something in query:

company like '%?%' or what is the correct expression I can not find it?

So I want to be able to show me records for all companies or for one specific company which will be selected from combo box (with dynamic values)

Thanks

Report message to a moderator

Re: Using BIRT Parameter with LIKE [message #893801 is a reply to message #893568]

Thu, 05 July 2012 10:18

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

You could create a scripted dataset with the value ALL, then create a
jointdataset with your company name dataset. This could be used to
prompt the user for the companies. Then modify the query that gets the
data to use this parameter in its beforeOpen. Have a look at the
attached example.

Jason

On 7/4/2012 11:22 AM, Missing name Mising name wrote:
> I want to have parameter COMPANY where it will show me records for some
> specific company if I select it or to show me records for all companies
> if I did not select any.
> So I suppose I must create parameter which would not be required and
> something in query:
>
> company like '%?%' or what is the correct expression I can not find it?
>
> So I want to be able to show me records for all companies or for one
> specific company which will be selected from combo box (with dynamic
> values)
>
> Thanks

Attachment: all.zip
(Size: 3.47KB, Downloaded 53 times)

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	Report Design Perspective missing from Open Perspective Window
Next Topic:	Load font by relative path instead of full path for birt 3.7.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 16:29:44 EDT 2013