Home » Developer & Programmer » Reports & Discoverer » dynamic reports (oracle reports 6i )
dynamic reports [message #387631] Fri, 20 February 2009 02:14 Go to next message
Messages: 16
Registered: October 2006
Location: izmir
Junior Member

i image that there is a form for user and user can choose reports fields that form.This fields from database users_tab and users_colums.After that sent to reports fields,tables name and reports(it can be matrix)do run with this field and tables.
is it possible or not reports 6i
Re: dynamic reports [message #387640 is a reply to message #387631] Fri, 20 February 2009 03:00 Go to previous message
Messages: 12
Registered: January 2009
Location: Mumbai
Junior Member
Do one thing first make report with all column and then set there elasticity to variable of fields and frame.
Suppose you have total 10 column and from form you have selected 3 column with position 1,3 and 5 so pass a char. String from form to report i.e. 1010100000
In report do conditional formatting on all fields. First position of string will be represented as first column and check whether it is 1 or 0 if 0 then hide. Use conditional formatting
It will work I have successfully done it.
Previous Topic: pre printed report
Next Topic: global temporary table
Goto Forum:

Current Time: Mon Aug 21 01:38:43 CDT 2017

Total time taken to generate the page: 0.00977 seconds