Joe:
Some other 'things' I have learned along the way:
1 make the cursor to look like the printed report. Simply meaning when you
look at the records it will be obvious where the data grouping breaks are going
to be
2 When superimposing objects they might not print where you expect that would
be and this differs by printer driver. I have found that the shaded and
unshaded rectangles should be at -0.01 on the detail band so the lines match on
odd and then on even rows
3 I used 'i' for the count variable; make sure if you use it in the calling
form it is declared a 'local'
4 The place I work the folks like to see 10 pounds of potatoes in a 5 pound
sack! And as a result I have found that Calibri font is super on reports where
there is tons of data and you need a smaller font to show all the data on one
line. The font is thinner and you can squeeze more data per line
5 run this code before you compile:
local i, lnCount
local array laFrxs(1,5)
lnCount = 0
lnCount = adir(laFrxs,"*.frx")
if lnCount > 0 then
for i = 1 to lnCount
use (laFrxs(i,1))
replace tag with "", tag2 with ""
use
endfor
wait window "Reset " + alltrim(transform(lnCount,"99,999")) + " Reports..."
timeout 2
else
wait window "No Reports In This Folder..." timeout 2
endif
This will clear the stored printer info.
I hope all of this helps.
Best regards
Jack
________________________________________
From: ProfoxTech [[email protected]] on behalf of Joe Yoder
[[email protected]]
Sent: Wednesday, April 02, 2014 4:37 PM
To: [email protected]
Subject: Re: Help with report writer
Thanks Jack!
That's what I needed.
Joe
On Wed, Apr 2, 2014 at 4:32 PM, Jack Skelley
<[email protected]>wrote:
> 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.
