Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

Is there a good way to handle checkboxes (select multiple) in reporting?

Is there a good way to handle checkboxes (select multiple) in reporting?

We want to put some select-multiple fields in our form, but once this data gets to the data mart, the values are all strung together in one field, with just an intervening blank.  Is there any wisdom on how to use this kind of field in reports? 
Everyone's tags (1)
3 REPLIES

Is there a good way to handle checkboxes (select multiple) in re

I would address this at the service design level. Make the values separate fields in the dictionary with a radio button selecting yes or no.  Do this instead of a multi select filed. This way you have the ability to report on these values as they are separate fields.   

New Member

Is there a good way to handle checkboxes (select multiple) in re

Hi Susie,

I believe the separation between the data in the string is a "tab" delimiter for multi-select fields in the database.  Therefore, in your report you could use a regular expression to separate the values into an array and loop through them to determine which options were used for that particular field.

New Member

Is there a good way to handle checkboxes (select multiple) in re

As David suggests, this needs to be addressed at the service design level. Multi-select fields are problematic both for reporting and for ServiceLink. However, the display, especially in a horizontally oriented checklist, provides a very nice UI. If you want to keep the UI, you can essentially duplicate the checkboxes as a set of separate fields (as above), but keep these hidden in the service design and populate them via ISF. You could then easily use these fields for reporting purposes.

332
Views
0
Helpful
3
Replies
CreatePlease login to create content