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!

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

Recent content by sraj1

  1. sraj1

    Changing the Filter Display in Query Studio

    I know how to change for one report at a time.. I am looking for changing all of the report at a time (Batch).
  2. sraj1

    Changing the Filter Display in Query Studio

    Can you elobrate a bit on the Propert change. What property and where to change?
  3. sraj1

    Changing the Filter Display in Query Studio

    Is there a way to change the Filter reference for Query Studio Reports. For example I have a report which pulls data from table A and I want to apply filter on one particular Item. Usually when I apply Filter, Table A is scanned for distinct values and then Displayed under "Pick values from a...
  4. sraj1

    Change URL of reports

    Is there any easy way to change the URL (Link to a package) of reports all at a time for Report Studio without using SDK. We dont have SDK and I have a bunch of reports that were created using old package and now I want all of them to be pointed to the new package.
  5. sraj1

    Cognos Table Info

    Are the model/package information stored in some sort of tables? Basically was wondering to create some report which will give the list of data items and other infortmation used in the package.
  6. sraj1

    Calculate report end time

    So how can we capture the end time for all these in report studio? Can we capture the above mentioned series individually?
  7. sraj1

    Calculate report end time

    Hi, Is there anyway to calcualte or find the report run end time, in report studio? Actually, I can use the "As of Time" to find when the report started and at the same time I want to find the "end run time" of the report.
  8. sraj1

    Is it possible to exclude filtered data from main list?

    Col3(Date) is coming from tableC, but its used in the condition criteria only. This field is not being pulled in the select statement for query2. So when pulling fields from Query2, we have duplicates, but when you actually see at the col3(Date) at the database its not duplicate, it has a...
  9. sraj1

    Is it possible to exclude filtered data from main list?

    Both the queries are pulling the same fields,, except that query2 has additional criteria defined, but this criteria field is not being pulled. Well here is the scenario Query1: Select Col1, Col2 from tableA a, tableB b where a.ID = b.ID Col1 COl2 A NY B CT C DN D DE Query2...
  10. sraj1

    Is it possible to exclude filtered data from main list?

    I did try, but I am getting the result I mentioned above A B D E F Here is the scenario, Query 1 is pulling A,B,C,D,E and Query 2 with couple of additional criteria added and is pulling duplicate records. (Duplicate in the sense, when u pull the same number of fields as query1). (A,A,B,C,D,D,E)
  11. sraj1

    Is it possible to exclude filtered data from main list?

    What will be the result for situation like this... Table 1 A B C D E F Table 2 A A C will the result when using Except be B D E F or A B D E F
  12. sraj1

    Changing cardinality

    Is it safe to chane the cardinality between two tables, from A(1:1)-B(0:n) to A(1:1)-B(0:1), assuming table B doesnt have any fact data.
  13. sraj1

    Date Format in the Report Studio

    You can display you date format in many types. Just set the "Display Day" to NO.
See more

Part and Inventory Search

Back
Top