Home » Developer & Programmer » Reports & Discoverer » how to add union to report query (reportbuilder10g,oracle11g, server2000)
how to add union to report query [message #543626] Thu, 16 February 2012 00:27 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 18833
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.
Re: how to add union to report query [message #543629 is a reply to message #543627] Thu, 16 February 2012 00:49 Go to previous messageGo to next message
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
Re: how to add union to report query [message #543658 is a reply to message #543629] Thu, 16 February 2012 02:54 Go to previous message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
The fatal error will have an error code and an error message.
Post them.
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:
  


Current Time: Sun Apr 20 04:33:16 CDT 2014

Total time taken to generate the page: 0.08303 seconds