Home » Developer & Programmer » Reports & Discoverer » dynamic reports (oracle reports 6i )
dynamic reports [message #387631] Fri, 20 February 2009 02:14 Go to next message
arcangulac
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
icmohsin
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: OLE image not showing up
Next Topic: New to oracle..pls help to open report from form
Goto Forum:
  


Current Time: Sun Dec 04 12:46:17 CST 2016

Total time taken to generate the page: 0.04624 seconds