OraFAQ Forum: Reports & Discoverer » how to add union to report query

Home » Developer & Programmer » Reports & Discoverer » how to add union to report query (reportbuilder10g,oracle11g, server2000)

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

how to add union to report query [message #543626]

Thu, 16 February 2012 00:27

sugandh4bcce
Messages: 2
Registered: January 2012
Location: allahabad

Junior Member

hello,
i am making a report in hrd regarding gross, deduction and there difference. I hv an attribute in the table as indicator whose value is addition and deduction. i want the sum of both in two diff column in a single rep.
i want the report dept wise.

but i m getting fatal error at run time. which i don't understand.. please help me regarding this....

[Updated on: Thu, 16 February 2012 00:30]

Report message to a moderator

Re: how to add union to report query [message #543627 is a reply to message #543626]

Thu, 16 February 2012 00:44

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is rather difficult to guess. If you don't understand the error message, how do you expect us to understand it when you didn't even post it? Is it one of ORA-, REP-, or any other message? Or did Reports Builder simply crash? If the latter, the reason might be in (possible) unsupported combination of Developer Suite you use with operating system (MS Windows 2000?). Check certification matrices on My Oracle Support to make sure.

Report message to a moderator

Re: how to add union to report query [message #543629 is a reply to message #543627]

Thu, 16 February 2012 00:49

sugandh4bcce
Messages: 2
Registered: January 2012
Location: allahabad

Junior Member

atually the error is in report..... if r not getting then iwill send u the report exactly

Report message to a moderator

Re: how to add union to report query [message #543658 is a reply to message #543629]

Thu, 16 February 2012 02:54

cookiemonster
Messages: 13919
Registered: September 2008
Location: Rainy Manchester

Senior Member

The fatal error will have an error code and an error message.
Post them.

Report message to a moderator

Previous Topic:	How to Return Values in a Text or Boiler Plate
Next Topic:	How to see the output of reports in Textpad

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 14:23:22 CDT 2024