Why not use a standard report with a custom layout? Fac586 has talked about this MANY times here in the forum, you can do a search and see if it meets your requirements..
Los Alamos, NM
Can you please elaborate what you mean by custom layout as i think there IR and Pivot option in Action Menu but there i can't use grouping and subtotals. can you please share a little example or mock up
Update your forum profile with a recognisable username instead of "2776393".
When you ask a question, always include the information detailed in these guidelines so we can provide version-, environment-, and application-specific advice.
I have below Sample data from database to show as pivot with subtotal on each groupBalance TypeService TypeDvisionOUBalance
Past Due Service 1 Division 1 Ou 1 10 Past Due Service 1 Division 1 Ou 2 20 Past Due Service 2 Division 1 Ou 1 30 Past Due Service 2 Division 2 Ou 2 40 Current Service 1 Division 1 Ou 1 50 Current Service 2 Division 1 Ou 2 60 Current Service 2 Division 2 Ou 1 70 Current Service 2 Division 2 Ou 2 70
Sample data should be posted in the form of DDL/DML statements or CTE selects: How do I ask a question on the forums?
Are we to assume from the use of "dynamic" in the subject line that the number of services, divisions, and OUs is variable? Are these defined in reference data tables or as dimensions in a data warehouse? If so, please post the relevant table definitions.
Expected Output in PLSQL Dynamic Content
Service 1 Service 1 Total Service 2 Service 2 Total Grand Total Division 1 Division 1 Total Division 1 Division 1 Total Division 2 Division 2 Total Balance Type Ou1 Ou2 Ou1 Ou2 Ou1 Ou2 Current 50 50 50 60 60 70 70 140 200 250 Past Due 10 20 30 30 30 30 40 40 70 100 Grand Total 60 20 80 80 30 60 90 70 110 180 270 350
Why the obsession with wholly unnecessary PL/SQL Dynamic Content regions? APEX development is much more effective without them.
no you don't.
First off, that code will be hard to maintain.
Second - you would be doing nothing more than "reinventing the wheel". -- specifically - a Region Plugin
Because of the dynamic requirement, you do not want to do the pivot within the database.
Mike Kutz so can you provide the Solution actually
no. My answer comes from my experience of working with various forms of HTML based applications ( PERL::CGI, JSP, APEX, etc.)
If I did provide a solution, I would post it on http://apex.world for the everyone else also.
If this is "work related", tell your boss you need someone with the required JS/CSS skill set.
We can help turn that into a Plug-In.
If this is "for fun", find some friends with the require JS/CSS skill set.
@Mike Kutz Really Appreciate your answer and Work Experience You have , i think this Layout is Globally required by most of Apex developers as Apex itself has some limited pivot capability. So if you provide a Mock-up on http://apex.world/ as Pseudo Code or Real time JS/CSS code so every one get any Idea or solution to Come up with the solution. However this plugin is already developed here http://www.apexsmartpivot.com/ but its paid and costly to afford myself. Thanks Adeel
The multi-level headers rather complicate things, but this can be resolved by generating the headers as report rows.
The example demonstrates the ability to dynamically handle a variable number of data points and grouping levels. This is restricted by the 4000 byte limit imposed by using
listaggin the construction of the header rows. That could be overcome by using
xmlagginstead, but it's pretty close to the practical layout and usability limits of the report format anyway.
@fac586 Thanks for Update as i have seen the both links https://apex.oracle.com/pls/apex/f?p=APEX_50_EXAMPLES:DYN_PIVOT_MULTI_HDR:0::::: this looks as per my requirements. Can you please share the source page of this application so i can see this as it looks like fulfilling my desired design
Can you update your profile with a recognisable username instead of "2776393".
ok I am going to Update as I am finding where to change the Name .. but Please share the application as i really stuck from last month in this pivot as really this is very urgent form
I have changed the display name in edit profile but its still not Updating in the Community i dont know why its not updating
Ok its Update now you can see my Actual Name Thanks