generating mulitples of same report

[khocker121]

The record count from the results of my query is 21. I use repeating frames and it results in a 3 page report. But I get 63 pages, 21 multiples of the same 3 page report.

 

[nagornyi]

Is it the same 3 pages repeated 21 times?
What is your group structure and repeating frames structure?
Also check the system parameter COPIES

 

[khocker121]

Yes, the same report is repeated. The Page numbering re-starts over for each mulitple, so each report it has Page 1 of 3, 2 of 3, etc.

The initial value of the system parameter COPIES is 1.

There is one group that includes all 130 columns from the query. The repeating frame structure: source is the group name, print direction is down, max records per page is 0, minimum widow column mode is no, filter: no, there are no page breaks or protection, vert elasticity is variable, horizontal elasticity is fixed, Print object on first page, base printing on anchoring object, keep with anchoring object is yes. No other properties are set.

Thanks for your help. We are new at Oracle Reports and seem to be mystified by this.

 

[BobEvansBicknell]

I just solved a very similar problem. What seemed to fix it made for one of those "that shouldn't have mattered" moments.

I had 3 frames. The first contained data being passed by parameters and selected in from the after parameter form program unit. It should appear once at the beginning of the report.

The second frame had headers and a repeating group that would be a shorter set of records, usually less than 20 and almost always less than 100.

The third frame had headers and a repeating group that would contain detail records sometimes into the hundreds.

My symptoms were that I would get a complete correct report duplicated over and over. With a little investigation, I noticed that the number of times my report repeated itself matched the number of records in my first repeating group. In other words, if I had 5 records in the second frame's repeating group, I got the report duplicated 5 times, one right after the other.

After several days of trying everything (including finding your post with unfortunately no answer attached to it), I stumbled across this solution:

The query for the repeating group was like this:

select col1,col2,col3,count(*) alias1 from
(select decode... col1, decode... col2,case...col3
from table where ...)
group by col1,col2,col3
order by col1,col2

I changed the sql to:
select col1,col2,col3,alias1 from (
select col1,col2,col3,count(*) alias1 from
(select decode... col1, decode... col2,case...col3
from table where ...)
group by col1,col2,col3
order by col1,col2)

So, all I really added was an outer select wrapping everything else I already had in paretheses.

I don't know why this fixed it, but it did. I hope this helps you.

 

[BobEvansBicknell]

I would welcome any comments to explain why this solution fixed my problem. I would like to resolve this in my head. I doesn't feel good to solve a problem without obtaining the accompanying understanding of the nature of the problem. I feel like I learned the truth without learning the whole truth.

 

[khocker121]

Thank you BobEvansBicknell!
I am passing this along to my programmers, I will see if it brings resolution for us as well.