OraFAQ Forum: Reports & Discoverer » reg generating files depending on field value

Home » Developer & Programmer » Reports & Discoverer » reg generating files depending on field value

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

reg generating files depending on field value [message #113424]

Sat, 02 April 2005 22:11

Kalpana Srinivas
Messages: 10
Registered: January 2004

Junior Member

Hi

I want to create a report which displays departments with employee details.
Like
dept:10
empno ename
-----------------
1111 xxxxx
3333 yyyyy

dept:20
empno ename
-----------------
4444 zzzzz
5555 aaaaa

in that report in another section it should display only employee details for particular dept.
dept:10
empno ename
-----------------
1111 xxxxx
3333 yyyyy

after that I should generate files depending upon dept number.
Like 10.pdf, 20.pdf,30.pdf.

One section is summery report, in another section individual details. summery report should go to Manager. Particular department deatils should go to particular department heads accordingly.

version is reports6i.

pl help.

Thanks in advance.

Report message to a moderator

Re: reg generating files depending on field value [message #113511 is a reply to message #113424]

Mon, 04 April 2005 05:52

hsinghalmrt
Messages: 51
Registered: March 2005

Member

what u want exactly to do .

u can make a report based on data link between the summary and details Query and can print on different pages.

Report message to a moderator

Re: reg generating files depending on field value [message #113545 is a reply to message #113424]

Mon, 04 April 2005 09:38

Kalpana Srinivas
Messages: 10
Registered: January 2004

Junior Member

I want to generate a report which has to split dept wise information to files. like employee information about dept 10 should go to 10.pdf file, dept 20 info to 20.pdf and so on.

How can I do this?

I think reports9i has the facility. But I don't know about reports6i.

Thanks in advance

Report message to a moderator

Re: reg generating files depending on field value [message #116122 is a reply to message #113545]

Sun, 17 April 2005 22:26

AshSydney
Messages: 24
Registered: April 2005
Location: Sydney, NSW , Australia

Junior Member

I am not sure whether this could be possible in your case but still see if this could be done

1. If you can pass department as a parameter to run the DETAIL report( deptcode or ALL)

2. For each dept run the details report and use following in the parameter form

SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESNAME, DEPTNO.PDF)
3. When Argument is 'ALL' run summary report with a DESNAME as DEPSUM or whatever you call it.

-Ash

Report message to a moderator

Re: reg generating files depending on field value [message #116123 is a reply to message #116122]

Sun, 17 April 2005 22:29

AshSydney
Messages: 24
Registered: April 2005
Location: Sydney, NSW , Australia

Junior Member

Also I would like to know whether Are you using Oracle forms as a front end?? or some different.

Also,

would user specify the dept code or you want to generate it for all of them?

-Ash

Report message to a moderator

Previous Topic:	Friends need your help desperate--> Second page not printing from the beginning
Next Topic:	Page Protect Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 21:50:36 CDT 2024