Home » Developer & Programmer » Reports & Discoverer » rep-1213 & rep-1517 (Oracle Reports Developer 10.1.2.0.2, Unix, 10 G database)
rep-1213 & rep-1517 [message #517926] Fri, 29 July 2011 08:57 Go to next message
TX_developer
Messages: 46
Registered: July 2011
Member
Hi,

I have an existing report. The user now wants the country description printed at the end of the report. I look up this description via the country code which is part of Query 1.

I placed a formula column in the data model and attached PL/SQL code to it retrieving the country description referencing the country code from query 1. I then placed a field on the report and referenced the forumula column. When I run the report I get an REP-1517. Column '<column1 name>' references column '<column2 name>', which has incompatible frequency.

I tried placing a formula column inside query1, retrieving the country description via PL/SQLl code, but when I reference that formula column in my field I get an REP-1213. Field '<field name>' references column '<column name>' at a frequency below its group.

What is the correct way to go about this? The user inputs a customer's ID.

Any help is greatly appreciated.

Thanks,
tx_developer
Re: rep-1213 & rep-1517 [message #517951 is a reply to message #517926] Fri, 29 July 2011 14:41 Go to previous messageGo to next message
Littlefoot
Messages: 21564
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"End of the report" doesn't have to belong to a frame that is based on the Q1 query. So, create a report-level formula column that would retrieve country description by itself - the only reference it takes should be customer's ID.
Re: rep-1213 & rep-1517 [message #517954 is a reply to message #517951] Fri, 29 July 2011 16:48 Go to previous message
TX_developer
Messages: 46
Registered: July 2011
Member
Thank you.
Previous Topic: error in report builder
Next Topic: Appending data fields to text
Goto Forum:
  


Current Time: Thu Jun 04 23:14:57 CDT 2020