Re: Reports and Lexical References

>I want to create a report that creates the column, table and where
>clause in a before Report trigger based on parameters passed in at
>runtime. The help system shows an example with a query like:
>
>select &column from &table
>
>When I try this it refuses to accept the query complaining about the
>tabe not existing. What am I doing wrong? Do you need to add column
>and table aliases? The example in the help doesn't have them.

The lexicals are defined as parameters; give them a default value that points to table/columns that exist while you are designing the report.

Dan Hekimian-Williams Received on Thu Feb 03 2000 - 01:28:12 CET