combobox filtering

jmmv · Post by **jmmv** » Mon Feb 13, 2012 5:04 am

I have a combobox that is binded with this field: Req.code
Now I would like to filter the items that are shown in it by the beginning of the characters of this field, like "FIX" and then a wildcard for all the numbers of FIX (FIX0001, FIX0002, ...)
How can I achieve this with the designer?

many thanks

Post by **HighAley** » Tue Feb 14, 2012 2:06 am

Hello.

jmmv wrote:I have a combobox that is binded with this field: Req.code
Now I would like to filter the items that are shown in it by the beginning of the characters of this field, like "FIX" and then a wildcard for all the numbers of FIX (FIX0001, FIX0002, ...)
How can I achieve this with the designer?

Please, try to use next expression in the filter:

Code: Select all

Req.code.Substring(0, 3) == "FIX"

Thank you.

jmmv · Post by **jmmv** » Tue Feb 14, 2012 3:21 am

Aleksey wrote:Hello.
Please, try to use next expression in the filter:
Code: Select all
Req.code.Substring(0, 3) == "FIX"
Thank you.

Thanks for your support. Unfortunately with this expression nothing is shown...

img
Is this the right place to put the expression? I could not find any other field that could be right.

Post by **HighAley** » Wed Feb 15, 2012 10:09 am

Hello.

We need more time to prepare an answer for you.

Thank you.

Post by **Alex K.** » Thu Feb 16, 2012 3:22 am

Hello,

You can create additional datasource (as Data from other datasource) which will contains only records with substring "FIX" and use it additional data source in Combobox.

Thank you.

Post by **HighAley** » Thu Feb 16, 2012 3:25 am

Hello.

Please, look at the attached report template.

Thank you.

jmmv · Post by **jmmv** » Thu Feb 16, 2012 3:43 am

Aleksey wrote:Hello,

You can create additional datasource (as Data from other datasource) which will contains only records with substring "FIX" and use it additional data source in Combobox.

Thank you.

great, worked perfectly.
Thank you very much for the support. Thanks also for the example report, made it easier to understand.

jmmv · Post by **jmmv** » Thu Feb 16, 2012 6:06 am

Aleksey wrote:Hello,

You can create additional datasource (as Data from other datasource) which will contains only records with substring "FIX" and use it additional data source in Combobox.

Thank you.

How can I make this new datasouce (data from other datasource) persist?
Every time I close the designer it disappears and I have to recreate it.

Post by **HighAley** » Fri Feb 17, 2012 3:38 am

Hello.

jmmv wrote:How can I make this new datasouce (data from other datasource) persist?
Every time I close the designer it disappears and I have to recreate it.

The Data Source from other Data Source should stay. Did you save this report?

Thank you.

jmmv · Post by **jmmv** » Fri Feb 17, 2012 4:58 am

Aleksey wrote:Hello.
jmmv wrote:How can I make this new datasouce (data from other datasource) persist?
Every time I close the designer it disappears and I have to recreate it.
The Data Source from other Data Source should stay. Did you save this report?

Thank you.

Yes I saved it...
I just added the datasource again and made also some changes to the report and saved it again. After closing and reopening the Designer only the new datasource is no longer there.