I'm finally wrapping up this report and have just added the shading in the form of a rectangle that prints when the hour matches what I have in an inlist function. The rectangles print where and when they are supposed to but they overwrite the data underneath. I thought setting the backstyle of the rectangle to transparent would solve the problem but no luck. What am I missing?
My report detail line is too busy. It has 24 fields, 24 separator lines, and now a rectangle over the entire width. It has been a real challenge to select the individual elements as I tweak the exact placement. Since the rectangle is on top things will be even worse! Is there a way to have the screen zoom so it is easier to select individual elements? Something else? Thanks so much, Joe On Thu, Apr 3, 2014 at 4:53 AM, TWCC Membership <[email protected]> wrote: > 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/CABQeDnVp+GHrbtoxvcdMfFeU6YSc3UnsQix4kzQ=QU1=rqo...@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.
