OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » 1 to many (report 10g and application r12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

1 to many [message #474712]

Wed, 08 September 2010 07:28

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

cookiemonster
Messages: 13920
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

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

cookiemonster
Messages: 13920
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

ashokb21
Messages: 92
Registered: May 2010

Member

pfa of .rdf

Attachment: XX_BILLING_REPORT.rdf
(Size: 124.00KB, Downloaded 1276 times)

Report message to a moderator

Re: 1 to many [message #474718 is a reply to message #474717]

Wed, 08 September 2010 07:46

Littlefoot
Messages: 21808
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

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

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

cookiemonster
Messages: 13920
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

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

cookiemonster
Messages: 13920
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

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

cookiemonster
Messages: 13920
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

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

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

cookiemonster
Messages: 13920
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

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

Littlefoot
Messages: 21808
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

ashokb21
Messages: 92
Registered: May 2010

Member

HI THIS IS MY RDF.

Attachment: XX_BILLING_REPORT.rdf
(Size: 60.00KB, Downloaded 1189 times)

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 14:32:30 CDT 2024