Home » Developer & Programmer » Reports & Discoverer » generate to file "delimited" but sequence data non correct
generate to file "delimited" but sequence data non correct [message #201182] Thu, 02 November 2006 21:53 Go to next message
voralux
Messages: 72
Registered: January 2006
Member
Generate to file
select "Delimited"
select Tab"

but text file non correct for sequence data
output from Oracle Report
No. Date Description Amount
001 10-JAN-06 TEST 1 1,000.00
002 20-FEB-06 TEST 2 2,000.00
003 30-MAR-06 TEST 3 3,000.00

output from text file

No. Date Description Amount 10-JAN-06 1,000.00 TEST 1 001
No. Date Description Amount 20-FEB-06 2,000.00 TEST 2 002
No. Date Description Amount 30-MAR-06 3,000.00 TEST 3 003

I would like to output same oracle

No. Date Description Amount 001 10-JAN-06 TEST 1 1,000.00
No. Date Description Amount 002 20-FEB-06 TEST 2 2,000.00
No. Date Description Amount 003 30-MAR-06 TEST 3 3,000.00

Please suggest to me.
thankyou

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #201216 is a reply to message #201182] Fri, 03 November 2006 02:05 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I understood you correctly, you should go to Report Builder's "Paper Layout" and manually change each fields' position, so that it would suit your needs.

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #201566 is a reply to message #201182] Sun, 05 November 2006 20:24 Go to previous messageGo to next message
voralux
Messages: 72
Registered: January 2006
Member
I'm not understand "Paper Layout"
do you mean Layout Model?

Layout Model :
Field_No. Field_Date Field_Description Field_Amount

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #201611 is a reply to message #201566] Mon, 06 November 2006 01:41 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Paper layout is ... well, Paper layout. If you have something like this in your report

/forum/fa/1696/0/

but would like to have this

/forum/fa/1697/0/

simply use the mouse and move fields left or right.

Or, even easier (if it is still without any advanced formattting), re-order fields in "Data Model", use Report Wizard and it will draw it for you.
  • Attachment: rep_2.JPG
    (Size: 18.81KB, Downloaded 1573 times)
  • Attachment: rep_1.JPG
    (Size: 18.60KB, Downloaded 1519 times)

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #201810 is a reply to message #201182] Mon, 06 November 2006 20:34 Go to previous messageGo to next message
voralux
Messages: 72
Registered: January 2006
Member
My Layout = No. Date Description Amount
& output data show = No. Date Description Amount

but text file = Date Amount Description No.

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #201836 is a reply to message #201810] Tue, 07 November 2006 00:55 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh, silly me ... now I understand!

Well, I tested the same thing on my Report Builder 10g (ver. 9.0.4.0.33) connected to 10g (10.2.0.1.0). Sample table was Scott's 'EMP', query was 'SELECT * FROM EMP' and chose

a) Delimited
b) Delimited Data

but both reports produced the same output - all columns were in exact order as the one in Page Layout.

I'm sorry, but I have no idea what might be wrong with your report. What version do you use?

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #227555 is a reply to message #201836] Wed, 28 March 2007 11:06 Go to previous messageGo to next message
tllocke
Messages: 22
Registered: March 2006
Junior Member
I have a very similar issue. I'm using version 10.1.2.0.2 of Reports Builder. I think my order mess-up is happening due to repeating frames. I have one long repeating frame (parent) and then fields, then 3 other fields that are in their own repeating frame (child). These 3 fields are displaying first in the output, but should be last. They ARE last in my layout. I'm stumped. I've put this to many forums already with no true answers. I'm still working on it myself as well. Any suggestions would be great.

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #227610 is a reply to message #227555] Wed, 28 March 2007 15:24 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you anchor this "3-items frame" to something in order to make it print where you need it to?

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #227621 is a reply to message #227610] Wed, 28 March 2007 15:57 Go to previous messageGo to next message
tllocke
Messages: 22
Registered: March 2006
Junior Member
Perhaps that could be my issue? Here's an image of the last part of my paper layout. I have the 3 repeating frames anchored to the outter (parent) repeating frame. I also have the child repeating frames set to 'Keep With Anchoring Object=Yes' and 'Base Printing On=Anchoring Object'. Still... I get the three fields first in the delimited output. Perhaps anchoring to bottom of the parent frame isn't a good idea? I haven't used anchoring before to be honest.


/forum/fa/2290/0/

Thanks again.
  • Attachment: layout.jpg
    (Size: 29.95KB, Downloaded 1411 times)

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #227625 is a reply to message #227621] Wed, 28 March 2007 16:16 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you create additional frame (not repeating!) which would contain those 3 repeating frames (I believe you'll have to send it back in order to arrange all of them properly; grouping 3 existing repeating frames might make it easier). Run the report and, possibly, use anchor (don't forget to remove existing anchors).

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #228378 is a reply to message #227621] Mon, 02 April 2007 15:18 Go to previous messageGo to next message
tllocke
Messages: 22
Registered: March 2006
Junior Member
Thanks for the advice. I've tried this and get another error REP-1814 stating that my repeating frame will never fit 'vertically'. The next option I've been trying out is doing a delimitedata output, which is oh-so-close, but only 1 of the 3 repeating frame columns is output. The two that aren't showing are no different according to the 'Property Inspector'. The 'Exclude from XML output' is set to 'No'. Grrr... this is completely frustrating. Any other ideas??

Report message to a moderator

Re: generate to file "delimited" but sequence data non correct [message #228382 is a reply to message #227625] Mon, 02 April 2007 15:53 Go to previous message
tllocke
Messages: 22
Registered: March 2006
Junior Member
I'm replying to my own post because I just read that sibling groups are not supported in the delimiteddata output... hense the other two not displaying. Back to square one. Help is very much still needed.

Report message to a moderator

Previous Topic: multipul layouts
Next Topic: Problem in order of display in 10g reports
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 05:27:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.