Oops - sent from the wrong email. One way to do this would be to assign an integer value to all records falling between 00:59:59 and 23:59:59 so that the first day has a value of 1, the next set 2 and so on. You can then tell the report writer to group by the day value and to start each group on a new page. As for shading the even rows, the report writer has a style you can use (I think it's called "Ledger") - the Report Wizard allows you to select from a variety of styles. When I'm designing a report, I usually start with the Report Wizard and tweak the results afterwards. Hope this helps.
Laurie On 3 April 2014 09:45, TWCC Membership <[email protected]> wrote: > One way to do this would be to assign an integer value to all records > falling between 00:59:59 and 23:59:59 so that the first day has a value of > 1, the next set 2 and so on. You can then tell the report writer to group > by the day value and to start each group on a new page. > As for shading the even rows, the report writer has a style you can use (I > think it's called "Ledger") - the Report Wizard allows you to select from a > variety of styles. When I'm designing a report, I usually start with the > Report Wizard and tweak the results afterwards. > Hope this helps. > > Laurie > > > On 2 April 2014 21:21, Joe Yoder <[email protected]> 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? >> >> 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/CAMvTR9cqd2OnHadER2axT4iMMtOjrrRNXKL4=y3h_uxyiao...@mail.gmail.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.
