Dear support

I have report with 2 pages. The second page I want to see only when condition (picture) is true.
But page is always invisible. When I use simply conditions like 2>1 it works.

What is wrong?




Thank you

great! it works thank you

Dear support

I there any possibility how to use function Round in report designer for rounding away from zero?
Now: Round(9002.5) = 9002
I want: Round(9002.5) = 9003

Thank you

Dear support

I use list variable in my report for filtering report data. But when I want to run report, all items in list are checked. I need to have all items unchecked because nobody use all data and its very slowly. Is it possible?

Lech Kulikowski wrote: ↑Mon Mar 07, 2022 10:14 pm Hello,

You can use the following query:
select * from Products where CategoryID in {(var1.Count == 0 ? "('')" : "(" + var1.ToQueryString("'") + ")")}

Thank you.

Thank you, it works!

Dear support I have created report with sql postgre datasource and I need to create any userfriendly filter for users. I am able to create filter with textbox ( picture 1) - I created new variable pnps_id and then I put it into select: where my_data_id = @pnps_id. It works OK but I want to create fi...