Joe Yoder wrote:
I want to design a report where there is a separate page for each day of
data. There will be 20 columns of time based data with one row for each
hour in the day.
My code builds a cursor with the data to be reported but at this point I
don't have a clue how to:
- tell the report writer that it needs to start on a record where the
time portion of the datetime field called End_Stamp is 00:59:59
- tell the report writer to do exactly 24 lines or to stop when the
End_Stamp is 23:59:59
- tell the report writer to shade the even rows to make it easier to
read 20 columns
Any help?
As others have pointed out you need to make your cursor match the output
you want, so in this case I would
Create cursor mycurs (dDate D(8),cHour C(2), ...other fields...)
index on DTOS(dDate) + cHour tag datehour
You can pull out dDate and cHour using TTOD and TTOC of your datetime
field. I normally create my cursor
then pull out potential data into another cursor (say tempcur) then
scan && tempcur
m.dDate = TTOD(myatetimefield)
m.cHour = SUBS(TTOC(myatetimefield),13,2)
.... etc
select mycurs
IF SEEK(DTOS(m.dDate) + m.cHour)
* update fields
else
insert into mycurs from memvar
endif
endscan
then put a group in the report on dDate and set "Group starts on new page".
Peter
----------------------------------------------------------------
Rajan Imports has changed - we are now Whispering Smith Ltd. For more
information see our website at www.whisperingsmith.com
Please update your address book with my new email address:
[email protected]
.
This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or
disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd
Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700
Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
