OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Dynamic Reporting (9i)

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

Dynamic Reporting [message #526186]

Mon, 10 October 2011 01:33

glmjoy
Messages: 187
Registered: September 2011
Location: KR

Senior Member

I want to make dynamic reporting that user will select the column which he needs in his report. I want to know that also can we make dynamic quires to select all table and user select the required tables with relation that's for my knowledge.
Like wizard in Report Builder do.

e.g my table

Employees
Empno char (5),
Designation_Code char(5),
Salary Number,
PK Empno;

Attendnace
Empno char(5),
Time_In Date,
Time_Out Date,
Actual_Time Date;

If User want reporting
Empno Designation Time_In Time_Out
Or any other
Empno Salary Time_Out

He can make his own selection using tabular format and if possible to make group above to

Report message to a moderator

Re: Dynamic Reporting [message #526191 is a reply to message #526186]

Mon, 10 October 2011 01:46

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

Senior Member
Account Moderator

I can't tell, never did that (although, I suppose that it could be possible - passing selected column names to a report, and deciding whether to display it or not in its Format Trigger).

However, I think that Reports is a wrong tool for such kind of a requirement. What you described looks very much like Apex Interactive Report. I understand this (Apex) is a completely different tool, but ... maybe you could take a look.

Report message to a moderator

Re: Dynamic Reporting [message #526199 is a reply to message #526191]

Mon, 10 October 2011 02:09

glmjoy
Messages: 187
Registered: September 2011
Location: KR

Senior Member

Yes you are right I want like that example you give it to me but i want to make in 6i if we use format trigger then if any new field added we have to make format trigger for that too. And if I have e.g more than 25 columns it means more than 25 trigger. Is there any other solution.

Thanks in advance

Report message to a moderator

Re: Dynamic Reporting [message #535138 is a reply to message #526199]

Mon, 12 December 2011 05:47

jaganerp@gmail.com
Messages: 63
Registered: April 2008

Member

Hi glmojy,

do one thing pass the lexical parameters for the columns('&col1,&col2.....) in data model and write the code in before report trigger also write the format trigger for required columns.

Regards
Jagan

Report message to a moderator

Previous Topic:	Discoverer not showing all data???? help
Next Topic:	Discoverer Admin - How to copy folder from one instance to another

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 10:03:52 CST 2024