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
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.
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
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
hi thanks
ill check and let you know. i was alwways deleting the item from the report.
bunker
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