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: 92
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

Report message to a moderator

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: 13962
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.

Report message to a moderator

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: 92
Registered: May 2010
Member
i have tried this as wel.but its getting error out (oracle error).

Report message to a moderator

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: 13962
Registered: September 2008
Location: Rainy Manchester
Senior Member
That's nice.
What error?

Report message to a moderator

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: 92
Registered: May 2010
Member
pfa of .rdf

Report message to a moderator

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: 21823
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 ...?

Report message to a moderator

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: 92
Registered: May 2010
Member
REP-0300:ORACLE error occurred.
REP-0069:Internal Error
REP-57054:In-Process job terminated:Terminated with error:

Report message to a moderator

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: 92
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.

Report message to a moderator

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: 13962
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.

Report message to a moderator

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: 92
Registered: May 2010
Member
can please explain me in detail about break order.

Report message to a moderator

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: 13962
Registered: September 2008
Location: Rainy Manchester
Senior Member
Read the topic on it report builder help.

Report message to a moderator

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: 92
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.

Report message to a moderator

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: 13962
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.

Report message to a moderator

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: 92
Registered: May 2010
Member
how do i send u the template layout which is rtf.

Report message to a moderator

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: 92
Registered: May 2010
Member
can i get your email address so i can sent the template layout.kindly if u can.

Report message to a moderator

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: 13962
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.

Report message to a moderator

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: 92
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.)

Report message to a moderator

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: 21823
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.

Report message to a moderator

Re: 1 to many [message #474852 is a reply to message #474801] Thu, 09 September 2010 05:45 Go to previous message
ashokb21
Messages: 92
Registered: May 2010
Member
HI THIS IS MY RDF.

Report message to a moderator

Previous Topic: Migration Issue Reports 6i to 10G
Next Topic: Error failed to locate browser
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 21 20:51:34 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.