Search results for query: *

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

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.

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.

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}...

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} +...

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

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