Video Screencast Help

Location Based Report using Report Builder in Service Desk 7.1

Created: 17 Jul 2012 | 2 comments
snm1502's picture


Trying to create a Location based report using Report Engine / Default Report Builder in Service Desk 7.1. However, once I click on city under user, a window comes up with a drop down menu to select any one city.

Is there a way to select multiple options in there.

We would not prefer using SQL in this case, so looking for an option to select multiple cities through Report Engine.

Hopefully, query is well explained. However, please do let me know if any more info is needed on this.

Any help / guidance would be great.


Comments 2 CommentsJump to latest comment

reecardo's picture

You can do a SQL Report with a WHERE clause similar to: AND City IN ('citya', 'cityb', cityc')

snm1502's picture

Hi Reecardo,

Thanks for the reply. However, we would prefer not to use SQL in this case. Hence, looking out for an alternative / work around / a way to select multiple cities while creating reports using Report Builder.

Any help / guidance / reference would be great.