Filter conditions for adding a second station to a report

SMART Community Forum
1

I’ve currently got a report that contains a table of aggregations using data for a single station (parameter “Station”). It produces patrol summary information listed by employee name (header_0 in the table). The data for the selected “Station” is filtered in row header_1. I’d like to add a second station to the report (i.e., “Station1”).

  • I added the parameter “Station1” to the report. The dialogue box prompts for both stations as intended when do do a test run.
  • If I update the expression in the filter condition to “Station1” (in place of “Station”) I get the expected data from the new station.

Where I’m stumped is how to filter to get “header_0” to show data from both parameters “Station” and “Station1”. I’ve been assuming this is in the filter conditions but when I can’t sort out the expression I need. I’ve been trying various iterations of and (=) and or (|) expression which all seem to result in a blank table (i.e., no header_0 data; and I am updating query bindings each try).

Am I on the right track or way off?
I am also curious about the “Value 2” column in the filter dialogue box (second screen shot below) but can’t seem to be able to edit it?

Thanks for any insight. This is my first real dive into anything report-related.

image
image1366×768 87.7 KB

image
image783×359 13.1 KB

2

Hi @BeckyDawn

using two report parameter from same dataset coloumn will not work.

Try to use Allow multiple value from list box.

image
image644×775 23.3 KB

but I’m not sure because of SMART Data (as report data souces) is not configurable.

Regard
Lili Sadikin

3

Thanks, Lili.

The option to select multiple values doesn’t seem to work: there is still only the option to select one station.

I’m thinking now I may have to create a second row in the table that links to a new parameter, Station1. However, if I create Station1 as a new parameter and link it to the existing dataset I get a query error. I suspect this may come back to your comment on using two report parameters from the same dataset column.

I created a new dataset to use but the query wasn’t in the list of options. The result was the same when I duplicated the query and renamed it - it’s just not available for use in creating a new dataset.

Can I create a new column using the existing dataset that references Station through the new parameter (Station1) as another column? Would I still need another row in the table or could this be accommodated using the expression builder?

I feel like the options are endless :slight_smile: