Dynamic crosstab column title - expression issue

I have a crosstab using Cognos cube for data. I have created a member and used it as a crosstab column. The member is a data item (name: 3MonthSet) with the following expression:aggregate(currentmeasure within set (tail(descendants(currentmember([Cube].[Time].[Time]), 3), 3))) Since my cube has data ...

display a calculated date in column title

Genti Hila said: I have a list report and one of the prompt is the start date. Among other columns there is this column that calculates the sales for one year. So if the start date is Sep 01, 2007 the other date would be Aug 31, 2007.Depending on what users input as a start day (let's supose it is O ...

Sorting image with column title

How to check sorting icon along with column title in a table in the UI? With recording, we can only record either the column title or the sorting image, not both.Seema.Message was edited by: ViewMyScreen ...

multi lined column title?

how to make a multi lined column title in a CListCtrl? ...

Retreiving Ojbect Attribute Value by Column Title

I am using Test Runs to record Pass/Fail status of test steps and requirements. I have 50+ test cases and not all of them are on the same test run # I have an Attribute "Run P/F" that gets created for each test run. So, some test case are on "Run P/F 6" and others are on "Run P/F 4" or 3 or 5 etc. W ...

Repeating column title every 20 rows

How can I repeat automatically the column title every 20 rows/results? ...

Oracle
in dynamic sql column title ?

I have a HTML report containing a sql with an embedded loop, the layout result I get is columns containing values having a date for column title. I got the result I've wanted, but I would like to have the title on 2 lines instead of only one. I tried to add in the alias (dynamic dates) but it's retu ...

Multiline Column title in listview

Could any one please tell how can I set multi-line column title in a listView with report style? ...

Oracle How to take out region title and make title disappear?

I put a logo on the apex application so I don't need region title.How can I take out region title and make title disappear on the screen? ...

Removing Column Title from Export

Hi, apologies if this question has been asked, I have searched for answers but perhaps i'm using the wrong terms.I'm currently using DOORS to export a module to word using the built in function. The view I am exporting has one column, the data from which is composed of a number of attributes through ...

List column title to appear after each list header group

I am working on a list report. I have grouped my data on few columns and all the grouped columns are placed in header.I have the list properties for column title set to : at start of details.I want the column title to appear after each group with the column title set to at start of details i dont se ...

Cognos 8 Report Studio Default List Column Title Colors?

In Cognos 8 Report Studio List Column Titles what are the default colors for the background and borders?Also what is the default color for the borders of the List Column Body? ...

Search displayed data through Column Title?

I am using one utility to display mysql data through search form. After search I received page with five columns. All are working fine. But now I want to make that page more users friendly. I want to make that search result sort by all column header. However I don’t have an idea about the same. Can ...

Window title disappear when MDIChildWnd is splitted with CSplitterWnd.

I am developing MDI child window with CSplitterWnd.Initially, MDI child window displays only one view.After MDIChildWnd is splitted, it has 2 or more views.Each view is attached same Document.But when MDI child window is splitted, child window's title is disappeared.And MainFrame's child window titl ...

Spaces in column title

Good day,I have several columns that have spaces before and after the titles. Example, " NAME_FIRST" or "NAME_LAST ". Number of spaces can be different every week, its imported from outside source. I can't change column titles. However, I need to SELECT * from these columns ignor ...

Is it possible to change color of column title in ListView?

Thank you. ...

Oracle Standard Report - Can I get a column title to span multiple columns?

I have a simple standard report that shows for a Project the number of Work Packages that have a RAG Reporting Status of Red, Amber or Green.I therefore have four columns:: Project Name : Red : Amber : Green :I would like to have some text across the last three columns like (ignore the 'X's - just t ...

Oracle title lable on column value

I am working on a IR and need to show the column title on each cell value. Because this is a big report so the user should not scroll up to see what column it is. I don't want a link on the column. ...

Oracle Report values for custom cell disappear

I have created a custom filed called TCV (Total Contract Value).I create a report with an extra column called "Weighted TCV". This is TCV multiplied by the probability %. So far so good. When I add for example the field "Opportunity Title" to in the Define Criteria filed everything is fine, but when ...

jQuery UI table filter for selected column

I use UI Table Filter link. For whole table it works great but i don't know how to use it for selected column only:/ On project page we can read:$.uiTableFilter( t, phrase, column, ifHidden ) * column to limit search too (the column title in the table header) Here is part of my code $('document ...

mod_rewrite change url to text title

I have a url for example:http://domain.com/watch_7hzd1eczv85.htmlHere is my current .htaccess codeOptions +FollowSymLinksRewriteEngine onRewriteRule watch_(.*)\.html$ /player.php?vidshow=$1Okay the 7hzd1eczv85 is referring to the column filename from mysql. However I would rather it be like this:htt ...

Getting column titles from MySQL

I wonder if anybody could help me with some column headings i'm trying to get hold of from my MySQL database. I have got the following code which gets the main elements of the record set:if (! $rsL = mysql_query("SELECT * FROM cv WHERE cv_title='$cvname'",$conn)){die("Cannot Execute Q ...

Recompile needed if column length changes?

Hi, let's say i have a table defined in DB2 for z/OS v8 as follows:create table simple (title char (20));and a COBOL declaration as follows:01 TITLE PIC X(20).01 TITLE-I PIC S9(4) COMP-5.It is guaranteed that only NULLs will be inserted into the table (i.e. COBOL variable TITLE will never contain a ...

Sort by column click

I have been able to create a table pulling data from a mySQL database, and have the sort hard coded into the script. What i want to do is allow someone to click the column title and have it sort by that one instead.Below is my current code, any help would be great. Thanks<?php$Host = "localh ...

Unknown column ??

I uploaded a script for displaying information I've entered into my mysql database, and I'm getting the following error: Unknown column 'title' in 'field list'I've double, triple checked the script to make sure that title exists and is spelled correctly. Does anyone know why this would happen?Here's ...

How to link from one row column to other columns

I need to solve this question. Lets say I have table new with columns id, title, text, date.I fetch one column:while ($row = mysql_fetch_array($result)) {echo $row["title"].'<br>';}And now I need to make link from column 'title', that when I click on it, I can see 'title', 'text' and ...

updating column leaves it blank.

there, just joined this forum hoping to find some light to this problem. I am very new at php and trying my best to learn it.Here is my current problem. I have a form that updates one column in a table named 'title'. But when I submit the form, it leaves it blank. Here is the php.session_start();req ...

column text help

I am recently new to DXL. I am attempting to write a simple script to alter the text displayed in a column identified by the specific column title. I posted my code below. Can someone tell me why >display "here" does not actually write that text in the column?-----------------------code---------- ...

How to determine the attribute being printed in a column?

A column can display a DOORS attribute, the main column (object heading/text), or Layout DXL. Is there a way to determine that the column is displaying an attribute, and if so, what the attribute is? I am trying to identify a column that has Object Heading, which is not the main column and does not ...

Oracle Can't get Report Column Authorization to work

I have created an authorization scheme and I've applied it to Pages, Regions and it works like a dream. But when I try using the exact same authorization on a report column it has not effect whatsoever. I'm very frustrated with it . Am I right in assuming that the single column should disappear when ...

Oracle HTML DB Chang column name dynamically

Can I change the column name dynamically. for instance Today run my apply it will display the title of the columns thisColumn title: Wed Thu Fri04/22/05 04/23/05 04/24/05 Data 45 34 3454 56 23Next weekColumn title: Wed Thu Fri05/03/05 05/04/05 05/05/05 45 34 3454 56 23The date Change Dynamically? ...

Oracle Adding Date to Column Header

HiI'm having some issues getting a date into a column header for a tab report I am creating.this threadhttp://forums.oracle.com/forums/thread.jspa?messageID=932994suggested using a hidden item and having a pl/sql function body and including the item in the header.So I set the Column title up with "O ...

Oracle Show/Hide long column Titels?

is there a solution to show/hide long column headings?My Problem is, that I have a report with nearly 15 columns and every column title is nearly 30 characters long....So the report is very broad.My idea is, that the column titles are shortened (i.e. the first 10characters) and when you click on the ...

ClistCtrl multiline column header

I want to display a string of words as column title inside the header of a CListCtrl control's column. This is the top row of the column.Since the string has severals words, I want each word to go to a new line within the same columnheader.Please advice.Kind ...

How can I change Title for each columns in DBGrid

Do you know how can I change column title in DBGrid. I try with DBGrig1.Columns(1).Title = "New" but I received this error "Object doesn't support this property or method"Who can help me. ...

Oracle Make Interactive Report column header span two columns

How can I modify the header on an interactive report so that one column title can span two columns? I.E. column A and column B have different values but have the same column header of "A plus B" ...

Oracle Searching for Data in the Report for a non-selected column in display.

I have an interactive report as given below:select user, dept_name, sal, description, title from hr;Now, in the report display options I remove the title and description from the display as you know title and description are 2000 characters each.If I show then it takes the whole page to display one ...

Oracle Standard column sort does not work in report

I have Apex 3.1.2 on Oracle 11I installed Demo application "Document library v.0.93" from Apex site in my laptop.Page 1 Region Tasks ->Column TitleRegion Documents 0>Column Document Standard sorts bottoms in the regions do not sort of Titles or Documents correctly if in the source region of re ...

Oracle Report Region Title Font Size

I'm trying to get the column titles to appear with a smaller font size. I have gotten the data displayed using the CSS Class 'tiny', but this doesn't affect the column title.Any ideas?Jamie ...

Oracle Conditional display column using javascript and css

I have a manual tabular form using collections. Sometimes 3 columns (Name, Amount of Loan, Terms of Repayment) are displayed and sometimes 6 columns (Name, Address, Name of Person Security the Loan, Original Amount, Current Balance, Purpose) are displayed depending on an application item. All fields ...

Oracle Column sort and pass parameter

Is it possible, in tabular form, using the "sort" option to add a parameter to the column title link? ...

How to adjust fileds in list footer with all columns of the list?

said: I'm using Cognos Report Studio 8.2. 1) I have a list with 25 columns. I use list footer in which I put totals calculated manually. I would like to ajust automatically the fields in list footer with all other 25 columns of the list. how can I do that?2) how can I write column title in 3 lines? ...

jQuery Looking for a particular plugin for table scrolling.

I've tried googling and searching wtihin jQuery, but can't quite find what I'm looking for, so possibly someone here has heard of this.What i'd like, is for a table to be populated with data (as shown above with random data), but have the viewable area of the table just remain a section of it, indic ...

jQuery jqgrid colspan and rowspan plugin for table header or table row.

Colspan and rowspan is hard in jqgrid plugin. we' often have to be merged table header in project for customer.In the following code, we achieved merge table header, that colspan and rowspan.But the code is not optimized,if you have an good idea, please improve it,thank you./**  jQuery tui tabl ...

How can create heading and format cell text in excel?

i writing excel file by two diffrent ways.1. write (*.xls) excel file by odbc driver2. write (*.xlsx) excel file using excel automationits working fine.i want to create heading in first line and want to format the column title text.please tell me how can i do this. ...

Sphinx or Sphinx SE

I have one table with 90 millions row and growing 1 millions rows per 3-5 days.I run indexer delta --rotate AND indexer --merge main delta --rotate each 3 hours.The merge process take 30 min.I would like to know if it's not better to create One table using MySQL storage SphinxSE ?How can i make my t ...

Getting chart data to work within a function

all i am in need of some help trying to figure out how to pass a string into an array field for a chart. The chart i am using is this [http://www.highcharts.com/]Here is the chart code:function drawChart(theDATA){var chart = new Highcharts.Chart({chart: {renderTo: 'container',defaultSeriesType: 'col ...

Slow script errors caused by jQuery.fn.extend.find

I have a form that is dynamically constructed using JSP.  It creates a spreadsheet-like table where the user associates a row with a column by clicking a radio button.   It's possible that there may be up to 400 rows and 50 columns, making the table unwieldy.  (For example, the row an ...

how to hide a table if my table listing no property?

i create a list to display record inside the table. If i wanna hide my table in case the list no any record. What statement should i add on? i may using <c:choose> ?<tr><td colspan="3"><fieldset><legend>CSC Listing</legend><table><tr><td c ...

MySQL Alter text in Cell

Hi, I'd like to know how I can alter the text in a cell in a table. I know that I can alter a whole dataset by using update database.table set column = "what a test" where id = 2; But what am I to do if I want to replace a part of the text in a cell i.e. if I want to replace the word ...