QuickReport from several Databases

You will need a lot more, the documentation for quickrep is somehwere in the
Program Files\ Delph3 area. Also the demo programs are in the demo directory.
These files are not yet available for the D4 version, i believe.
Quote
Arioch /BDV/ wrote:
> D4
> 1)
> Have to do QuickReport from several databases
> As documented - I cannot use my app's Database components as alias in
> request(shown below)
> hence it asks for a password for every database in req.
> How can i avoid that?

> 2) to print do i need only
> Form.Create, Query.Open, QuickRep.Print - or smth more ?

> Request for QuickRep's TQuery:
>  ( UserNames & password are known to my app, but how to pass them?)

> SELECT Solditems.ITEMID, Goods.PRODUCT, Goods.PRICE, Goods.BALLS,
> Solditems.AMOUNT, Solditems.J_DATE, Solditems.J_NUMBER,Journal.DISTRIBID as
> ID
> FROM ":CervusJournal:JOURNAL" Journal
>    INNER JOIN ":CervusJournal:SOLDITEMS" Solditems
>    ON  (Journal.J_NUMBER = Solditems.J_NUMBER)
>    AND  (Journal.J_DATE = Solditems.J_DATE)
>    INNER JOIN ":CervusSklad:GOODS" Goods
>    ON  (Solditems.ITEMID = Goods.ID)
> WHERE
>  Journal.J_DATE = :DATE
> AND
>  Journal.J_Number = :NUMBER
> ORDER BY Solditems.ITEMID, Goods.PRODUCT

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~
> ...Should we shout ? Should we Scream ?
>    What happenned to the post-War dream ?
>  ...With all the best wishes - Arioch /BDV/  mailto:the_Ari...@chat.ru