Re: Passing Where from Forms to Reports
Date: Mon, 15 Jun 1998 07:08:15 GMT
Message-ID: <6m2h8t$gb8$1_at_nnrp1.dejanews.com>
Roland,
Try replacing the table aliases in your report module with the full table names. This solved most problems for me. An other hint: when using control breaks in your report, don't forget to filter out the 'ORDER BY' part from the where-clause in your form. Otherwise you'll end up with multiple order-by clauses in your query, which will make the report refuse to run.
Kind Regards,
Theo
In article <3583b4f5.11760460_at_nntpserver.swip.net>,
roland.svensson_at_mbox200.swipnet.se (Roland Svensson) wrote:
>
> Hello,
> we are using Des2K to generate Forms (4.5) and Reports (2.5)
> applications. For many Forms screens there is a Reports 'hardcopy'.
> To do this we pass the where-clause from forms to reports. This
> works for simlpe, single table queries but when reports start joning
> tables is also intoduces table alias unknown to forms.
> Has anyone solved this or have any ideas?
> --
> Thanks
> Roland S.
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 15 1998 - 09:08:15 CEST