OraFAQ Forum: Reports & Discoverer » very urgent :how I order by my report within the report option not change in report query

Home » Developer & Programmer » Reports & Discoverer » very urgent :how I order by my report within the report option not change in report query

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

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

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

Report message to a moderator

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

Rehan Mirza
Messages: 67
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

Report message to a moderator

sir how i use Lexical parameter [message #177002 is a reply to message #176989]

Mon, 12 June 2006 07:27

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

Report message to a moderator

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

Rehan Mirza
Messages: 67
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 1201 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

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

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 10:52:14 CDT 2024