Well, we're converting hundreds of reports to OBIEE. When the report must be pixel perfect, we build them using BI Pub. We avoid using BI Pub if possible, and try to do as much as we can in OBIEE, even if that means a strange work-around. This is due to the nature of the project, the large number of reports we need to…

I agree with you 100%. This is not the best use of OBIEE. Unfortunately, this is the constraint I'm given. Solve problem X given constraints Y. Again, based on the behavior described in the docs, page breaks should work a certain way. I can't get it to work they way the docs say it should work; I see different behavior.…

It just works precisely as designed. - This made my day. "How does a car engine work?" "It works as designed." I have given that: You can't expect the tool to behave as you think it should. It works as designed. If you don't like that then use BI Publisher. Too long, didn't read. Your problem in a nutshell is THIS ---^^ I…

Ana, thanks for the reply. Yes, you are misunderstanding this behavior, if the three columns are part of the section, then a change in one of the columns is a new section, 0-0-0 is different than 0-1-0, hence the new section. From what you are expecting I would say that you want the report ordered by these three columns…

I totally agree. And we keep fighting back that it is in fact an Analytics tool. But OBIEE has a certain built in functionality for page breaks, and based on the details I provided above, this functionality does not seem to behave as expected, even when following your suggestions with sort order, etc. It's okay if a…

Something totally different than what you stated earlier. You said "Column C" was your section separator. Not "all three". I said that I have a report with a section that includes columns "A", "B", "C", etc. I intended this to imply that it is sectioned off by columns "A", "B", "C", etc. I'll be sure to be more careful…

Thanks for the reply: (a) I'm working with 12.2.1.0.0 (b) Suppose my section includes columns "A", "B" and "C". The report will produce a new section for every unique set of values of these columns. Suppose I have the following set of values for (A, B, C): (0, 0, 0) (0, 1, 0) (0, 0, 1) (0, 0, 1) (0, 0, 2) Each one of these…

Thanks for the quick response. Page breaks can be inserted into HTML; you should see the break when attempting to print. But the HTML is a small detail that I mentioned it in case it was helpful. The real issue here is that page breaks are not working as I expected. Do you have any thoughts about the page break behavior?