OraFAQ Forum: Reports & Discoverer » Bind parameter Defined In report

Home » Developer & Programmer » Reports & Discoverer » Bind parameter Defined In report (oracle 10g)

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

Bind parameter Defined In report [message #477857]

Mon, 04 October 2010 23:26

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

I Created a Bind parmeter in report .....but when i run report it show only loc bind parameter not fyyear bind parameter...

Please help me
Code is :

SELECT distinct BPT_LOC Location, BPT_DOC_DT BNP_REF_DT, BPT_DOC_NO BNP_REF_NO, 
                  BPT_VEN_NM Vendor_Name,
                  BPT_BIL_NO Bill_No, BPT_BIL_DT Bill_Date ,
                  E.BMDT_CNTRCT_CD CONTRACT_NO,
                  BPT_NET_VOU Total_Amount, BPT_SAL_RT VAT_AMOUNT,
                  BPT_SAL_CLU VAT_Rate ,  
                  B.VMT_VAT_NO vendor_tin_no,
                 (B.VMT_VNDR_ADDR1 ||'  '|| B.VMT_VNDR_ADDR2||'  '||VMT_VNDR_ADDR3 || ' ' || B.VMT_VNDR_ADDR4 || '  '|| B.VMT_VNDR_ADDR5)
                 Vendor_address
        FROM  BILL_HDR1_TAB , VNDR_MST1_TAB B , ITEM_MST1_TAB D, BILL_MC_DTL1_TAB E
        WHERE BPT_LOC = ':p_loc'
        AND   BPT_DOC_NO  = E.BMDT_DOC_NO
        AND   BPT_VEN_CD    = B.VMT_VNDR_CD(+)
        AND   TO_DATE(BPT_DOC_DT, 'DD/MM/RRRR') > '01-apr-'||':p_FyYear'
        AND   TO_DATE(BPT_BIL_DT, 'DD/MM/RRRR') <= '31-MAR-'||':p_FyYear'
        order by BPT_BIL_DT

[EDITED by LF: set [code] tags instead of [b] ones]

[Updated on: Tue, 05 October 2010 01:10] by Moderator

Report message to a moderator

Re: Bind parameter Defined In report [message #477880 is a reply to message #477857]

Tue, 05 October 2010 01:11

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

Senior Member
Account Moderator

Quote:

when i run report it show only loc bind parameter not fyyear bind parameter

What shows only "loc" bind parameter? A (report) parameter form? Did you add "fyyear" parameter to the parameter form?

[EDIT] Forgot to say: remove single quotes from parameters.

[Updated on: Tue, 05 October 2010 01:14]

Report message to a moderator

Re: Bind parameter Defined In report [message #478531 is a reply to message #477880]

Sun, 10 October 2010 07:39

deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE

Senior Member

Dear Friend,
Try this,

SELECT DISTINCT bpt_loc LOCATION, bpt_doc_dt bnp_ref_dt,
bpt_doc_no bnp_ref_no, bpt_ven_nm vendor_name,
bpt_bil_no bill_no, bpt_bil_dt bill_date,
e.bmdt_cntrct_cd contract_no, bpt_net_vou total_amount,
bpt_sal_rt vat_amount, bpt_sal_clu vat_rate,
b.vmt_vat_no vendor_tin_no,
( b.vmt_vndr_addr1
|| ' '
|| b.vmt_vndr_addr2
|| ' '
|| vmt_vndr_addr3
|| ' '
|| b.vmt_vndr_addr4
|| ' '
|| b.vmt_vndr_addr5
) vendor_address
FROM bill_hdr1_tab,
vndr_mst1_tab b,
item_mst1_tab d,
bill_mc_dtl1_tab e
WHERE bpt_loc = ':p_loc'
AND bpt_doc_no = e.bmdt_doc_no
AND bpt_ven_cd = b.vmt_vndr_cd(+)
AND TO_DATE (bpt_doc_dt, 'DD/MM/RRRR') > '01-apr-' || :p_FyYear
AND TO_DATE (bpt_bil_dt, 'DD/MM/RRRR') <= '31-MAR-' || :p_FyYear
ORDER BY bpt_bil_dt

Regards
Deepak

Report message to a moderator

Previous Topic:	footer in layout in main section
Next Topic:	Avoid Object / record moving On report paper layout

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 20:09:29 CDT 2024