COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: angryman on 07 Nov 2005 01:50:10 AM

Title: How to add New Customn Column
Post by: angryman on 07 Nov 2005 01:50:10 AM
How to add new customn column on the run without using calculate function.For eg i have to add a new column to the existing report say "Revenue" as column name
Title: Re: How to add New Customn Column
Post by: BIsrik on 07 Nov 2005 02:25:05 AM
3 questions to u..

1) where r u seeing the report...in query studio or report viewer..( i think it should be report viewer)
2) Is "Revenue" column is from database???
3) Why r u angry??

Srik
Title: Re: How to add New Customn Column
Post by: angryman on 07 Nov 2005 03:54:31 AM
i have 4 answers for ur 3 questions...

  1. I am still in the creation of the report..(it's in query studio)
  2.  Revenue is not the column in the database
  3.  I am not angry
  4.  I tried out many user names it was already there..so finally created this id.
Title: Re: How to add New Customn Column
Post by: BIsrik on 07 Nov 2005 04:27:14 AM
i feel calculations are the only means to achieve this at the query studio level...

Srik
Title: Re: How to add New Customn Column
Post by: angryman on 07 Nov 2005 05:44:13 AM
Thanks for ur replies..

Is it possible in report studio if not where else...

can we do something with framework manager?
Title: Re: How to add New Customn Column
Post by: BIsrik on 07 Nov 2005 07:17:08 AM
but u said it has to be a custom one...In FM again u can create a calculated column in the QS and display to user as a QI..but how will it satisfy ur "Custom" Requirement...

Srik
Title: Re: How to add New Customn Column
Post by: Cognostradamus on 07 Nov 2005 12:58:09 PM
It would be helpfuld to understand what it is that you want to do with this custom column.  Are you just wanting to rename a column, are you looking for it to be calculated from other fields, or is it something you just want to leave as a blank column in your report?  BTW--don't feel bad about being angry. 
Title: Re: How to add New Customn Column
Post by: angryman on 08 Nov 2005 02:36:11 AM
hi,
    I said custom on the lighter sense...it's right that if u go for FM also it won't be "Custom" Requirement..
I would rather leave as a blank column in my report..So how to go abt this ?
Title: Re: How to add New Customn Column
Post by: Cognostradamus on 08 Nov 2005 08:40:19 AM
As best as I can tell, there is no method within Query Studio itself to create a null column.  I'm certain that you could create a column in Framework Manager that displayed no value.  Would that satisfy your requirement?