Report Designer Databand FilterEngine SQL Query

[keris]

May you can pls. explain how to use databand filter when FilterEngine is set to 'SQL Query'.
I've found no references in the delivered manuals.
Thanx in advance
Peter

[Alex K.]

Hello,

In this case the filter for databand will be converted in SQL query as "Where" construction instead load all data and then applied the filter.

Thank you.

[keris]

Do you see any chance to set parameters of a stored procedure by a databand filter in the designer ?
Otherwise we would have to split our reports and filters which which will gererate additional effort for us.

On the other hand, if we use client side filtering (reporting engine instead of sql query) i was not able to define a 'match all' selection for a numeric value.

In the SP it is defined as follows:

-- some kind of select
where 1 = case
when @courseID = -1 then 1 -- all courses
when @courseID is null then -- not assigned
case
when i.itmId is null then 1
else 0
end
when @courseID = uls.itmId then 1 -- explicite id
else 0
end

Do you have any idea ?

Thanx
Peter

[Alex K.]

Hello,

As a way you can use the Request From User variables and use this variable as parameters value.

Thank you.