Re: Q: reports 2.5 & data_parameters

Darrell Zawada wrote:
>
> i am currently having a problem passing a data_parameter to an
> oracle report (2.5) from an oracle form (1.2).
>
> i am receiving a rep-1304 error, indicating that the columns of
> the record group do not match the columns of the query in the
> report.
>
> the query in the report is a single table select, with only one
> group. i have narrowed it down to a couple of factors that
> cause the error. when i include a formula column in the group
> the error occurs. or when the query creates new column names as
> a result of joining the table to itself. in both cases the record
> group columns created in the form match exactly to the group in
> the report query, column name and type.
>
> it seems that when the column in the report query group does not
> have a name from the database, the data_parameter fails.
>
> does anybody know if oracle reports can handle data_parameters
> under these conditions? if it cannot it would be nice to know,
> my forehead is getting very sore from all the banging against my
> desk. if it can, any pointers on what i might be doing wrong?
>
> thx in advance,
> Darrell Zawada (76714.1212_at_compuserve.com)
>
> --
> z

Make sure that each aliased column (whether DB source or formula column) is corresponds with respect to Name, Datatype and Size. Always alias any column in your SQL. It's a good programming habit and it makes integration work a lot easier.

-- 
Per Brondum						
Developer/2000