Cognos

September 18, 2006 4:05am CST
Hi all, at the moment i'm trying to run a report which totals up all of the products my firm sells and to whom they sell to. This in itself isn't a problem but when i run the report how can i make sure it will give a name to each firm rather than a cell that says Total (company_name)? Another question regarding the same report. I'm also showing both quantity and price of goods sold and when i move it to excel and edit it in the way i want to (as i have been doing but want to automate it all). This means that every other cell has a column border. In my crosstab report is there any way in which i can specify borders to be 'every other' and such like or can i not do that?
1 response
• India
18 Sep 06
Hi, To remove the column name (company_name) and give it a name of your choice modify the query to read select company_name from mytable as mychosenname; that should work !