Reports with query parameters

[Ruslan Zasukhin]

On 3/10/13 9:16 PM, "Arndt Weinmann" <arndt.weinmann at gmail.com> wrote:

> Hello!
> 
> Is it possible to create a query with parameters and have different (main)
> reports that call the query with different parameter settings?

hi Arndt

We have come with this idea:

* you can use SQL variables, such as  @var

* and you can assign that variable BEFORE report will be generated using
property of report   'pre_build' script

You can see it here:

<http://www.valentina-db.com/docs/dokuwiki/v5/doku.php?id=valentina:products
:vstudio:help:report_editor:properties_inspector:report>

Just pur in one report into this property simple SQL command that assign var
to value you need

report1

      pre_build            @var = 'FINISHED';


report2

      pre_build            @var = 'TODO';


And query itself as
     q = "SELECT * FROM T WHERE f1 = @var";







-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]