Home » Developer & Programmer » Reports & Discoverer » 1 to many (report 10g and application r12)
1 to many [message #474712] Wed, 08 September 2010 07:28 Go to next message
ashokb21
Messages: 79
Registered: May 2010
Member
hi all,
There is one sales order report
in that i have multiple lines
and each line having some details lines

So i need to put header info then line info and then line info details how can i grouping data model
Re: 1 to many [message #474713 is a reply to message #474712] Wed, 08 September 2010 07:34 Go to previous messageGo to next message
cookiemonster
Messages: 10571
Registered: September 2008
Location: Rainy Manchester
Senior Member
Basically how you said it - header info goes in the top group, line info in the next, line info details in the bottom.
Just try it.
Re: 1 to many [message #474715 is a reply to message #474713] Wed, 08 September 2010 07:36 Go to previous messageGo to next message
ashokb21
Messages: 79
Registered: May 2010
Member
i have tried this as wel.but its getting error out (oracle error).
Re: 1 to many [message #474716 is a reply to message #474715] Wed, 08 September 2010 07:38 Go to previous messageGo to next message
cookiemonster
Messages: 10571
Registered: September 2008
Location: Rainy Manchester
Senior Member
That's nice.
What error?
Re: 1 to many [message #474717 is a reply to message #474715] Wed, 08 September 2010 07:40 Go to previous messageGo to next message
ashokb21
Messages: 79
Registered: May 2010
Member
pfa of .rdf
Re: 1 to many [message #474718 is a reply to message #474717] Wed, 08 September 2010 07:46 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What was the error, again?

What should we do with that report? We don't have your tables. Layout in the report you attached is empty. So ...?
Re: 1 to many [message #474721 is a reply to message #474717] Wed, 08 September 2010 07:53 Go to previous messageGo to next message
ashokb21
Messages: 79
Registered: May 2010
Member
REP-0300:ORACLE error occurred.
REP-0069:Internal Error
REP-57054:In-Process job terminated:Terminated with error:
Re: 1 to many [message #474722 is a reply to message #474721] Wed, 08 September 2010 07:55 Go to previous messageGo to next message
ashokb21
Messages: 79
Registered: May 2010
Member
actually i am using rtf template.i have tried to send the rtf template but ora is not supporting it.bad format error is getting wile attaching template rtf to your server.
Re: 1 to many [message #474723 is a reply to message #474722] Wed, 08 September 2010 08:06 Go to previous messageGo to next message
cookiemonster
Messages: 10571
Registered: September 2008
Location: Rainy Manchester
Senior Member
The problem is probably to do with the fact that the middle group contains no database columns, just formula columns.
Each group must contain at least one db column.
Also read up on the break order property.
Re: 1 to many [message #474725 is a reply to message #474723] Wed, 08 September 2010 08:13 Go to previous messageGo to next message
ashokb21
Messages: 79
Registered: May 2010
Member
can please explain me in detail about break order.
Re: 1 to many [message #474726 is a reply to message #474725] Wed, 08 September 2010 08:20 Go to previous messageGo to next message
cookiemonster
Messages: 10571
Registered: September 2008
Location: Rainy Manchester
Senior Member
Read the topic on it report builder help.
Re: 1 to many [message #474727 is a reply to message #474726] Wed, 08 September 2010 08:32 Go to previous messageGo to next message
ashokb21
Messages: 79
Registered: May 2010
Member
I have tried it by putting one db column in middle group but its not working.kindly help me it urgent requirement.
Re: 1 to many [message #474728 is a reply to message #474727] Wed, 08 September 2010 08:34 Go to previous messageGo to next message
cookiemonster
Messages: 10571
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well your report doesn't appear to have a layout either, as Littlefoot pointed out earlier, have you added one yet?
And if it's urgent then you really need to give us as much information as possible - like the error message.
Re: 1 to many [message #474729 is a reply to message #474728] Wed, 08 September 2010 08:43 Go to previous messageGo to next message
ashokb21
Messages: 79
Registered: May 2010
Member
how do i send u the template layout which is rtf.
Re: 1 to many [message #474730 is a reply to message #474729] Wed, 08 September 2010 08:46 Go to previous messageGo to next message
ashokb21
Messages: 79
Registered: May 2010
Member
can i get your email address so i can sent the template layout.kindly if u can.
Re: 1 to many [message #474731 is a reply to message #474730] Wed, 08 September 2010 09:07 Go to previous messageGo to next message
cookiemonster
Messages: 10571
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you want us to have a look at the rtf attach it as you did the rdf.
Re: 1 to many [message #474791 is a reply to message #474731] Thu, 09 September 2010 00:42 Go to previous messageGo to next message
ashokb21
Messages: 79
Registered: May 2010
Member
while uploading my layout file it give some error like(The file you are trying to upload does not match the allowed file types.)
Re: 1 to many [message #474801 is a reply to message #474791] Thu, 09 September 2010 01:14 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So rename it to something else (like "txt", for example; if the original file was MY_LAYOUT_FILE.RTF, rename it to MY_LAYOUT_FILE.TXT). Someone, who downloads it, will rename it back.

Besides, this is a list of valid file extensions.
Re: 1 to many [message #474852 is a reply to message #474801] Thu, 09 September 2010 05:45 Go to previous message
ashokb21
Messages: 79
Registered: May 2010
Member
HI THIS IS MY RDF.
Previous Topic: Migration Issue Reports 6i to 10G
Next Topic: Error failed to locate browser
Goto Forum:
  


Current Time: Thu Apr 17 02:29:23 CDT 2014

Total time taken to generate the page: 0.08990 seconds