Reports with query parameters

[Arndt Weinmann]

I have different reports. I would like to use single query for all reports.
This would be feasible, if I could set the parameters from within the
report.

e.g.
select * from trials where status=$P(trial_status)

I would like to set trial_status to like RECRUITING or FINISHED to create
the reports.




2013/3/10 Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>

> On 3/10/13 9:16 PM, "Arndt Weinmann" <arndt.weinmann at gmail.com> wrote:
>
> Hi Arndt,
>
> > Hello!
> >
> > Is it possible to create a query with parameters and have different
> (main)
> > reports that call the query with different parameter settings?
>
> I think you need provide some example of your dream.
>
> Query with Parameters?
>   you mean    f1 = :1 and f2 =:2
>
>
> Main reports?
>
>
> May be better describe task you want to solve?
>
>
>
>
> --
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130310/bb37faf7/attachment.html>