| rep-1213 & rep-1517 [message #517926] |
Fri, 29 July 2011 08:57  |
 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
