Results 1 to 4 of 4

Thread: RDA - Report date fields jumps to next line when exporting to CSV

  1. #1

    RDA - Report date fields jumps to next line when exporting to CSV

    Somewhat new to RDA but....

    I'm trying to export a report to CSV. Trying to get data in CSV to look something like below:
    4/1/2019 77777 Dallas
    4/2/2019 99999 New York

    But instead it looks like this with the dates dropping down a line

    77777 Dallas
    4/1/2019
    99999 New York
    4/2/2019


    It doesn't do this on report when Report Destination is 'On Screen' and date stays on same line.

    I tried everything I can think of format-wise but to know avail. Seems like its something with the date field.

    Anyone ever see this and how did you solve?

    Much appreciation for any assistance you can give!!!!

    Thanks, Dave

  2. #2
    Member Mike Mackinnon's Avatar
    Join Date
    Nov 2000
    Location
    Halifax, Canada
    Posts
    188
    Dave,

    1.) This should probably be in the "JD Edwards® EnterpriseOne Applications" forum.
    2.) What type of section are you using?
    3.) Also please include your release level in your reply (or include in signature).
    * Identify your platform, OS Version, DB version, OW version, Service Pack level, etc.

    If it is a group section then:

    Make sure fields are lined up properly. They may be just slightly off causing some fields to go to the next line.
    Highlight all the fields and go to Layout -> Align and align 'Top Edges" or "Bottom" so that everything is aligned properly.
    Mike MacKinnon
    IMP Group International
    EnterpriseOne tools RL 9.2.2.6, Application RL 9.2
    BI Desktop Publisher 11.1.1.7
    Browser IE10 & Chrome 62.0.3202.94

    - Financials, Inventory (Sales & Procurement), MRP, Manufacturing, Development Tools, BI Publisher

  3. #3
    Member
    Join Date
    Jun 2001
    Location
    Colorful Colorado
    Posts
    475
    If the data is even one vertical pixel off in RDA in a group section, it will be a separate line in the CSV.

    Select all the field you have in a 'row' and then 'align to bottom' using RDA's tools for that. I believe that will solve your problem.
    --john

  4. #4
    Make sure the column in the section are a little below the section border and not touching right on the section border .So when you have the section , have the columns a little lower and not touching the borders , sometimes those cause issues and as said before , make sure select all then choose the last one as the one you want to align WITH and choose align top edges to make sure all line up .If csv , make sure the columns when put in section are properly aligned with column and layout of csv . It has to be in design and column placement and alignment , have seen that and it can be easily resolved .

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.