REP-1317 and REP-1213 1

[navrsalemile]

Hi all,

I tried to add a field to existing report. I got error REP-1213 "Field F_1 references column HISTORY at a frequency below its group."
When I tried to add bolierplate text I got error REP-1317 "
Boilerplate B_4 references field with source HISTORY at wrong frequency".

Help gives following explanation, but I do not know how to "move the field into a repeating frame", or "move field's source column into the enclosing repeating frame's group":

"Move the field into a repeating frame whose source group is at or above the group that contains the field's source column. Otherwise, move the field's source column into the enclosing repeating frame's group, if possible."

I use Reports 9i

 

[nagornyi]

Click on the Field in the Report Layout
Copy it Ctrl-C
Delete it Del
Select the frame whre the field shold go
Copy the field into that frame Ctrl-V

 

[navrsalemile]

When you say "Report Layout" do you mean

1) Paper Layout folder in Object Navigator
or
2) Report Editor - Paper Design
or
3) Report Editor - Paper Layout?

How do I know which frame database column (from ref cursor query) belongs to? How do I select the frame? Do I need to create a new frame for database column and how?

thanks,
mile

 

[navrsalemile]

I did as you said (in Paper layout) but still the same error.
The report has 3 queries, 2 old ones and third is new one which I added which returns one string value. One of old queries is referenced from a field which is inside a repeating frame R_1.
So I ctrl-c my new field, deleted it, and then I right clicked on an old field which references database column from old query and selected 'Select Parent Frame'.
Then I ctrl-V my new field, but got same error.
In Object Navigator it is still under R_1 repeating frame, just like the other field?!

 

[nagornyi]

You can insert the field brought by your query only to the group made by the query. If your query is just for one value which you need to place to an alien frame, create some global summary field that sits outside any groups. That field would, for example, find the max of your field, So if your query returns just one value, the summary would just repeat it. Then you can put that global summary field to any frame in the layout.

 

[navrsalemile]

I created a field outside repeating frame, but still got the same error (I created it under Body folder, i.e. outside of other frames). Wherever I put this new field on the layout I get this error.
Did you mean summary column and not field? If I create summary column I cannot source from my new query (it is not shown in drop-down list)!?
This new field must be visible and shown just beneath the two fields referencing the old query. Does it mean I have to put is under the same frame (which is repeating frame R_1)?
My report layout looks like this:

Logo Title

__________________________________________________________
Institution: number-from-old-query string-from-old-query


tabular-data ... ... ... ... ... ... ... ... ...
... .. ... ... ... ... ... ... ... ... ... ...

I have to create a new bolerplate text B_2 (History) under Institution boilerplate text:

Logo Title

__________________________________________________________
Institution: number-from-old-query string-from-old-query
History: string-from-my-new-query


tabular-data ... ... ... ... ... ... ... ... ...
... .. ... ... ... ... ... ... ... ... ... ...


Everything from Institution to the end of report is under repeating frame R_1. "Institution" bolierplate text, number-from-old-query field and string-from-old-query are directly under R_1 repeating frame. "tabular-data" are inside a frame which is also located under R_1 repeating frame, and which also contains two other repeating frames. Where exactly should I put "History:" boilerplate text which references new field "string-from-my-new-query"?

thanks,
mile

 

[nagornyi]

Field or Column, call it whatever, what is real important is that you need to create it outside any GROUP, not FRAME. This means you create it in the DATA MODEL, not LAYOUT MODEL.
Go to the menu View-->Data Model.
Go to the menu View-->Toolbar (to be checked)
Click on the Summary Column tool (you will recognize it by tooltip)
Click anywehere in the layout outside any group
Click F4
Select Max for Function
Select your query field as Source.
Now you can go to the Layout Editor, place the field object anywhere you need, and source it with newly created summaty column (the name is CS_1, if you didn't change it)