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

    Looking to limit characters to the field size with no scrolling

    I'm using Acrobat 7 Pro. and created a form using Adobe Designer 7. I have a text field that has space for about 312 characters of 10 Arial (or 4 lines of text) if only text is used, no paragraph/carriage returns, then the spacing is fine. If returns are used it will push the text past the...
  2. spiced

    CR 8.5 Change sort order

    Hello J, I'm using Crystal Reports (CR) 8.5. The link below is a pdf file that shows the result of the subreport. https://secure.filesanywhere.com/v.asp?v=%89ib%8DY%5Fs%A7%9D%97
  3. spiced

    CR 8.5 Change sort order

    I have a subreport that is used to list the six required reviewers (electronic signatures) that have verified the accuracy of the data in the main report, sometimes it is necessary if changes have to be made to have the reviewers reverify. This results in more than six entries. The subreport...
  4. spiced

    CR7, Eliminate duplicate data due to multiple dates

    I need to eliminate duplicate data due to multiple dates when I run a report for actions that took place between 1/1/06 and 12/31/06. I am using an Access based database with multiple tables of which I am using 3 of the tables: 1) Equipment, 2) Event, and 3) History. Fields used in the report...
  5. spiced

    Report & Subreport sent to different printers

    CR7; Can a report be sent to one printer & subreport be sent to a different printer? The first is a regular page report the second is a label sent to a label printer.
  6. spiced

    Eliminate wasted report space

    I want to thank each of you for your suggestions, I've tried all of them with no luck. The detail section will not print information below the top of the page footer even though the space is empty. I tried "underlay following sections" with no luck. Later, SPICED
  7. spiced

    Eliminate wasted report space

    Thank you and it was supposed to be "don't need." The software is Crystal Reports 7. I've tried the format section >suppress blank section it doesn't allow the text from the details section to grow into the rest of the space. There are 4 groups, the Report footer, then the page footer...
  8. spiced

    Eliminate wasted report space

    I have a report with information in the page footer this information only needs to print on the first page; the subsequent pages need to have that information displayed again. The information suppressed on the subsequent pages but the space is still taken up as though the info was still...
  9. spiced

    Exclude record by date

    Ian & LB, Thanks for your help. LB I entered the formula as shown and the report worked. It was also 2 pages shorter. :-) Thanks again, SPICED
  10. spiced

    Exclude record by date

    If I understand relationship between the tables then it would be a common field "Equip ID" that relates the tables. I'm not clear on how to do the grouping. I can group on the Due Date which is what I want. If I was getting just the Due Date range the report would be about 3 pages but...
  11. spiced

    Exclude record by date

    I have a report CR7 report that uses dates from different tables. The first date is the Due Date which is between 7/18/05 and 10/31/05. The second date is the history date with a range between 7/18/04 and 7/7/05. In that history range some units have multiple entries. I want to eliminate the...
  12. spiced

    Substitute a date

    I got the same result.
  13. spiced

    Substitute a date

    I tried the formula in another report and I keep getting an error "Dates must be between year 1 and year 9999". The dates are all in the same format as the other report, any ideas?
  14. spiced

    Substitute a date

    Thanks that worked great. spiced
  15. spiced

    Substitute a date

    I am using Crystal Reports 7.0 and was wondering if there is a way to substitute a date for a range of dates that the report is pulling from a field in the database. I can't add a field to the database with the two dates I want to use. There are two days (the 14th and 28th of each month) that...
  16. spiced

    Differentiate between the # of characters in a field

    Naith, It worked! [2thumbsup] Thanks, SPICE
  17. spiced

    Differentiate between the # of characters in a field

    I'm not that familiar with using formulas, please show me an example of how it would look.
  18. spiced

    Differentiate between the # of characters in a field

    I am using CR 7 and need to be able to be able to pull information on a 6 character entry as opposed to a 4 character entry?
  19. spiced

    Subtotal by Alpha Character in a field

    Just how the final arrangement is going to look. I know I will have other questions in the future, but right now I have a lot of other things that also have to get done. Thanks again, Darrel
  20. spiced

    Subtotal by Alpha Character in a field

    Thanks it's working now I just need to get the format done.

Part and Inventory Search

Back
Top