Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Devasto

    zooming in cognos (drilltrue?)

    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...
  2. Devasto

    zooming in cognos (drilltrue?)

    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...
  3. Devasto

    zooming in cognos (drilltrue?)

    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...
  4. Devasto

    zooming in cognos (drilltrue?)

    and could i use an alias in the Framework manager? so it would know i meen a certain data item with a alias i specify in FM?
  5. Devasto

    zooming in cognos (drilltrue?)

    FM definition?
  6. Devasto

    zooming in cognos (drilltrue?)

    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...
  7. Devasto

    zooming in cognos (drilltrue?)

    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...
  8. Devasto

    zooming in cognos (drilltrue?)

    awesome it works thanks :)
  9. Devasto

    zooming in cognos (drilltrue?)

    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] =...
  10. Devasto

    zooming in cognos (drilltrue?)

    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...
  11. Devasto

    zooming in cognos (drilltrue?)

    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?
  12. Devasto

    zooming in cognos (drilltrue?)

    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?
  13. Devasto

    zooming in cognos (drilltrue?)

    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...
  14. Devasto

    zooming in cognos (drilltrue?)

    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...

Part and Inventory Search

Back
Top