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 Rhinorhino 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. Netpear

    Subreport Question

    The subreport is a report that lists all positions in a hospital by department. The subreport has 2 fields available and authorized fte. These two are divided to get a percentage and that percentage is then pulled into the main report. There are 40 different queries that will give us a...
  2. Netpear

    Subreport Question

    I am currently using Crystal 10 to access data off a sql server. The main report is a quaterly summary report based of HR staatistics and will need statistics from a Second report that has unrelated data. This 2nd report is queried 40 different ways to get 40 different statistics off a...
  3. Netpear

    Bad Date Format String Error

    It works!! Thanks a million.
  4. Netpear

    Bad Date Format String Error

    The Min for Lpadt1 is 0 and the Max is 12 Month The Min for Lpadt2 is 0 and the Max is 31 Day The Min for Lpadt3 is 0 and the Max is 99 Year
  5. Netpear

    Bad Date Format String Error

    Also, if I rearrange the formula, like this: date({BADPLPP.LPADT1},{BADPLPP.LPADT2},2000+{BADPLPP.LPADT3}) = currentdate-1 I get the error that the year must be between 1 and 9999.
  6. Netpear

    Bad Date Format String Error

    When I use this new formula, I get the error: The Month number must be between 1 and 12. What can I do?
  7. Netpear

    Bad Date Format String Error

    In the select expert, I have these 3 parameter fields and they are all formatted as numbers. {lpadt1} = {?month} {lpadt2} = {?day} {lpadt3} = {?year} Yes, if the year was 89, the formula would read it as 2089, but since those records are not relevant, I can omit those. Instead of having all of...
  8. Netpear

    Bad Date Format String Error

    lpadt1 lpadt2 lpadt3 1 10 1 2 12 2 3 13 3 4 14 89 5 15 92 6 16 3 7 17 7 8 20 8 9 25 99 10 31 98 They...
  9. Netpear

    Bad Date Format String Error

    I still get the exact same error.
  10. Netpear

    Bad Date Format String Error

    I'm running a report on Crystal 10 that lists all accounts on a daily basis. The admit date is based on 3 fields, Date1,Date2 and Date3, which represents the month/day/year. I currently have 3 different parameters; month, day, year, that is prompted to the user each time the report is run...

Part and Inventory Search

Back
Top