Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Paul12345671

  1. Paul12345671

    WriteExcel error message - file too big

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

    Variable selection criteria?

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

    Connecting to an Oracle 9i server from Excel

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

    Connecting to an Oracle 9i server from Excel

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

    How to I tell what version of the RTF spec MS Word is using?

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

    How to I tell what version of the RTF spec MS Word is using?

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

    Reporting from log file where status has been 'active' some time.

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

    Reporting from log file where status has been 'active' some time.

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

    Crystal Reports Freezing

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

    Crystal Reports Freezing

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

    Crystal Reports Freezing

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

    Crystal Reports Freezing

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

    Pivottables - how do we filter on a date RANGE?

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

    Crosstab - row formatting question

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

    Unable to display different relationship types in different columns

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

Part and Inventory Search

Back
Top