1. Alexis Colon Lugo
  2. Valentina Reports ADK
  3. Четверг, Сентябрь 13 2018, 01:26 AM
  4.  Подписаться через email
what is the best practice to use parameter on XOJO when I reports have like 4 parameter and if i send one the other is cancel by the reporter engine (yes/no)

thanks
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Alexis,

You have 4 parameters.
Where do you use them? In query or expression? Please give an example.
Комментарий
There are no comments made yet.
Alexis Colon Lugo Ответ принят
in the query.
i need to run same reports but some time whis no parameter, what is best way to do it in a expression or in the query.

can you send me a example of the one is best way.

thanks
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
So you have some report with query, e.g.
SELECT * FROM t1 WHERE f1 > $P(pParam1)

And sometimes you need to show all records:
SELECT * FROM t1

If you don't want to write a query in code, you can add a parameter to show all records
SELECT * FROM t1 WHERE $P(pShowAll) OR f1 > $P(pParam1)

And if you set pShowAll = 1, you'll get all records.
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories