Remove the column space dynamically. [message #260854] |
Tue, 21 August 2007 02:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Pradeepora
Messages: 7 Registered: August 2007 Location: Chennai
|
Junior Member |
|
|
Hi,
Iam facing the problem in the report,iam unable to Remove the space dynamically.
Iam able to hide the data dynamically by using the Report triggers, but the space is not removing in the report.
For example if I select the column by using the report parameters the data regarding the column should display and if I not select the column the data should not display and space allocated for that column should be removed.
Regards & thanks,
Pradeep
|
|
|
|
Re: Remove the column space dynamically. [message #260999 is a reply to message #260868] |
Tue, 21 August 2007 08:38 ![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) |
Pradeepora
Messages: 7 Registered: August 2007 Location: Chennai
|
Junior Member |
|
|
Hi,
sorry for giving the private message.i used the format triggers only.
I modify field's Horizontal Elasticity" properties (from Fixed to Variable ) and set the vertical Elasticity to the fixed.
If i modify like it is working fine for false but, the problem is after giving the false i tried to give the true(i.e) select the column)now the all the alignment is collapsed.
give a solution please.
regards,
pradeep
|
|
|
|
Re: Remove the column space dynamically. [message #261149 is a reply to message #261078] |
Wed, 22 August 2007 01:02 ![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) |
Pradeepora
Messages: 7 Registered: August 2007 Location: Chennai
|
Junior Member |
|
|
Hi,
Thanks for your replay, we use the format triggers in the report.
we change the vertical Elasticity to the variable and the Horizontal Elasticity to the Expand in the report then only the report was working fine.But the only problem here is the space is remains at the end we wants to remove this space.
Please help me.
Regards & Thanks,
Pradeep
|
|
|
|
Re: Remove the column space dynamically. [message #261225 is a reply to message #260854] |
Wed, 22 August 2007 03:18 ![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) |
Pradeepora
Messages: 7 Registered: August 2007 Location: Chennai
|
Junior Member |
|
|
Hi,
As you mention in the previous reply I created the new table CUSTOMER and i inserted the data into CUSTOMER table.I mention the table data below.
CUSTOMERID CUSTOMER_NAME COUNTRY
100 NEELIMA INDIA
101 KARTHI AFRICA
102 MUTHAHAR IRAQ
we wrote the below code in the Format Triggers the
function F_CUSTOMERIDFormatTrigger return boolean is
begin
IF :P_CUSTID = 'TRUE' THEN
return (TRUE);
ELSE IF :P_CUSTID = 'FALSE' THEN
RETURN (FALSE);
ELSE
RETURN(TRUE);
END IF;
END IF;
end;
And we changed the field properties the Horizontal Elasticity to Expand and the vertical Elasticity to variable.
now the report is orking fine.
But here the problem is when we gave the parameter value as FALSE the space is remains at end of the report and the when we give TRUE the data should display in the report.Please give the parameter value in capital.
I attached the RDF in this mail,please help me.
Regards&Thanks,
Pradeep
-
Attachment: DAEMO.rdf
(Size: 72.00KB, Downloaded 1227 times)
[Updated on: Wed, 22 August 2007 03:25] Report message to a moderator
|
|
|
|
Re: Remove the column space dynamically. [message #261389 is a reply to message #260854] |
Wed, 22 August 2007 08:13 ![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) |
Pradeepora
Messages: 7 Registered: August 2007 Location: Chennai
|
Junior Member |
|
|
Hi,
Thank you very much for giving the solution.
But what modification you did in the in the report we are unable to find , please tell me the modification.so that i can implement in other reports also.
One more doubt is shell we pass the ":par_" through the OTM(ORACLE TRNSPORTAION MANAGEMENT).we are able to pass "P_" through OTM.
Thanks
Pradeep
|
|
|
Re: Remove the column space dynamically. [message #261481 is a reply to message #261389] |
Wed, 22 August 2007 14:26 ![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 |
|
|
OMG! Name your parameters as you wish!
- I told you all the modifications I did in my previous post.
- I also sent you a sample report which reflects all those changes.
If those two things aren't enough, well, perhaps you should find someone else who will be able to do it better. Because I did my best here and I'm not going to say a word about the issue any more.
|
|
|