Home » Developer & Programmer » Reports & Discoverer » very urgent :how I order by my report within the report option not change in report query
very urgent :how I order by my report within the report option not change in report query [message #176927] Mon, 12 June 2006 01:11 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
Hi master
Sir I design the report but I need my report order by cheq_no now my report order by voucher no but If I change in query then my format must be change that very problem for me I again design
Is any option in report through which I order by my report as per my require column I is if I need on cheq_no , voucher_no or date

Please give me idea how I order by my report within the report option not change in report query

Thanking you

aamir
Re: very urgent :how I order by my report within the report option not change in report query [message #176989 is a reply to message #176927] Mon, 12 June 2006 05:37 Go to previous messageGo to next message
Rehan Mirza
Messages: 63
Registered: July 2004
Location: Pakistan
Member

Yes use Lexical parameter for your required task

Best regards
R E H A N M I R Z A
sir how i use Lexical parameter [message #177002 is a reply to message #176989] Mon, 12 June 2006 07:27 Go to previous messageGo to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
thank's for your reply

sir how i use Lexical parameter

please give me idea and step

thank

aamir


icon14.gif  Re: very urgent :how I order by my report within the report option not change in report query [message #177009 is a reply to message #176927] Mon, 12 June 2006 08:20 Go to previous messageGo to next message
Rehan Mirza
Messages: 63
Registered: July 2004
Location: Pakistan
Member

Here is sample report

Aamir please join www.erpstuff.com and post yours problems in that forum tooo.

Best regards
R E H A N M I R Z A

[mod-edit]corrected url.
  • Attachment: imp1.RDF
    (Size: 132.00KB, Downloaded 233 times)

[Updated on: Tue, 13 June 2006 05:12] by Moderator

Report message to a moderator

Re: very urgent :how I order by my report within the report option not change in report query [message #177151 is a reply to message #177009] Tue, 13 June 2006 04:53 Go to previous messageGo to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
thank for your reply

sir how i get rownu in report

then i use in blow code

if rownum=1 then
cp_1=bal+amount
else
cp_1=cp_1+amount
end if;

please give me idea

thank



Re: very urgent :how I order by my report within the report option not change in report query [message #184649 is a reply to message #176927] Thu, 27 July 2006 06:06 Go to previous message
issbwc
Messages: 4
Registered: June 2006
Junior Member
You Just take A Parameter Named O_no in report bulder and
make your query as belo....
( :o_no may be 'V' for voucher no, 'C' for chq no, 'D' For Date)

select decode(o_no,'V',<voucger no field>,'C',to_number(<Chq. No. Feild>),2) order_1, decode(o_no,'D',<Voucher_date>,sysdate) order_2
from <table name)
order by 1,2


U Will get the Order no as want



Vikas .....




Previous Topic: ORA-00913 too many values
Next Topic: Print
Goto Forum:
  


Current Time: Sun Dec 11 04:31:42 CST 2016

Total time taken to generate the page: 0.15116 seconds