Answer Posted / fahad

declare

rec_grp recordgroup;
col1 groupcolumn;
col2 groupcolumn;
col3 groupcolumn;
col4 groupcolumn;
col5 groupcolumn;
col6 groupcolumn;
col7 groupcolumn;
col8 groupcolumn;

pl_id paramlist;
i number :=1;
begin
rec_grp := find_group('emp_rec');
if not id_null(rec_grp) then
delete_group(rec_grp);
end if;
rec_grp := create_group('emp_rec');
col1 := add_group_column('emp_rec','Empno',CHAR_COLUMN,100);
col2 := add_group_column('emp_rec','Ename',CHAR_COLUMN,300);
col3 := add_group_column('emp_rec','job',CHAR_COLUMN,300);
col4 := add_group_column('emp_rec','Mgr',CHAR_COLUMN,100);
col5 := add_group_column('emp_rec','Hiredate',DATE_COLUMN,100);
col6 := add_group_column('emp_rec','Sal',CHAR_COLUMN,100);
col7 := add_group_column('emp_rec','comm',CHAR_COLUMN,100);
col8 := add_group_column('emp_rec','Deptno',CHAR_COLUMN,100);


loop
go_block('emp_r');
go_record(i);

add_group_row(rec_grp,i);

set_group_char_cell('emp_rec.empno',i,:emp_r.empno);

set_group_char_cell('emp_rec.ename',i,:emp_r.ename);
set_group_char_cell('emp_rec.job',i,:emp_r.job);
set_group_char_cell('emp_rec.mgr',i,:emp_r.mgr);

set_group_date_cell('emp_rec.Hiredate',i,:emp_r.Hiredate);
set_group_char_cell('emp_rec.sal',i,:emp_r.sal);

set_group_char_cell('emp_rec.comm',i,:emp_r.comm);

set_group_char_cell('emp_rec.deptno',i,:emp_r.deptno);

i := i + 1;
exit when :system.last_record='TRUE';

end loop;

pl_id := get_parameter_list('para1');

if not id_null(pl_id) then

destroy_parameter_list(pl_id);
end if;
pl_id := create_parameter_list('para1');

add_parameter(pl_id,'Q_EMP',DATA_PARAMETER,'emp_rec');
add_parameter(pl_id,'paramform',text_parameter,'no');

run_product(REPORTS,'D:\ora\daily.RDF',synchronous,runtime,filesystem,pl_id,NULL);


end;

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1981

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2217

---

List the different types of columns in oracle reports.

1005

---

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1026

---

why the Ctl file u put only in bin folder why not in other folder

2049

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1163

---

How can we generate report output in excel format?

998

---

did u p prepared complex report

2005

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2025

---

hiding item in report how like that properly,thats manually but at runtime i want to do

3244

---

What is a matrix report and how many minimum groups are required to prepare the same?

1150

---

What is an oracle report? List its various types.

976

---

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2908

---

can you convert or reverse engineer a fmx back to a fmb file?

1164

---

how do u compile a form i.e .fmb file in Unix or in dos

4573

---