►
From YouTube: Part 05 Use Parameters to Filter Data in a Report
Description
Click Here to Subscribe: http://xaf.life/35
Websites:
https://xafmarin.com/
https://www.xafers.training/
http://xafersweekly.com/
https://www.xari.io/
Free XAF Support Hour
https://calendly.com/xari/free-xaf-support-hour
Facebook Group
http://xaf.life/4g
A
A
Have
this
use
parameter
to
filter
the
data
in
the
report,
so
we're
gonna
use
this
just
mention
some
points,
but
we're
gonna
go
to
the
actions.
Okay,
let's
go
to
the
action.
You
remember
we.
We
were
working
in
this
report,
so
we
can
just
create
a
parameter.
Okay,
we're
going
to
begin
with
a
parameter
with
with
the
parameters
of
subcategory.
A
So
if
I
want
to
see
only
one
subcategory
in
the
report,
I
can
just
select
from
the
list.
Okay,
so
parameters
are
very
important
to
filter
data
and
the
end
user.
When
you
create
this
report
to
another
user,
this
user
can
filter
the
information
and
makes
customization
about
what
what
they
see.
Okay.
So,
let's
begin
with
the
parameter
to
add
a
parameter
you
can
add
from
here.
If
you
see
in
the
field
list,
you
have
this
a
item
that
say
parameters,
so
we
can
say
add
parameters.
A
Okay,
in
this
case,
you
have
to
put
the
type
the
type
of
the
value
so
here.
If
we,
if
you
you
can
we
can
make
a
two
kind
of
parameters.
One
is
fix
it,
something
that
I
want.
The
people
just
write
it.
The
value
that
I
want
to.
Oh,
if
I
want
the
people,
can
select
the
information
from
a
data
source
or
something
that
I
have.
A
A
The
is
the
name.
So
when
I
select
the
information,
I
gonna
take
this
value,
but
I'm
gonna
show
in
the
in
the
in
the
value
in
the
values
that
I
see
this
name.
You
can
filter
this
information.
You
can
say:
okay,
just
show
me
the
category
that
begin
with
a
or
show
me
category
that
have
any
conditions
you
know
in
this
case
we're
gonna
show
all
the
categories
sorting.
A
A
A
If
I
don't
put
this,
this
parameter
is
gonna
use
internally,
but
I'm
gonna
use
in
the
in
the
panel
that
I
can
select.
Okay,
so
let's
say
okay
and
then
let's
see
what
happened.
If
I
go
to
preview
here,
you
see
select
subcategory.
I
want
to
select
a
by
stand.
Okay
submit,
but
I
see
I
have
here
mountain
bikes
up.
Let
me
close
this
this
one.
I
have
here
mountain
bikes.
A
A
What
can
you
do
that?
Okay,
you
can
do
that
from
here.
Here
is
a
filtered
stream
in
the
red
box.
You
see.
If
I
go
to
this
button
I
have
here,
you
can
go
anywhere
if
you
select
the
report
in
some
place
that
if
you
can
have
here
too,
so
I
got
here
because
it's
easy
for
me.
Oh
I
got
here
to
this.
Oh,
the
filter
stream
is
like
this
okay,
I
want
to
add
a
condition.
A
A
Is
equal
to
subcategory?
This
is
the
the
parameter.
If
you
see
the
parameter
is
with
this
a
question
mark.
So
if
you,
if
you
see
this
question
mark
in
other
place,
you're
gonna
know
that
it's
a
parameter.
All
parameters
have
this
question
mark,
because
the
the
fields
are
a
we
break
in
brackets.
Sometimes
if
you
see
there
are
in
brackets
on
time,
but
parameters
are
in
these
a
this.
Is
a
quotation
mark?
Okay?
So,
let's
go.
Let
me
see
if
I
do
it
like,
we
have
to
do
select
subcategory.
A
A
Let
me
edit
the
parameter,
and
I
say
that
I
want
this
a
valid
member
to
no,
but
I
want
the
name.
The
name,
and
this
type
is
a
string.
It's
a
string
because
it
is,
it
is
a
name.
Okay.
Let's
do
it
again.
Let
me
select,
buy,
stand
and
sue
me.
Okay,
if
you
see
now
we
back
by
stand,
if
I
select
breaks,
I
just
have
breaks.
A
If
I
select
caps,
I
just
have
caps.
Let
me
select
something
that
have
more
globe.
If
you
see
there
are
six
of
them.
Okay,
now
we
have
interaction
that
the
people
can
select
the
information
when
they
get
here,
but
if
I
need
to
select
one
or
more
than
one,
I
have
a
problem
because
I
just
can
select
one
by
one
and
it's
maybe
it's
a
problem
for
me,
because
I
maybe
I
need
to
compare
to
category
or
to
something.
A
So
the
next
things
I
want
to
show
to
you
is
how
you
can
customize
this
parameter
to
select
more
than
one
okay.
We
can
edit
parameters
and
if
you
see
here,
we
have
here
multiple
values.
So
if
I
check
this
and
for
the
first
time,
if
you
want
all
the
values
have
to
be
selected,
you
can
check
this,
but
we're
gonna
leave
it
like
this.
Now,
because
I
want
to
test
the
the
the
two
versions:
okay,
let's
let's
go
with
this
and
then
we
can
test
the
other
one
okay.
A
A
A
Three
four
categories,
so
I
have
to
say,
is
any
of
is
any
of
this
of
this
list.
You
see
because
if
I
say
equal
you
know
is
I
I
cannot
say
say:
one
name
is
equal
to
three
names.
Oh,
oh,
oh
okay,
so
I
have
to
say,
is
any
of
the
list.
I
have
a
list
here
and
I
and
I
can
compare
okay,
let's
go
and
do
it
again.
A
A
Okay,
now
we
got
it,
we
got,
we
got
a
filter
from
here,
we
got,
we
can
select
more
than
one
is
ordered
by
name,
so
people
can
easily,
and
you
have
a
look
up
here
if
you
write,
if
you
see
I
write,
I
put
here
in
some
place
and
I,
if
I
say
l,
if
you
see
I
can
continue,
writing
g
okay,
so
you
can
search
inside
this
list
and
you
can
check
more
than
one
very
good.
Now
we
have
this
parameter
and
we
can
interact
with
the
repo.
A
Let
me
edit
the
parameter
again.
I
I
want
to.
I
want
to
check
with
use
this
one:
okay,
okay,
let's
go
to
this
here.
If
I
don't
select
this,
I
can
put
a
default
value.
So
if
you
want
this
select
subcategory,
no,
no!
I
want
all
mountain
bikes
all
the
time.
That's
selected,
you
can
do
it
here
or
you
can
do
by
expression.
You
can
say
okay.
I
want
this
this
that
okay,
but
we're
gonna
check
this
and
see
what
happens.
A
Okay,
preview.
If
you
see
every
everything
is
checked
by
default
and
you
just
select
and
select
what
you
want.
But
if
you
want
everything
comes
checked
for
the
first
time
you
just
have
to
select
over
there
and
see
what
happens.
Okay,
perfect!
Now
we
have.
We
have
these
parameters
and
we
can
just
filter
the
data
with
the
parameters.
A
Then
we
can.
We
can
add
another
parameters,
a
like
a
like
numbers:
let's
add
a
price
and
say
price
grade.
Third,
then,
okay,
and
now
this
one
is
going
to
be
a
number
number.
I
don't
know
floating
floating
point,
because
it's
decimal
point.
Okay
and
here
we're
gonna
have
no.
We
got
we're
not
gonna,
do
we're
gonna
do
from.
We
just
want
to
put
the
information
by
hand
okay
by
default.
Everything
is
gonna
be
in
the
list
because
it's
greater
than
zero.
Okay,
that's
right
and
then
a
we
say.
Okay,
you
remember.
A
This
parameter
is
selected
from
the
database,
but
this
one
this
one
I
have
to
select
by
my
own.
Okay,
I
have
to
select.
I
have
to
write
this
price
because
I
I
need
it.
Okay,
if
I
go
to
preview,
if
you
see
now,
I
have
the
selection,
but
I
have
this
price.
If
I
put
a
25
point
something
you
remember,
I
don't
have
any
any
any
filtering,
because
I
haven't
connect
this
parameter
to
the
database.
Okay,
so
I
go
here
and
I
go
to
the
filtering.
A
Remember
and
now
we're
gonna
have
we're
gonna,
add
a
new,
a
news,
a
okay!
Sorry,
sorry,
I
cancelled.
I
make
this
a
mistake
here,
so
I
don't
wanna
have
add
anything
in
this
line.
I'm
just
gonna
add
a
new
condition.
Okay
and
you
can
miss
any
condition,
is
a
nan.
If
you
see-
and
this
and
this,
if
you
have
a
noun,
if
you
need
that
or
you
just
have
to
change
with
clicking
over
the
okay
here,
we
have
a
this
a
a
price.
Let
me
see
what
is
the
price?
A
A
A
A
A
A
make
some
ordering
on
something
different,
but
let
me
see
if
I
can
do
and
then
another
way,
but
you
see
because
the
principal
information
from
the
report
is
the
subcategory-
that's
why
I
don't
have
this
information
for
just
to
make
a
a
to
to
make
this
filtering
here
so
that
that's
that's
why
this
is
no
a
like.
I
want
to
do
so.
Let
me
see
if
I
have
this
filtering
here.
A
A
So
in
this
case
this
this
is
not
the
you
know,
the
the
the
the
the
the
data
that
is
connected
to
the
report.
That's
that's
why
this
parameter
is
not
showing
like
this
okay,
so
a
what
we
can
do
next,
we
can
do
a
other
things
with
the
report
and
we
can
go
back
to
the
filter
to
make
this
works,
but
the
next
things
we're
gonna,
okay.
We
we
try
this
group
sorting
and
calculation.
We
do
we
did
it
yet.