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

    CAM-CRP-1093 Cryptographic Information Error

    We had an issue with Cognos Reportnet last week whereby the ReportNet ContentStore database user had been inadvertantly removed (in terms of access) from the ContentStore database - I added the user again, and went into Cognos Configuration Manager to re-enter the user details - and then clicked...
  2. viRtuAlinsaniTy

    Error Number -239

    sorry if I am being a bit thick, but the tables I am comparing are in the same database - therefore, can they have different collation settings? I was under the impression, with my albeit limited knowledge of SQL, that the collation was set per database not per table. Anyway, apologies if I am...
  3. viRtuAlinsaniTy

    Error Number -239

    Thanks griffindm - will have a look and getback to you Cheers
  4. viRtuAlinsaniTy

    Error Number -239

    I should also add that this only happens in Impromptu Administrator - when you publish the reports to the IWR and browse them through Upfront, they work regardless. Cheers
  5. viRtuAlinsaniTy

    Error Number -239

    Need help with an error please I have two tables - Product Master and Transactions I need to create a report of transactions (Transaction ID, Description and Product) and I want to filter the report based on a picklist of products from the Product Master table. i.e. display a report of all...
  6. viRtuAlinsaniTy

    Record Locking in IWR Server

    Has anyone experienced record locking in SQL Server? We have a web based CRM application pointing to a SQL database, and whenever a report is run on the live database during the working day at my clients, it locks the records it needs which obviously means that the application cannot be used...
  7. viRtuAlinsaniTy

    Nested Drop Down

    Anyone know anything about Nested Drop Downs? I need to use prompts where the first box would say: State: FLORIDA TEXAS etc And if you chose TEXAS, the values in the 2nd drop down would only show you the values that relate to Texas i.e. AUSTIN CITY HOUSTON ILLINOIS etc i.e. the solution i am...
  8. viRtuAlinsaniTy

    Powerprompts ->> rs.Open() Method

    Hi Prasad, Can you tell me what the parameters are for rs.open in powerprompts? if I use them in the same order that you list them then it tells me the Uid is not a valid DB. I asm connecting to SQL & I just want to know where to put the UID & Pwd. Thanks, Hamish.
  9. viRtuAlinsaniTy

    Concatenate 2 different Tables into 1 View

    Gee Thanks - I will give it a try now! :-) Cheers
  10. viRtuAlinsaniTy

    Concatenate 2 different Tables into 1 View

    I am sure this is easy! I need to take one table called "Company" and one table called "Individual" and merge them into one view. The ID for each entity in the respective table uses a unique ID from one system table, therefore this should be possible and without duplicates...
  11. viRtuAlinsaniTy

    Screen Resolution conflict - weird!

    This one is bizarre! Kit: Belkin 802.11g Wireless Network Adaptor Windows XP Pro SP1 + all latest updates (brand new install) Draytek Vigor 2600we Wireless Router/ADSL Modem/Firewall nVidia GeForce4 Ti 4800 SE 128MB - Ver 45.23 Det Drivers GigaByte MoBo GA-8IEXP - 1GB DDR RAM 1x120GB HDD (Sys)...
  12. viRtuAlinsaniTy

    Impromptu Web COM Service won't start

    Unfortunately, I didn't ever get this resolved. The list above of things I tried was not exhaustive, there was a lot more besides, including some of the replied suggestions above also. Unfortunately, nothing :-( In the end, I had no choice but to scrap it and install Version 7 instead, which...
  13. viRtuAlinsaniTy

    Catalog and Reports upgrade from ver. 6 to 7

    When anyone opens a "version 6" report or catalogue in Version 7 - Cognos will say to them "Cognos has recognised this as Version 6 - Do you want Cognos to upgrade this to Version 7 for you? Yes or No?" or something similar. It will then take a few seconds where it will...
  14. viRtuAlinsaniTy

    Change Database in Catalog

    Thanks for all your help guys - I have managed to resolve this issue through re-naming the second item on the right hand catalog folder window of the tables dialog box - that was the bit I was missing! ;-) One other related issue though is that although I can now connect to the "TEST&quot...
  15. viRtuAlinsaniTy

    Change Database in Catalog

    I have a catalog which was built around one database called, say "LIVE". I have copied this database in SQL to create a "TEST" database for testing purposes, and I want to change the catalog to point to the TEST database. I have tried changing the "database name&quot...
  16. viRtuAlinsaniTy

    Impromptu Web COM Service won't start

    I would really appreciate anyones help on this! Trying to install Cognos Impromptu Web Reports Server Version 6 on a FAT32 Win2K Adv Server SP3. No ADS or Netscape Directory Server - I was told none of this should be a problem by Cognos. I select Custom install and de-select Access Manager and...
  17. viRtuAlinsaniTy

    Prompt problem

    Any help would be appreciated! I have created a filter that says &quot;Data is >= FirstSelection and Data is <= LastSelection&quot; and the 2 variables &quot;FirstSelection&quot; and &quot;LastSelection&quot; are created through Prompt Manager. They are both created the same and are both Report...
  18. viRtuAlinsaniTy

    Need help on Catalog Rebuild

    Thanks - I will have a look while onsite tomorrow! Appreciate the help for now
  19. viRtuAlinsaniTy

    Need help on Catalog Rebuild

    My client has Cognos Version 6 installed, and it links to a commercial SQL database CRM application. The guy who built the catalog didn't use the convention &quot;table.field&quot; in the creation of the catalog, and unfortunately it makes for extremely difficult de-bugging for my client as it...

Part and Inventory Search

Back
Top