Table columns in specific order depending on the parameter [message #1777854] |
Tue, 05 December 2017 10:25 |
Sayu Yagami Messages: 2 Registered: September 2017 |
Junior Member |
|
|
In my report, I need to allow the user to choose what data he wants to receive and in what order, but I have no idea how to do it
For example, consider three text box parameters :
- p_name
- p_surname
- p_birthdate
When user enters value like this
p_name = 1
p_surname = 2
p_birthdate = 3
the table generated by the report should look like this
------------------------------------------------------
| NAME | SURNAME | BIRTHDATE |
------------------------------------------------------
when
p_name = 2
p_surname = 3
p_birthdate = 1
-------------------------------------------------------------
| BIRTHDATE | NAME | SURNAME |
--------------------------------------------------------------
and when value like this
p_name = 1
p_surname = 2
p_birthdate = empty
-------------------------------------
| NAME | SURNAME |
-------------------------------------
I tried to script it and it work quite well but i cant hide the columns when the parameter is empty.
Another problem occurs when the selected data occupies more than one column
I would be grateful for any suggestions on how to deal with this issue
|
|
|
Powered by
FUDForum. Page generated in 0.01266 seconds