Search results for query: *

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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