If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Hiding items displayed ina report

Started by nfldbunker, 09 Oct 2009 08:53:44 AM

Previous topic - Next topic

nfldbunker

hi everyone

I have a report which contains certain query items which i do not want to display in the report output but are used to pull inthe required data. Is theer a way to hide certain columns that are currently on a report to invisible.

please advise

bunker

CognosPaul

You'll need to be a bit more specific, what kind of objects are you using? How exactly are the data items being used?

A common issue is trying to build a drill-through based on an item that isn't included in the object. Is this what you're trying to achieve?

In the properties pane of the object, on the left hand side of the screen, there is a row named "Properties". Click on the ellipsis (...), and select the items that you want. The properties forces Cognos to include a specific data item in the SQL generation on runtime. If an item isn't referenced there, nor anywhere else in the object, Cognos won't include it to increase the efficiency of the query.

nfldbunker

hi

i have some items in my report but i want to make these invisible to the end user who runs the report.
I had a discharge date as a prompt thanksbut dont want the date visible to the end user. if i remove the item from the report it changes my results i just dont want it visible

thanks bunker


dumbell

As Paul says just check that date field in 'Properties' that you get when you select list from ancestor pane

OR

Select the date in the list and cut it not delete. It works the trick.

Let us know if you resolved the issue

nfldbunker

hi thanks

ill check and let you know. i was alwways deleting the item from the report.

bunker

jahnavi

Hi,

If you want the effect of the data item in the report like sorting or some thing ,select the data item and set the box type to none. or otherwise cut the data item as suggested