0 - 5 of 5 tags for filter

I have a parameter in a report (Report Builder 3.0) called REPORT_FILTER.  This parameter has 4 available values.  The labels are (1) Home Group, (2) Home Branch, (3) Other Group, and (4) Other Branch.  The corresponding values are 1, 2, 3, and 4.

Is there any way to restrict ANSI sessions using viewpoint/TASM ?
I don't want to allow ANSI sessions into system. How can I achieve this via viewpoint or TASM or any other method ?
Kindly provide your suggestions.

I have an issue while trying to get only the record containing max(c.event_dtm) from the following query:
SEL     a.startclock_day,

Hi All,

TDWM used to have a bypass list that excluded a particular user from all the rules (filters, throttles etc.) even if there was a need to exclude a user from one of the rules and not all. It was a sort of global bypass list.

I'm adding up totals within a database and would like to see how the totals change over different time periods.

I'm using this code:


Select Sum(CASE WHEN Offer_1 = 'Y' THEN 1 ELSE 0 END) as Offer1,

Sum(CASE WHEN Offer_2 = 'Y' THEN 1 ELSE 0 END) as Offer2,