Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Using BIRT Parameter with LIKE
Using BIRT Parameter with LIKE [message #893568] Wed, 04 July 2012 15:22 Go to next message
Dejan Vujanic is currently offline Dejan Vujanic
Messages: 66
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
Re: Using BIRT Parameter with LIKE [message #893801 is a reply to message #893568] Thu, 05 July 2012 14:18 Go to previous message
Jason Weathersby is currently offline 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 70 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:
  


Current Time: Sun Oct 26 07:56:04 GMT 2014

Powered by FUDForum. Page generated in 0.01598 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software