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...
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} +...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.