Uderc programming article aggregator sites
Index -> word online columns

word online columns


Re: Column is not getting displayed in the BI report

Hello Gurus, I have developed a BI report with more number of parameters. Case 1: When i run my report , I am able to see data for particular condition but one column doesn't show any thing. All the rows in the column are blank. Case 2 I tried to put

Query help: query to return column that represents multiple rows

I have a table with a name and location column. The same name can occur multiple times with any arbitrary location, i.e. duplicates are allowed. I need a query to find all names that occur in both of two separate locations. For example, bob usa bob m

Unable to capture the adf table column sort icons using open script tool

Hi All, I am new to OATS and I am trying to create script for testing ADF application using open script tool. I face issues in recording two events. 1. I am unable to record the event of clicking adf table column sort icons that exist on the column h

Implementing BADI MD_ADD_COL_EZPS for MD04 custom column

Hi there, I'm using BADI MD_ADD_COL_EZPS to display 3 new buttons and three new columns in MD04. For each line item that is displayed, the custom column is filled, after the button is hit -This works fine. My Question is: Is there any way to limit th

APEX-The manullay created column is not getting updated in the database

Dear all I have a form on page, which is created along with a report using Form on a Table with Report option. From the form I have deleted one field and recreated manullay as set the property as database column. When I am calling from the report pag

Not null and enable or disable  column in tabular form

Hi, Using apex version 4.1 and working on tabular form. ACT_COA_SEGMENT_MAS is Master table and ACT_SEGMENT_VALUES_MAS is detail table I have entered 8 rows in master table and PARENT_SEGMENT_ID is column in master table which is null able. If i spec

Converting null and blank to NA in a column of a database table

Hi This is a simple thing but is giving me a hard time. I need to change the values coming as null or blank to NA . The values comes in a flat file as a source and I need to laod it convertign to NA in database. I wrote the expression as ISNULL([NPS

Get column values from list of values programmatically

hi all how i get column values from list of values programmatically in the returnPopupDataListener methodIf this answers your question , please close this thread by marking it as answered. ThanksRead other 4 answers

How to delete file from column after upload with messageFileUpload?

Which is the way to delete a file from column i have uploaded with messageFileUpload. After uploading the system generates a link to download the file. But how i can delete the file?Thank you! Syncing has always scared me...basically I am just afraid

In ALV report is possible to display the subtotals in separate column

Hi, I have made one ALV report, i need to show the subtotals of ekpo-brtwr (Gross Value)  grouped by or sorted by ekko-ebeln (Purshasing Doc) but in separate column  not at the end of the line items of each purshasing doc any idea how can i do this?

How to rename C00n generic column names in a Dynamic SQL report

I have a an interface whereby the user can select 1 to 60 (upper limit) columns out of 90 possible columns (using a shuttle) from one table before running a report. To construct the SQL that will eventually execute, I'm using a "PLSQL function body r

Add Image column in classic sql report to open a pop page

I have sql report I want to add a new column which will have image to click, Once user clicks the image a popup page should open.Hi Vikram, Sorry to bother you, I am very new to apex. Here is my sql query for sql report. Can you please help me. <xmp>

Discoverer  report does not sum up the column

Hi All, I am running the discoverer report from discoverer desktop and was trying to use the sum function to sum the total amount of the report. The sum function does not work and it only display Cell Sum: (blank) with no actual data. When i checked

Interactive report column filters to display differently than column values

Greetings... We use images a lot in our interactive reports to provide a visual representation to a status, or something locked for update, or what-have-you. By default, when a user clicks the column heading of a column which contains images, the dro

How to open a popup win within a PDF file (c:\test.pdf) as Column Link

I have a interactive report based on a Table (EMP). I need to create a column link that opens a pdf file within the employee curricula All the curriculum are stored in a windows folder, and in the EMP table there is a field named PATH containing the

How to make column headers in table in PDF report appear bold while datas in table appear regular from c# windows forms with sql server2008 using iTextSharp

Hi my name is vishal For past 10 days i have been breaking my head on how to make column headers in table appear bold while datas in table appear regular from c# windows forms with sql server2008 using iTextSharp. Given below is my code in c# on how

XML Publisher Report:how to disappear the column if no data found

Hi, I have a XMl publisher report requirement , the format is tabular lets say with the structure of 4 columns and 10 rows.requirement is to if suppose there is no data for row number 6 the row itself should not appear over the report and the immedia

How to get multiple records in one row and different column

Hi All, I am using oracle database 11g and i have a two tables table_1, table_2 table_1 having columns emp_no first_name middle_name last_name email and table_2 having columns emp_no phone_type phone_number and having entires emp_no phone_type phone_

How can I Move data from one column to another in my access table?

I have two columns, one that stores current month's data and one that stores last month's data. Every month data from column 2 (this month's data) needs to be moved to column 1 that holds last month's data. I then null out column 2 so I can accumulat

Reg:How to delete the column in table control also from database table.

Hi Experts, Once again thank u all for giving the responses. one more doubt is how to delete the columns of table control and also the record shold delete from ztable. With Regards, Saroja.P.Hi, If you want to delete the rows in the table control and