Search results for query: *

Hello, I'm using Spreadsheet::WriteExcel to create a large Excel Spreadsheet. However, I get the error message: Maximum Spreadsheet:WriteExcel filesize, 7087104 bytes, exceeded. To create files bigger than this limite please install OLE:Storage_Lite. I have Perl (v 5.12.2)...

Hello, I have a report that I'm generating to run in JRC. We have an early version of JRC that crashes if I use SQL expressions, so I'm limited to using formulas. We operate in a state that is broken down into fixed regions. I would like the user to enter a parameter indicating which...

Thanks, guys. However, I do have an entry in tnsnames.ora. It says: HMPS.HS.QFA.COM.AU = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hs-gladiator)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hmps.hs) )

Hello, I'm trying to connect to an Oracle 9i server using Excel 2003 (running on Windows XP). I click on Data -> Import External Data -> Import Data, then double-click '+Connect to New Data Source.odc'. I choose Oracle, then I'm presented with a dialog box requesting a Server name and...

Thanks for your help guys. RTF might be backwards compatible, but I really can't afford to have bits missing - and you're right, having bits missing was the problem. (Actually, this is not really what I would call 'backwards compatible'. But I suppose that having bits missing is as good as...

Hello, I have been having terrible trouble processing an RTF document produced by MS Word via the 'Save As' option (processing is done using library code - not my code). I have (eventually) discovered that the reason is that Word has been using a later version of the RTF specification. I...

Thank you for your advice. It's times like this that I realise how far out of my class that I am here. I worked my way through LB's suggestions, made some minor alterations to account for the deficiencies in my original explanation, and the whole thing works perfectly. Thank you very much -...

Hello, I'm afraid that I've been struggling with this for ages. I'm using CR XI to report from an Oracle 9i database. I have an 'ORDERS' table and an 'ORDERSLOG' table. Once entered, an order will exist permanently in the ORDERS table, but it's status may change in the ORDERSLOG...

The code is simply counting events, but I want to link it to the arrangement table via the eventarrangementrshp, otherwise it simply prints the total number of events in the event table. Paul. (select max("EVENT"."DATETO") from ((event LEFT JOIN eventarrangementrshp ON...

Thanks, LB. However, the subselect does return a single value (at least it should - it's a select count (*) from <tablename> where...). It freezes when I add additional JOINs which I need to further restrict the data that it counts. Otherwise it counts all the records in the table rather than...

I'm using CR XI, and I'm writing the sub-select by: - looking at field explorer - right-clicking 'SQL Expression Fields' - choosing New - writing the code.

Hello, I'm writing a sub-select in Crystal Reports against an Oracle database. I write my first LEFT JOIN, then click the check syntax button and it checks fine. I add my second sub-select, check the syntax and it freezes. It doesn't matter how many JOINS I have, as soon as I LEFT JOIN...

Hello, I've got data displayed on a pivot table, and amongst other attributes, it displays the date. The users will be asking questions like "show me data for the last 3 months", (or the last 3 days or the last 3 weeks or maybe the last 12 months). As it stands, they need to go to the...

Hello, thank you for the help on my previous question. However, I have an additional problem that I'm really struggling with. I have a crosstab in the report header. I would like to produce a report that looks like: Date | Number | Quantity | Units | Sender | Receiver On the advice...

Hello, I'm new to CR, but I'd like to display 3 colums on a report. Sender, receiver, and product. We have 3 tables to describe this: Party, Product and PartyProductRshp. PartyProductRshp has 2 relationship types described in it: Sender and Receiver. A simple version of the tables is...