Search results for query: *

The title possibly makes this sound more intriguing a problem than it is. I just want to loop through a string, inserting spaces every other letter, so that instead of reading: THIS IS MY STRING it reads T H I S I S M Y S T R I N G I'm using CR2008 on Oracle 10. Thanks

Hi, I'm trying to run some pl/sql which is returning the above error. I'm not much of an oracle developer, and I'm just trying to resolve this issue in our programmers absence because it's an live problem. The bulk of the code is essentially populating the ListingData table below, but I think...

Hi, Xtal XI How do you turn this one field (contains no carriage returns): <?xml version="1.0" encoding="UTF-8"?><qobject><type>QObjectVTIEpisode</type> <created>2008-05-15T14:06:19</created> <properties><episodeid>112806</episodeid> <programmeid>1105133</programmeid><contentref>...

Hi, I'm in a real panic here. I was running some procedures on my server, none of which were completing. So, after killing off some heavy processes on the server, and doing some general housekeeping, I rebooted the server. The procedures would still not complete, when before now, they would...

Hi, In Enterprise Manager, how do I call up a list of scheduled DTS packages. I want to be able to edit or remove jobs without deleting and recreating the entire package. Thanks

Hi, How do I join these two tables accurately? I have three records in the FORECAST table: Customer Product Wk04 Wk05 Wk06 ----------------------------------- TANDY PLY001 4 3 2 ULYSSES FEV999 5 2 1 NEWGUY RUF101 9 and I want to join...

Hi, How do I join these two tables accurately? I have three records in the FORECAST table: Customer Product Wk04 Wk05 Wk06 ----------------------------------- TANDY PLY001 4 3 2 ULYSSES FEV999 5 2 1 NEWGUY RUF101 9 and I want to join...

Hi, Can you help me figure this out? I have a table which looks a bit like this: TABLE_A Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 ---------------------------------------------------------------------------- 800 UK ACCESSORIES PPM9572 Not assigned 200225 IN02 50 800 UK...

Hi there, I have an XI report on SQL Server, querying a rolling years worth of data. I'm really only interested in this calendar year for about 95% of the report, but there are two or three columns where I have to work out year on year growth and things like that, which require doing...

Hi, I installed XI on a remote server and wanted to replicate the reports, instances and schedules from my local server. So, I copied the Filestore directory, containing the Input, Output, and Temp dirs from the source server, and overwrote the target Filestore dir. But the reports do not...

Hi, I have a SQL 2000 server and another server in a remote location. What is the most sensible way to duplicate the database on the local server and send it to the remote server? At the moment, I'm sharing the directory with the local backup, and mapping from the remote server and restoring...

Hi, I'm using BO XI 2 on SQL Server. I have published a Crystal Report object which uses dynamic and static parameters. In the CMC, I can see and assign values to the parameters. However, in Infoview, if I attempt to schedule and expand the parameters, I get the following error: An error has...

Hi, I'm fairly new to SQL Server, and I'm using SQL Server 8. I was wondering if someone would be able to take a look at this with me. I have two tables TSRDB and TSR_LY. TSRDB is the driving table, containing customer and sales data for one fiscal quarter. TSR_LY does the same thing, but...

Hi, I don't seem to have very much luck with anyone responding to me when I post. I hope if I try a different approach, I might be able to get better luck. I'm using Crystal Reports XI release 2, and I would like to order my report by the desc sum of a group total. GH1 - suppressed GH2 -...

Hi, Is it possible in CR XI to hyperlink or otherwise navigate to somewhere inside a subreport - like, for example, if I want to go straight to the 3rd group and 3rd page of a subreport, whilst still on the initial page of the main report?

Hi, I have a XI report which I've created to act like a data dump. A total of one of the columns is 1,507,245. When I export to excel 2003, this total becomes 1,507,209. The report has 5 groups, and all the data is placed in GF5. All other sections are suppressed. Why might this be...

Hi, I have a script which, depending on the week the job is bring run, will update a different column. declare @varcol varchar(10) declare @ex varchar (200) SELECT @varcol = (CASE WHEN LoadWeek = 1 then 'week01' WHEN LoadWeek = 2 then 'week02' WHEN LoadWeek = 3 then 'week03' WHEN LoadWeek =...

Hi, This is my update statement in SQL 8: update my_table set sales_district_id = (select salesgroup from my_other_table where my_other_table.salesid = my_table.sales_id) The trouble is that the my_other_table does not contain all the sales ids that my_table contains. So, using it as a...

Hi there, I have a report which is, frankly, massive. The only way it can be successfully utilised is to drive it by the group tree on the right. The trouble is, when I export this to pdf, Adobe replaces the group tree with it's own page preview navigation thing, which is useless. Is there a...

Hello, I'm using XI on SQL 8. Basically, I just want to know wtf is going on here... I am running a report that is based on the following: selection criteria: not isnull({productmastertable.product}) using two tables linked on keys grouped by country, sales group, product data displayed at...