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!

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

Search results for query: *

  1. EarlGray

    getting around 256 char limit

    There's a couple of ways to do this, but they'e all a little tricky... if I read your posts correctly, you're (in effect) creating a 'spreadsheet' of width 20 columns and n rows. If THAT assumption is correct, let e know.. we can look at a couple of options from there. ECS DataSystems, Inc...
  2. EarlGray

    Scheduling Reports

    Sure... a VB solution would work nicely - and it would be a elatively compact scheduler for you. Once you've defined the reports and the schedule time, it would be a relatively straightforward app to call the report up (off the system time) and 'run' it... ECS DataSystems, Inc. www.ecsdata.com A...
  3. EarlGray

    VB installation Problem

    Also, check that the DATABASE | SET LOCATION is set to SAME AS REPORT. Also VERIFY ON EVERY PRINT should be set. ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  4. EarlGray

    Not Enough Memory

    You may be having a TEMP file, or Swap file problem... if you are creating a signifiant graph OR there is a ton of data manipulation, this might occur... ENSURE your TEMP folder is cleared of ancient .tmp files; ensure that you have at least 20% available space on the drive. If necessary, open...
  5. EarlGray

    Problem linking 2 tables

    Try changing the = to a LIKE: Tablea.Field : Tck_Code = 1TQ Tableb.Field : Tck_Code = 1TQ7005FR Select Formula: Tablea.Field LIKE Tableb.Field + * The LIKE should pick out any 1TQs you might have in Table B ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  6. EarlGray

    ora-01002: fetch out of sequence

    Check out http://technet.oracle.com/support/bboard/content/647.htm for info on the ORA error... Also, the ODBC drivers and the P2SODBC.DLL have changed from CR 7 -> 8x. Check the CDecisions website for downloadable updates for Oracle ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  7. EarlGray

    Displaying blob fields in crystal : problem

    There's problem with the ODBC DLL supplied with CR 8 and, concomitantly with the Oracle Native ODBC driver... they have a problem in bringing ion LOBs... You might want to look at the Crystal Decisions site and check downloads for ORACLE. There's a CR Merant ODBC driver which does work well...
  8. EarlGray

    Stupid Question

    I assume you're trying to in CR what you can do in Excel, for example - side-by-side placement of the text. Don't know a way of doing it in 1 report without 'squishing' the report objects (fields, report headers, etc) down to 1 char wide then exporting the whole thing to Excel... ECS...
  9. EarlGray

    combining information from 2 separate reports

    You an group on ID number and place the report names into the detail (which, by the way, is the quickest way to view stuff in development). This will give each document its own 'line' in the detail - but won't put the combination of docs for a given ID on one record line. Alternatively, you...
  10. EarlGray

    Is this possible in crystal report 8? **** URGENT*****

    Are you trying to manipulate the data in this field in any way? For example, are you attempting to use this in a formula (which CR won't support) or in record selection? ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  11. EarlGray

    Lost Data When Report Exported to Word

    Uhhhmmm... We're assuming you have the long text field formatted to 'Grow'.... What's the Database you're reporting against? We've had problems with the ODBC drivers in bringing info in; and with the CR export DLLs putting stuff out to Export... Have you checked the CD support document...
  12. EarlGray

    Suppressing a Field in the Page Header

    OK... What type of file (DB) is it? Is the credit in the file a negative (-110.00) or is it a positive amount (100.00) and somehow coded as a CREDIT? That may give you (us?) a clue as to how to proceed. :-I ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  13. EarlGray

    Exporting an .rpt file to powerpoint

    Depending on how the report is set up, you might want to go from CR -> Excel -> Powerpoint. The Excel tables do work nicely in PP....;-) ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  14. EarlGray

    Lost Data When Report Exported to Word

    Which version of Word? 97 - 2000? ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  15. EarlGray

    Is this possible in crystal report 8? **** URGENT*****

    What do you need to do with this text? As long as Oracle will store the RTF data, you should be able to retrieve it, BUT - you will bestoring and retrieving the RTF coding as well as the RTF content AND you won't be able to manipulate, select on, or otherwise use the incoming BLOB in any...
  16. EarlGray

    Refreshing data in Crystal 8.0

    The really haven't seen the anomaly before, and we're updating from CR 4.5 and 6.0! If the ODBC connection is made once in CR, and you go out and open another report using that connection, you won't be forced to log on again... and again... Are you sing different ODBC conections for the two...
  17. EarlGray

    Viewing Report using Info Viewer

    Which viewer is it that you're using? Are you using the Info Viewer that is opened through the Info Desktop for Windows, or are you using one of the web-based viewers? ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  18. EarlGray

    VB5, CR6 and Cannot Find SQL Server with Subreports

    Was the subreport created as a stand-alone then 'imported' into the container report? Or was it created within the container? Is the subreport linked to the container or is it not 'data-dependent) (using a param)?8-) ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  19. EarlGray

    Printing without dialog

    Just prior to the END SUB, add something like this: Result% = m_report.printreport if result% <> 0 then 'Show error in msgbox end if ;-) ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner
  20. EarlGray

    Viewing Report using Info Viewer

    Does this error occur if you page through the report, one page at a time? Or does it only occur when you 'goto' a page? :-V ECS DataSystems, Inc. www.ecsdata.com A Crystal Partner

Part and Inventory Search

Back
Top