Search found 51 matches
- Sat Nov 18, 2006 10:19 am
- Forum: Oracle Forms & Reports
- Topic: how get direct print
- Replies: 3
- Views: 2219
thnks for your reply sir i use oracle form 6i and report also and use this method declare emppara paramlist; begin emppara :=create_parameter_list('aamir'); Add_Parameter(emppara, 'PARAMFORM', TEXT_PARAMETER, 'NO'); add_parameter(emppara,'p_1',text_parameter,:ysdate); add_parameter(emppara,'p_2',tex...
- Sat Nov 18, 2006 3:11 am
- Forum: Oracle Forms & Reports
- Topic: how get direct print
- Replies: 3
- Views: 2219
how get direct print
Hi master,
Sir I have report that contain two page sir my need is I not want preview I want direct print and not want all page my requirement only page 2 not want page 1
Sir please give me idea how I get direct print and only page no 2
Thanks aamir
Sir I have report that contain two page sir my need is I not want preview I want direct print and not want all page my requirement only page 2 not want page 1
Sir please give me idea how I get direct print and only page no 2
Thanks aamir
- Mon Oct 30, 2006 8:03 am
- Forum: Oracle Forms & Reports
- Topic: how convert oracle report to excel
- Replies: 4
- Views: 1951
how convert oracle report to excel
hi maser
sir how i convert oracle report to excel such oracle convert report into html easily
please give me idea and step how i convert report into excel
thank
aamir
sir how i convert oracle report to excel such oracle convert report into html easily
please give me idea and step how i convert report into excel
thank
aamir
- Thu Oct 12, 2006 12:54 am
- Forum: Oracle Forms & Reports
- Topic: Re: report order by problem
- Replies: 2
- Views: 1765
Re: report order by problem
sir when i use this query SELECT VOUMASTER.discription,cheqno,NVL(SUBSTR(VOUMASTER.cheqno,10,10),0) AS chqno,VOUMASTER.entdate,VOUDETAIL.vno,VOUDETAIL.accid,VOUDETAIL.debit,VOUDETAIL.credit,CHARTOFACC.title AS acc_title,PARTYTABLE.title AS PARTY,DEPARTMENT.title AS DEPT FROM VOUDETAIL,VOUMASTER,CHAR...
- Mon Oct 02, 2006 12:56 am
- Forum: Oracle Forms & Reports
- Topic: how textbox disable and accept only from lov
- Replies: 0
- Views: 1021
how textbox disable and accept only from lov
hi master sir my user some time feed rough data i want to restric that he only select value from lov not give from key board mu text bot disable and accept only lov please give me idea how textbox disable and accept only from lov some body give me this idea ======= use a text-item link in the item y...
- Fri Aug 25, 2006 4:44 am
- Forum: Oracle Forms & Reports
- Topic: HOW START NEW PAGE WHEN GROUP CHANGE IN ORACLE REP
- Replies: 2
- Views: 1420
HOW START NEW PAGE WHEN GROUP CHANGE IN ORACLE REP
hi master
sir i use oracle group report with many group
sir my question is
HOW START NEW PAGE WHEN GROUP CHANGE
or every group print seprate page
please give me idea
thanks
aamir
sir i use oracle group report with many group
sir my question is
HOW START NEW PAGE WHEN GROUP CHANGE
or every group print seprate page
please give me idea
thanks
aamir
- Sun Aug 20, 2006 3:20 am
- Forum: General / Others
- Topic: Please give me idea now I compile all branch data
- Replies: 0
- Views: 1208
Please give me idea now I compile all branch data
Hi master Sir I have 5 office In different city and one head office in Karachi all branch have same oracle system my question is how I get new data and compile for accumulative reporting I want only new record and modify record not old record Old record already I import When I use oracle import and ...
- Fri Aug 11, 2006 6:56 am
- Forum: General / Others
- Topic: see my query and give me right idea
- Replies: 0
- Views: 1160
see my query and give me right idea
sir see my query mfa2 is mastr and mfa3 is detail this query give me union type result and mfa2*mfa3 but i need master detail result SELECT mfa3.stdcode,mfa2.vhno,mfa3.name FROM ( SELECT STUSECMTAMT.stdcode,STUSECMTAMT.sem_code,COURSES.name,COURSES.id,COURSES.crhrs,STUDEG.DEGREE_code,SCHEME_DEG_DET....
- Thu Aug 10, 2006 12:57 am
- Forum: Oracle Forms & Reports
- Topic: see my error frm-40735 post query
- Replies: 7
- Views: 4936
- Wed Aug 09, 2006 8:53 am
- Forum: Oracle Forms & Reports
- Topic: see my error frm-40735 post query
- Replies: 7
- Views: 4936
- Wed Aug 09, 2006 8:46 am
- Forum: Oracle Forms & Reports
- Topic: how get combine report with using tree query
- Replies: 0
- Views: 859
how get combine report with using tree query
Sir I have tree spared query how i report how I link all query with each other the STUSECMTAMT .stdcode this is same column in each query SELECT STUSECMTAMT .stdcode,RATES.description,RATES.amount,STUINV.amt-RATES.amount AS addotherfee,STUINV.amt,STUINV.discperc,(STUINV.amt/100)*STUINV.discperc AS d...
- Tue Aug 08, 2006 9:49 am
- Forum: Oracle Forms & Reports
- Topic: see my error frm-40735 post query
- Replies: 7
- Views: 4936
thanks for your reply Sir this is optional field is if amount less then 5000 then not pad through cheq and :cheqno must be null if garter then 5000 then pad through cheq mustbe give value in :cheqno how i check :cheqno at navigation or query time or fatching time if i found :cheqno have value then i...
- Tue Aug 08, 2006 7:54 am
- Forum: Oracle Forms & Reports
- Topic: see my error frm-40735 post query
- Replies: 7
- Views: 4936
see my error frm-40735 post query
Sir I use this code in post query event :partyname :=''; :CHQBANK :=''; :repchq:=''; :chqdate:=null; :chqbank:=''; :PARTYNAME :=''; select YEARID,TITLE,STDATE,CLDATE,CLOSINGSTATUS into :yearid,:yeartitle,:ysdate,:yedate,:YSTATUS from yeartable where stdate<=:entdate and cldate>=:entdate; if :partyid...
- Thu Aug 03, 2006 8:28 am
- Forum: Oracle Forms & Reports
- Topic: how system give me page selection windows
- Replies: 1
- Views: 1279
how system give me page selection windows
Sir I uses this code for printing and system give me preview Run_Product(REPORTS, 'd:\iqramfa\pcvoucher', SYNCHRONOUS, RUNTIME,FILESYSTEM,emppara, NULL); But when I press print button system directly print all page Sir I want print only particular page or only page no 1 or or page no 2 not need all ...
- Wed Aug 02, 2006 5:39 am
- Forum: General / Others
- Topic: how get parameter wise view
- Replies: 3
- Views: 2173