Eclipse Community Forums: BIRT » Using BIRT Parameter with LIKE

Home » Archived » BIRT » Using BIRT Parameter with LIKE

Using BIRT Parameter with LIKE [message #893568]

Wed, 04 July 2012 11:22

Eclipse User

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

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

Thu, 05 July 2012 10:18

Eclipse User

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 230 times)

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 [=-

Current Time: Fri Jul 25 05:21:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter