Creating Selectable User Box in Zucker Reports

[BriteComputers]

I wrote a query that would select all the users in our system and display them in a custom drop down menu that I use in many custom Zucker Reports.

Instead of having a single drop down where I can only select one user at a time, is there a way to create a "box" of users so I can select multiple users by holding CTRL ?

[DragonflyMaster]

I wrote a query that would select all the users in our system and display them in a custom drop down menu that I use in many custom Zucker Reports.

Instead of having a single drop down where I can only select one user at a time, is there a way to create a "box" of users so I can select multiple users by holding CTRL ?

Try with a Multiselect field.

[BriteComputers]

Can I create a multi-select field and then bind it to Zucker?

[DragonflyMaster]

Can I create a multi-select field and then bind it to Zucker?

If you did that with a dropdown I guess you can do it with a multi-select as well.

[BriteComputers]

After I go into the "Report and Query Parameters" in Zucker reports I see the option to create the following types of parameters:

- Direct Input
- Date Input
- User Defined Query
- User Defined List
- Drop Down List
- Current User
- PHP Script


There is no option for Multi-Select menu.

[DragonflyMaster]

After I go into the "Report and Query Parameters" in Zucker reports I see the option to create the following types of parameters:

- Direct Input
- Date Input
- User Defined Query
- User Defined List
- Drop Down List
- Current User
- PHP Script


There is no option for Multi-Select menu.

In the first post of this thread you said you create a dropdown from a user defined query. Why don't you use that query?

[lukio]

In the first post of this thread you said you create a dropdown from a user defined query. Why don't you use that query?

I don't know if you could resolve this issue, but I recently have the same problem. What I did was to change some line at zucker report module.

At modules/ZuckerReportParameter/ParameterFill.html you have this lines:

<!-- BEGIN: SQL -->
<tr>
 <td width="15%" class="tabDetailViewDL">{PARAM_FRIENDLY_NAME}</td>
 <td width="85%" class="tabDetailViewDF" colspan="3"><select name="{PARAM_NAME}">{PARAM_SELECTION}</select></td>
</tr>
<!-- END: SQL -->

What i did was to add "multiple" at the select html tag. So what I have now is:

<!-- BEGIN: SQL -->
<tr>
 <td width="15%" class="tabDetailViewDL">{PARAM_FRIENDLY_NAME}</td>
 <td width="85%" class="tabDetailViewDF" colspan="3"><select name="{PARAM_NAME}" multiple>{PARAM_SELECTION}</select></td>
</tr>
<!-- END: SQL -->

That' s all.