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

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

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

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

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