OraFAQ Forum: Reports & Discoverer » rep-1213 & rep-1517

Home » Developer & Programmer » Reports & Discoverer » rep-1213 & rep-1517 (Oracle Reports Developer 10.1.2.0.2, Unix, 10 G database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: rep-1213 & rep-1517 [message #517951 is a reply to message #517926]

Fri, 29 July 2011 14:41

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: rep-1213 & rep-1517 [message #517954 is a reply to message #517951]

Fri, 29 July 2011 16:48

TX_developer
Messages: 46
Registered: July 2011

Member

Thank you.

Report message to a moderator

Previous Topic:	error in report builder
Next Topic:	Appending data fields to text

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 04 20:42:55 CDT 2025