How to define columns based on lexical parameters in report builder [message #251348] |
Fri, 13 July 2007 01:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
robert.joseph
Messages: 3 Registered: July 2007
|
Junior Member |
|
|
Dear all,
I am facing a pblm in report builder.
I am passing the full query to report from forms .In report I am using lexical parameter to get the query.
My pblm is some time i will pass only 2 field ,some times 3 fields-based on user selection from forms.
How to use anchors to eliminte the blank spaces(some fields doesn't have value,so i have to display the fileds with values together)
|
|
|
|
Re: How to define columns based on lexical parameters in report builder [message #251891 is a reply to message #251348] |
Tue, 17 July 2007 01:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
robert.joseph
Messages: 3 Registered: July 2007
|
Junior Member |
|
|
Dear,
Thanks for the reply.
I am facing some diffrent pblm.
I am passing the entire query using lexical parameter.
ex my parameter :p1 contains 'select empno,name from emp'
and i can reffer this thru query builder &p1
If i am not giving any initial value it wont accept the query.
If i give initial parameter of p1 as 'select empno,name from emp' it will accept.Pblm is if i am passing only one field.suppose 'select name from emp' it will automatically assign empno as 'name' and the widht will be empno's width.
how can i change this.If iam using parameters it will automatically define columns, but it will take width internally as 32 characters.I cannot change this width.is there any solutions
thanks in advance
Robert
|
|
|
Re: How to define columns based on lexical parameters in report builder [message #252008 is a reply to message #251891] |
Tue, 17 July 2007 11:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I'm sorry, but I wouldn't know how to help you.
However, I'm curious - why do you want to write reports like this? Is there any special reason for doing that? Do you just test it, or is it a business request?
Because, if something exists (possibility of passing the whole query as a lexical parameter), it doesn't mean you MUST use it. Perhaps there's a workaround for your problem, but we should hear something more about it.
|
|
|