Results 1 to 6 of 6

Thread: Tabular Report

  1. #1
    Member KSK's Avatar
    Join Date
    Sep 2007
    Location
    India
    Posts
    136

    Tabular Report

    Hi, I tried to display all employees salary (SAL ) in a Tabular report , for that I attached V060116(Employee master Table BSV ) to the detail section but in the output I’m able to see the summation of all salary(SAL) in a single line ..Maybe that is the dynamic property for tabular section ….please give any alternative for displaying all salary (SAL) in a single report with Tabular section .Thanks


    Release =8.11

    SivaKumar.Kommoju
    E910,9.1.4.2

  2. #2
    Senior Member Adrian_Chimirel's Avatar
    Join Date
    Nov 2000
    Location
    Toronto, Canada
    Posts
    2,163

    Re: Tabular Report

    If you don't NEED to use a tabular section, I suggest you do NOT use it. You may use a Group, or a Columnar section.
    PS The Tabular section is (mostly) used for consolidating / summarizing financial accounts amounts.
    Adrian,
    E1 9.1 TR 9.2.2.4 03-26-2018_03 MSQL 2016 x64, WebLogic 12c, all on WIntel 2016 x64
    3rd Party Software: All Out Security 3.2, TransForm 7.1, SAP Business Objects Enterprise XI 12
    In the Microsoft Azure Cloud!

  3. #3
    Member Gov's Avatar
    Join Date
    May 2006
    Location
    Pittsburgh, PA
    Posts
    614

    Re: Tabular Report

    Hi Siva,

    If I understood you correctly, you want to display each employee with their salary on the report. If that is the case, then add the Employee number in the Section Sequence and run the report.I guess this will do the trick.

    Please update us with results
    Regards,Gov

    Sr. E1 Technical Consultant | Release : E900 |Tools : 8.98.4.2 , 9.2.0.3| DB2

  4. #4
    Member KSK's Avatar
    Join Date
    Sep 2007
    Location
    India
    Posts
    136

    Re: Tabular Report

    HI, I'have added Employee ID in the data sequence . But still getting the same output .
    SivaKumar.Kommoju
    E910,9.1.4.2

  5. #5
    Member
    Join Date
    Apr 2003
    Location
    Ohio, USA
    Posts
    405

    RE: Tabular Report

    I think that when you are on the Data Sequencing in RDA for a tabular
    report, you need to have a field set as a level break in order for the
    tabular section to summarize at that level. Otherwise, it gets rolled up
    in the detail for another level break.



    Ellen Deak

    Senior Systems Developer

    Cooper Standard Automotive

    JDE EnterpriseOne (OneWorld XE Update 7 SP23_M1), AS400 DB2 V5R3M0,
    Citrix Clients



    Ellen Deak
    Sr. Software Developer
    Dealer Tire
    EnterpriseOne (E920), Tools 9.2.2.4, IBM DB2 V7.2, Create!form 8

  6. #6

    Sorting and level break required

    Quote Originally Posted by eydeak View Post
    I think that when you are on the Data Sequencing in RDA for a tabular
    report, you need to have a field set as a level break in order for the
    tabular section to summarize at that level. Otherwise, it gets rolled up
    in the detail for another level break.



    Ellen Deak

    Senior Systems Developer

    Cooper Standard Automotive

    JDE EnterpriseOne (OneWorld XE Update 7 SP23_M1), AS400 DB2 V5R3M0,
    Citrix Clients

    Hi KSK,

    you need to put sorting on AN8 and enable level break then u will get all employees salaries and totals of the same in the last line.
    Ellen Deak is absolutely right.
    Refer the attached screenshot of the same. still if you have anything, please let us know.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.