Search This Blog

Monday, December 13, 2010

Matrix Report in XML Publisher

This report is number of JVs created per month per source wise.

Query:
select je_source,to_char(date_created,'Mon-YY') Source_Month,count(je_header_id) je_count from gl_je_headerswhere to_char(date_created,'Q') = :p_quarter and to_char(date_created,'YYYY') = :p_year group
 by je_source,to_char(date_created,'Mon-YY')
RDF report:
    

Total Number of JVs Quarterly

Source Name
GSource_MonthE
Total
GJE_SOURCE
G If exists: JE_COUNT end; E
999E
Total
G If exists: 999 end; E


O              
G Close to JE_SOURCE - <?for-each-   group@section:G_SERVICE_NAME;./JE_SOURCE?><?sort:JE_SOURCE;'ascending';data-type='text'?>

 JE_SOURCE - <?JE_SOURCE?><?variable@incontext:JS;JE_SOURCE?>
       
 G close to Source_Month :
<?for-each-group@column:G_SERVICE_NAME;./SOURCE_MONTH?>
Source_Month - <?SOURCE_MONTH?>

E  - <?end for-each-group?>
G Near If Exists -  <?for-each-group@cell://G_SERVICE_NAME;./SOURCE_MONTH?
IF Exists –
<?if:count(current-group()[JE_SOURCE=$JS])?>

JE_COUNT - <?current-group()[JE_SOURCE=$JS]/JE_COUNT?> 
End; - <?end if?>

E  - <?end for-each-group?>
G in Total -  <?for-each-group@cell://G_SERVICE_NAME;./SOURCE_MONTH?

IF Exists in Total –
<?if:count(current-group())?>
999 in Total
<?sum(current-group()/JE_COUNT)?>
End if in Total:
<?end if?>
E in Total –
<?end for-each-group?>

999 in Total Column - <?sum(//G_SERVICE_NAME[JE_SOURCE=$JS]/JE_COUNT)?>
E in Total Column:
<?end for-each-group?>


      

     


7 comments:

  1. Hi all,

    Its a good post, Here I need some more info.. If we have Group above matrix This Post is not helpful. Please give some example for it. It is Helpful to every one...

    Thanks & Regards,
    karunakar.

    ReplyDelete
  2. It's an awesome post designed for all the web people; they will take advantage from it I am sure.

    Feel free to visit my homepage: crear facebook

    ReplyDelete
  3. I do not know if it's just me or if perhaps everyone else encountering problems with your site. It appears like some of the written text on your content are running off the screen. Can someone else please comment and let me know if this is happening to them too? This could be a problem with my browser because I've
    had this happen previously. Many thanks

    My site revitol review

    ReplyDelete
  4. Thanks for such a great website which is helping people who is new to oracle database and Applications.Your site is very impressive and you are doing an amazing job.For more details
    please visit our website..
    Oracle Cloud Fusion HCM Online Training

    ReplyDelete
  5. https://apps2fusion.com/at/64-kr/345-matrix-cross-tab-report-bi-publishe

    ReplyDelete