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 TouchToneTommy 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: *

  • Users: dfor
  • Order by date
  1. dfor

    Selecting random records in Crystal

    I read the threads copied below. I created a formula RND() and put it into the details section of my report and it returns a decimals starting at 0.00259 to 0.99625. How can I format the field to produce whole numbers for a select statement of Random <= 25? Thanks Dorrie...
  2. dfor

    Dates and Strings

    try selecting a date greater then a date such as Jan 1, if there is null field it won't be selected. You can then do your calculation with valid data.
  3. dfor

    Summary Report and Detail Report.

    If the recipient of your report has Crystal Viewer and you publish the report in a Crystal format, they will be able to drill down into your report. The view launches rather slowly, but once opened provides what you want to see. You can download the Viewer free from SAPs website.
  4. dfor

    Why my formula not working!?

    I'm not the greatest at this stuff, but maybe one of these will help you. If you use: ({foccredsum.date_created}) in LastFullWeek it will select dates from last week, Sunday to Saturday. or ({foccredsum.date_created}) in LastFullMonth to select all dates last month or {foccredsum.date_created}...
  5. dfor

    create a date/time field from two fields date/time &amp; time

    I guess I need more help than I thought. I added my table (see below) and when I check the formual, it asks for a number in front of ctime. stringvar x := '08.30'; //replace with your string time fld numbervar hr := tonumber(x[1 to 2]); numbervar mn := tonumber(x[4 to 5]); {PDDL.DATESQL} +...
  6. dfor

    create a date/time field from two fields date/time &amp; time

    I mistated the data type for the Timesql field. It is a string. Thx
  7. dfor

    create a date/time field from two fields date/time &amp; time

    Using Crystal 8.5, I am trying to query events logged between two dates (datesql) and between two times (timesql); e.g. June 1 @ 08:00 to June 2 @ 07:59. Datesql is a date/time field that does not capture any associated time value. Timesql is a time value like: 08:30 I thought if I converted...

Part and Inventory Search

Back
Top