Joe: Create your cursor to match how you want the report to look. Have a field to 'group by' in the report; when the day changes the next report is printed on the next page; look at the data grouping section of the report To shade: set a variable to count and have 2 rectangles on the data line of the report and by using the print when clause it will pick what rectangle to print like this: I use a global variable gbOk_to_shade to let the user decide is they want shading or not on the print form non shaded rectangle print when: (((gbOk_to_shade and (i/2) <> int(i/2)) or (not gbOk_to_shade) ) and not empty(p_note)) shaded rectangle on top of the non shaded rectangle: gbOk_to_shade and (i/2) = int(i/2) This should be enough to get you started! Best regards, Jack
Jack Skelley Senior Director, Programming/Computer Operations New Jersey Devils (973)757-6164 [email protected] Disclaimer added by CodeTwo Exchange Rules 2010 http://www.codetwo.com ________________________________________ From: ProfoxTech [[email protected]] on behalf of Joe Yoder [[email protected]] Sent: Wednesday, April 02, 2014 4:21 PM To: [email protected] Subject: Help with report writer 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? TIA - Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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/7d9e7f72b813014c8fd022cf04f820edee0eb...@ex08.drdad.thenewarkarena.com ** 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.
