dont got it to work yet,
I have build the Query Subject and joined it to my Facttable, published it and created a textboxprompt on it, package item = return item of the query
and the target query = my basic query,
wenn i run the report no errors,
wenn i put part of a word in the field i get...
Ties,
Could you specifie the steps i will need to take?
So far i created a basic query subject but it now generates the basic code, but were do i add the union code?
so once i added the basic query subject i republish my package so it can be used. Will i need to add this query subject to my...
using aliasses in FM worked fine,
Now the next problem.
I want to add a textbox prompt to my report, so its possible to search for a keyword. but i will need to give in a package item, wich will result that when you search only the selected columns will be checked for the keyword.
Instead i...
oke so we could talk dutch if needed, but lets keep english for now so others will be able to read this :)
At the moment ive got the reports and wenn you run it for the first time it will show the value prompts with the field names,
Can i change these names into for example 'Alles...
i cant edit posts on this board?
O well i got another small Q.
in my reports iam using several Value Prompts
but the Wenn you run the report it will show the value prompt box with the name of the datafield (as this selection also stands for ALL results, can i change this name to something else...
sorry for the late reply ive been having a really busy weekend,
Let me refraze the Question,
I have some Data shown in my report wich is good, but there is one value i do not want to show, what way do you write expressions in Cognos?
i was thinking about something like
IF [DATUM] =...
already found it was simple indeed :)
thanks.
next problem:
in one of my reports i want to return an end date easy :)
but wenn the record is empty and it doesnt contains an end date my dwh will automaticly enter 1-1-9999, now i want to edit my expression so it will always show the end date...
my current report is a list and i want my document id replaced by and image, but this must be for every record does that work the same as a drill-through image without multirecords?
ive managed to create a nice drillthrough :) and it works fine, now the next Q. has come up, as the hyperlink iam using a document ID as this is a ugly and long ID i would like to hide this one and have it replaced by a small icon is this possible so the icon will become the clickthrough?
first of all thanks for replaying,
iam starting to get the picture of drillthrough and drill up/down, and indeed for the first raports i will need to build i will juse the drillthrough option, gonna try it this afternoon.
i also have another question if you think about the drill up/down you...
ive been searching for some time now for a way but so far i havent been succesfull. i know that within cognos you can drill in your data, like going from day to week to month ect.
But is there wat to drill? or more exactly focus more on a specific data?
For example, when you have a report that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.