Search results for query: *

I have the following example XML data <Atd_Order_Row_Data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Dealer_Export_Non_Billed> <Targets> <Target>Fish 4 Cars</Target> <Target>V Cars</Target> </Targets> </Dealer_Export_Non_Billed> <Dealer_Export>...

Reports are created using CRXI connecting to a SQL 2000 database Can anyone tell me how I change the datasource type for a report at runtime. If a report is saved using an ODBC datasource how do I change the report to connect to the db using an OLE DB connection at runtime. TIA Gary Parker...

Hi folks I've been away from the Crystal forums for a while, but should be able to contribute more regularly once again. I'm attempting to design a Standard form for Crystal Report Development/Amendments and rather than re-inventing the wheel I thought I'd chance my arm and see if anyone here...

Does anyone know of any good Cognos resources in India, we are looking to build a Cognos BI team in Chennai India to work on Cognos 8. Gary Parker MIS Data Analyst Manchester, England

I have a Windows 2003 server running Terminal Services. The problem I have is that users can not use Remote control I have added the users to the Remote Desktop users Group and then followed the help files Open Terminal Services Configuration Open the connection properties On the permissions...

I have a profitabilty report where I have summaries at a number of different levels i.e. Licence 80 Training 75 Third Party 100 Total revenue 255 Charges (40) Expenses (60) Total Costs (100) Gross Margin 155 What I now need to...

hey just found out i've been offered a new job. Just waiting for the contract to come in the post for my consideration. Has anyone had any dealings with a company called ISOFT, got any inside information. Gary Parker MIS Data Analyst Manchester, England

Can anybody help me with this one ? I have a view on the db which displays the relative year and period form a calendar table for todays date CREATE VIEW dbo.Calendar_Financial_Period AS SELECT [Date] AS [Todays Date], [Financial Year] AS [This Year], [Financial Year] - 1 AS [Last Year]...

Hi folks I have an Excel lookup table that looks something like this Quantity Cost/000 10,000 30.15 25,000 27.50 50,000 26.66 100,000 26.25 250,000 24.54 500,000 24.01 750,000 23.82 1,000,000 23.71 What i need to do is, when...

I am contemplating upgrading my installation of IWR and PPES from V7.3 MR1 to V7.3 MR2. Has anyone else upgraded to this version yet ? Gary Gary Parker MIS Data Analyst Manchester, England

Does anyone use the superoffice CRM package ? and more importantly does anyone have an Impromptu catalog created for this db that they wouldn't mind sharing. TIA Gary Parker MIS Data Analyst Manchester, England

Some of you may have alreday seen this in the latest BO newsletter, I thought it was neat so thought I'd share it with the others. How to auto complete partially-typed function names in the Formula Editor: In the Formula Editor in the Crystal Reports Designer, how do you get partially-typed...

Having set the daylight savings time is in effect checkbox, I notice that the modified date for scheduled reports in IWR and newly published cubes in PPES are showing a modified date of 1 hour in front. all components Upfront, IWR and PPES are 7.3 how do I get the change to take effect and get...

Is it possibel to take a cluster resource offline and bring it back online using a batch file and vbscript ? Gary Parker MIS Data Analyst Manchester, England

I would like to change the title value of the upfront login page "Cognos Access Manager - Login" this is the name value when you add the page as a favourite to your web browser. I am using upfISAPI.dll gateway which calls login.cgi. Do I need to edit a specific file or is this a configuration...

Is anyone using Impromptu Admin 7.3 yet. When I install the software i amonly able to open reports and catalogs once. on any subsequent attempts to opena catalog I receive an error message "Out of Memory" (Even after a reboot) I have tried a number of good spec PC's running XP with 256 - 512...

Quick and easy one to get the grey matter going. How many different letter combinations exist that can USE each of the five vowels to create a new word e.g. PAT PET PIT POT PUT I came up with six in about 2 minutes but i'm sure there are many more out there Gary Parker MIS Data Analyst...

I have accidently deleted a DTS Local Package. for Future reference is it possible to backup and restore these items ? Gary Parker MIS Data Analyst Manchester, England

I'm new to DTS and not sure of the best way to tackle this one. I am attempting to import data into SQL2000 from an archaeic flat file database on UNIX. The import will run each night and needs to pick out unallocated records and records allocated in the last 14 days. I created a DTS package...

Using CR9 Developer edition with Sp3 reporting from an obscure flat file system on UNIX. I have a fairly complex report using multiple linked tables containing 4 levels of grouping and 8 linked subreports to show different views and calculations of the same basic data. The reason I have to use...