Re: How to pass a query to a report at runtime

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 6 Aug 2003 08:11:25 -0700
Message-ID: <336da121.0308060711.2442736a_at_posting.google.com>


Manikandan <member12054_at_dbforums.com> wrote in message news:<3201456.1060063922_at_dbforums.com>...
> Hi,
> I need to pass a query as a parameter to the report.My report should
> contain the query output.
> The report columns are same.But the rows will be varying according to my
> input query.
> Can anybody please tell me how to acheive this?

Read about lexical parameter references. You can put a lexical reference to parameter in (almost) any place of your query. Look in Report Builder Reference -> SQL usage -> lexical references. In your case, you need to replace some parts of WHERE clause with lexical reference. Received on Wed Aug 06 2003 - 17:11:25 CEST

Original text of this message