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 Wanet Telecoms Ltd 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. HughFreiden

    BLOB data - PDF or Doc (text) - in Crystal Reports

    Crystal Reports 11+ only supports the displaying of BLOB data fields when the data type is an image(jpg, etc). Does anyone know of any work-around, utility, formula, etc. so I can display/print a PDF or .Doc type data stored in a BLOB field type?(text format)? Perhaps using a SQL query? Hugh
  2. HughFreiden

    combine like files

    Is there a way in Crystal 9.0 to combine similar files. For example I have a current and a history file and the data fileds are exactly the same in each. Linking from one to the other causes many problems from my report. I Know I can build a sql query throurh Crystal 8.5 SQL Designer using...
  3. HughFreiden

    export loses subreports shares data in main report

    When exporting to any file, excel, msdbase, etc., those report formulas that link to shared subreport data fields export as zeros. why, how can i fix? thanx
  4. HughFreiden

    Linking Error

    I tried to link to 2 files in Crytal SQL Designer. I get the message: ERROR CREATING LINK I tried linking the files in Crystal Report Writer and I got the message: FILE LINK WARNING: THE SPECIFIED FILE MAY NOT LINK SUCCESSFULLY DUE TO A DIFFERENT TYPE . They are both employee files. The...
  5. HughFreiden

    Link Error from dif OBDC data sources

    I tried to link to 2 files in Crytal SQL Designer. I get the message: ERROR CREATING LINK I tried linking the files in Crystal Report Writer and I got the message: FILE LINK WARNING: THE SPECIFIED FILE MAY NOT LINK SUCCESSFULLY DUE TO A DIFFERENT TYPE . They are both employee files. The...
  6. HughFreiden

    combining like files

    I have multiple files of the same data. The files were created by software that seperated companies by files rather than codes in a record. For example the Employee master file (empmstr) is EMPMSTR01 for company #01 and EMPMSTR02 for company #02. Is there a way to temp combine these files...
  7. HughFreiden

    How modify Select statement to skip ad'l/duplicate recs

    Is there a way to have the select statement use only the first record of a left outer join. Perhaps a sequel command? I know you can suppress detail lines and/or use running totals. However for various reasons this will not work in my complex report. Perhaps a sequel command? PLEASE...
  8. HughFreiden

    Rid of duplicate records in one-to-many (recs 2-??)

    I have a SQL left-outer link. However I only want the first record found in the selection query. How can I "skip" over the remaining matching records in the Select Query? THANX
  9. HughFreiden

    mulitple level subreports

    Is there any procedure (trick) to have multiple Level (2 levels) subreports? thanx for the assistance.

Part and Inventory Search

Back
Top