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

    Print Group on new page if insufficient lines on page

    Thank you for the replies, but I had already done that. Within my report there are many occasions where the group is split across a page. example: group header Detail Detail New page Detail group footer Please note Keep Together is set in group header, detail lines and group footer...
  2. caymanuser

    Print Group on new page if insufficient lines on page

    Just checked the Keyword Search but could not find an answer to my problem. I want keep a group together and not split it across a page. Therefore can I check how many lines are available on the current page and compare this to the number of lines required to print the group header (1 line) plus...
  3. caymanuser

    SELECTING A DBF FILE WITH PARMATER

    Each monthend we create a DBF file with client holdings as at that date. The files are named HLD0309.dbf (for Sept. 03), HLD0212.dbf (for Dec. 02)etc. Question. How can I select the appropriate file with a parameter. i.e. Year_mth 0309 would select the above file. Thanks in advance.
  4. caymanuser

    Date Parameter Printing

    Many thanks, It worked
  5. caymanuser

    Date Parameter Printing

    Data is selected based upon a number of discrete dates entered via a parameter {?Dater} The selection works fine.I have the following formula to print the dates entered. NumberVar Counter; StringVar Message :=""; For counter := 1 to Count({?Dater}) Step 1 Do (Message := Message &...
  6. caymanuser

    Multiple dbase files

    Thank you I will try that later today.
  7. caymanuser

    Multiple dbase files

    Thanks for the reply. No they are different structures. The first file contains summary data I want to include with every record from the second file.
  8. caymanuser

    Multiple dbase files

    I have have two dbase files I want to read consecutively. i.e. read the first file store the data in numbervar's. then read the second file. How do I get crystal to know there are two files to be read in this manner. Thank you in advance.
  9. caymanuser

    Storing data to be printed later

    I have a single dbase file where the first ten records contain performance data that is to be printed on each statement utilising data from Record 11 and onwards Therefore every statement would show as below: Total gain/loss - from record 1 Interest - from record 2 Total gain - from record 3...
  10. caymanuser

    Excel and SQL DB in the same CR

    I have an excel file were the first column is the matching key i.e. CO1234, TP0004, TR6543 etc. The excel is being read via an ODBC driver into CR. When I try to match with the appropriate field the SQL DB I a "different size" warning and the fields from excel are blank on the report...
  11. caymanuser

    Printing a Parameter Array

    Many Thanks, That worked fine, had to add a "ToText" Best Regards
  12. caymanuser

    Printing a Parameter Array

    I have read review every forum question but cannot find the answer. Part of my selection of data is a parameter field {?account}this is numeric and can have multiples values generally upto 5 or 6 occurances i.e. 1001, 1002, 1340, 2005 or 9999 for all accounts. Selecting the required data works...
  13. caymanuser

    Parsing a text file

    Howard, Many thanks, it worked Regards
  14. caymanuser

    Parsing a text file

    Howard I am not the originator of this message, but have a similar problem. I need to read a pure text file as data (Not comma delimited in fact it is "SWIFT" messages) I can handle the reformatting but as it is not a database what instruction do I use to "get it into" CR...

Part and Inventory Search

Back
Top