separate Checkbox for each value

[#1]

I have field YEAR,

  I want to create a separate check box for each value in the YEAR.

  Example 2014, 2013, 2012

I tried the following

     I created a list box and override the style to check box, removed the caption and the field was expression  which gives me one value

    = if (YEAR=2014,2014)    this example suppose that I already know all values.

     I crated anther one for 2013

      now I have 2 check boxes

     the problem if I select 2014, then select 2013 the first selection 2014 unselected automatically.

I can't make both selection for 2013 and 2014.

Any idea for better approch for my needs

[jagan]

Hi,

Why you are trying to create separate list box for each value in the YEAR field, you can create one list box with all the years and then change style to Check Box. 

Regards,

jagan.

[#3]

for design purpose,

[its_anandrjs]

You can use list box of year as the LED Check boxes

Go to list properties >> Image Options >> Selection Style Override >> and select LED or LED Check boxes.

[#5]

I don't want a list of check box, I want each checkbook separate

[#6 · Accepted solution]

Will this design do for you?

Above can be achieved by unchecking Single Column check in Presentation tab of list box.

Making as separate list boxes will complicate the logic.

Let me know ur comments.

Thanks,

Prabhu

[SunilChauhan]

use comperative analysis available in qv 11

there you can mange to create seperate group and they not effect each other and you can select both at a time

hope this helps

[#8]

Thanx,

After applying the solution I got an error.

      In the list I chosed expression to add the follwoing

      =Year & '(' & count(DBID) & ')'

but this is not working

What I want is as to show each year and the count of records for each year beside

somthing like 2014(1000)    2013(500)