Home > Default > Dynamic alignment of report column and page item value

Dynamic alignment of report column and page item value

November 30Hits:0
Advertisement
Hi friends,
I have an interactive report which contains the columns like
<li>empno
<li>Name
In the above i have "empno" with a column alignment of left and a "Name" with a column alignment of left.
Whether it is possible to override the data alignment that we set in the report according to the value of the application item like
If my application item value is US, then i need the column alignment of both the column"empno" and "Name" to be left and if my application item value is AR, then i need the column alignment of both the column "empno" and "Name" to be right. Whether is it possible to achieve the dynamic alignment to the report data of both the columns "empno" and "Name" according to the application page item value.
And also in the case of page item i have a page item with a name P1_NAME in which it has a Element Horizontal/Vertical alignment to left.
I need that element alignment of the page item to behave dynamically according to the application page item, like if the application page item is US then the element alignment of the page item has to be left and if the application page item is AR then the element alignment of the page item has to be right.
Whether is it possible to achieve my above two scenario's friends. Kindly help me with this.
Thanks in advance.
Brgds,
Mini

Answers

Kees,
Your approach is excellent and brilliant:-)
I tried with your steps and i can achieve those alignment in both ways like you said(either on page load/through DA).
But im going with the DA way. I have certain query regarding this kees.
<li>Suppose if the report, is classic whether i can go with the same approach that i have achieved alignment with the IR report.
<li>Currently through the DA way, i used the page item in the condition. Is it possible to use the application item instead of page item in DA. Because im going to use the application item FSP_LANGUAGE_PREFERENCE for getting the code either 'AR' or 'US'.
<li>Finally i need this kind of restriction for the page item also, consider like i have a page item P1_X with an Element Vertical/Horizontal alignment as left. Now i need to change that alignment to right according to the application page item value, hence i can give application item condition for the page item like below
PL-SQL EXPRESSION: :FSP_LANGUAGE_PREFERENCE = 'AR'
i need the element alignment of the page item to behave dynamically suppose if the application item value is AR then the element alignment of that page item has to be right if the application item value is US then the element alignment of that page item has to be left, irrespective of the page item Element Vertical/Horizontal alignment that was set to it.
Thanks for your kind help
Brgds,
Mini

Read other 15 answers

Tags:

Related Articles

  • Dynamic alignment of report column and page item valueNovember 30

    Hi friends, I have an interactive report which contains the columns like <li>empno <li>Name In the above i have "empno" with a column alignment of left and a "Name" with a column alignment of left. Whether it is possible to

  • Column link - call java script & assign current report column value to itemOctober 11

    Hi, How to call java script and assing current report column value to item? I have a button column in the report to 'delete' the selected row. I want to first show dialog box with message 'Are you sure?'. If yes, process to delete will be executed, e

  • Report cells as page itemsNovember 30

    Hello all, I'm trying to make an updateable report w/o using HTML DB's wizards and was wondering if report cells could somehow be stored in page items. I know that report cells are referenced using #COL01#, #COL02#, #COL03#, etc. within the report re

  • Dynamic Selection of Report Column FormatNovember 30

    Is it possible to dynamically set the number format on a report column? I thought it would be as easy as setting the 'Number/Date Format' to a session state variable such as &NUMBER_FORMAT. However, when I tried this the column returned the following

  • Dynamically changing the name of a page itemNovember 30

    Hello, I'd like to dynammically change the name/label of a page item depending on the user who logged in to the system. On my home page, there's a navigation region with some list entries in it. Currently its title is "Configuration". If a speci

  • Reports - "Derive from Page Item" Missing in APEX 3.0.1?October 11

    I installed a patch 3.0.1. I can't find on the list of formats in report queries option: "Derive from Page Item" But, in help window for the list of formats I can read: "The format attribute specifies the download format for the report quer

  • Dynamic color in report columnOctober 11

    Hi, All I design a report and display the column as Text field, in the column "Element Attributes", I put in style= "width:400px;height:400px;background-color:green.;font-size:100px;font-weight:bold;text-align:center",+ the column will

  • Dynamic URL with report column not showingNovember 30

    I created a URL based on a report column in select report region, however instead of seeing the URL link I see the whole text , what am i doing wrong ? Fee Detail select col1, col2, CASE WHEN DPF_CLIENT_FEE_TYPE ='THPSCL' THEN 'Fee Detail' ELSE NULL

  • Dynamically change the report column name.October 11

    Hi All, I have a report where i am showing data for greater than current week and year and the code of same is below SELECT     item_number,     SUM     (   CASE             WHEN year_week_num = to_number(to_char(sysdate,'IW'))+1 THEN                

  • Recalculating fields in an updateable report when a page item changesOctober 11

    Hi, On the one page I have a header section where the user enters the total number of items (eg. 50). I then have an updateable report on the same page where one of the columns is '% of the total items' and the last column of the table is calculated

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.561 s.