field cascading grouping in Report Queries - BI publisher

Gor_Mahia

Summary

field cascading grouping in Report Queries - BI publisher

Content

Hi,

 

Please note the below part#1 ive done now and works BUT my problem is part#2 for long running group records which i need to repeat the header on every page.

 

iam relative new to Oracle BI publisher but iam trying to create a report query + template layout with grouping as below.

 

PART#1: (DONE)

============================================================

1. query like:

=========

though not sure if this query will give me correct output...

select dept_name, emp_name, manager, country, location from Employees group by country.....

 

2. report printout should look like:

=========================

Country: USA

Dept: Sales

emp_name,   location Manager

--------------------------------------

................................................

......             .......           ........

 

Country: Canada

Dept: HR

emp_name,  location Manager

--------------------------------------

..............................................

......             .......           ........

 

 

3. here is my screenshot - note there are 2 cascaded grouping outer COUNTRY main grouping then within it DEPT child grouping as below

 

 

PART#2 (i need help on this pls)

============================================================================

IAM PLANNING TO repeat the header information on every page. if records for a manager group contains many (fullname, title, salary) onto the next page then the header details (department) together with column headers should show at the top of the next page

any suggestion is appreciated

 

...thanks.

YGUTTIKONDA

there are some good Oracle by Example sessions avaliable in the below URL .. this is a good place to start

http://www.oracle.com/technetwork/middleware/bi-publisher/learnmore/index.html

Hope this helps

--YG

Gor_Mahia

YGUTTIKONDA

these are so useful but i still need help with repeating groups/nested as i show above - please give me a suggestion i really need this....thanks

YGUTTIKONDA

when developing the layout either in Interactive Mode or RTF Template use Group Above first by Country and then by Department

Interactive Mode:

RTF Template

Below is how your template will look like ..

Hope this helps

Gor_Mahia

YGUTTIKONDA

i am getting very confusing error here now. After creating the inner table with groping on the left based on DEPT which works. Now when i try to add the outer/parent grouping based on country i get error that another NESTED GROUP already exist click ok to correct ..... whats this now? so groping cannot be nested here? 

very annoying.

any help please...thanks.

YGUTTIKONDA

if you click OK what is happening ??

YGUTTIKONDA

Hello .. Pl check the table properties and make sure the Repeat as header row at the top of each page is checked..

Also going forward please use one thread per issue. so it would help other people as well when they are searching for solutions..

Gor_Mahia

YGUTTIKONDA

thanks again for your great help - i resolved the above issue by creating new template table then picked 2 cascaded grouping fields and it worked.

Now ive another issue, i am trying to create same header details for those sections which are more than page size. for instance if SALES section is longer than a page size then show the header again on the next new page as below. Currently its show all continuous sections without header for the long sections.

DEPT: SALES

FIRST NAME	LAST NAME
HJJFGFGFGFG	GFGFGFGF
GFGFGF	JGHJGHJG
DFDFDFD	GHFGFDG
DFDFDFD	DFDFDF

. . . . . . . . . . . . . . . . . . . . . . . . . . ..

. . . . .. . . . . .  . . . . . . . . . . . . . . . . .

DEPT: SALES

FIRST NAME	LAST NAME
WERWERW	DGDSDFSD
SDFDFDFDRR	DFDFGDFGF
GFHGHH	GGGHJHHFGFDG
SFDVD	GHFGD

. . . . . . . . . . . . . . . . . . . . . . . . . . ..

. . . . .. . . . . .  . . . . . . . . . . . . . . . . .

DEPT: HR

FIRST NAME	LAST NAME
GFBGHJHMHJ	YYUJUJKU
HJHKJKJLJKL	JH
IKIKYHFG	TDFDFGSD
DFDFSDSD	WEWEW

. . . . . . . . . . . . . . . . . . . . . . . . . . ..

. . . . .. . . . . .  . . . . . . . . . . . . . . . . .

thanks

Venkat Thota - BIP

please upload xml and layout , will send you updated , thanks

YGUTTIKONDA

please upload the template and sample xml

Gor_Mahia

YGUTTIKONDA

   ive set the table properties to check that flag but as you can in the below pdf the HEADER section didn't show up. I wonder what else is now missing?

thanks again.