At 10:23 AM 9/29/2008, Jay Ward wrote:
I am, for my first time, attempting to create a report based
on a crosstab. Its a simple one in that I want to list the
names of club members and how many times they have done the
three duties that we keep track of. When I use the following
at an R prompt: crosstab count dutyname=8 for dutyname by
fulln from try2 I get exactly what I want a listing of 37
names with three columns following and a total column at the
end.
When I attempt to create a report based on the same table I
get only a listing of 36 names and 100 pages of them rather
than just a single page. The report does create the columns
as I wish and looks great but
Can anyone push me in the right direction for correcting my
simple mind that must be overlooking something just as simple?
Using 7.6.4.30919
Jay,
That seems to be the result of placing the CrossTab control
on the [Detail] band.
Place the CrossTab control on the report Page Header, update
the CrossTab control properties, including Grid Lines,
Pagination, and Stretch and see what results you get.
For a sample CrossTab report to demonstrate all features,
take a look at the CrossTabReport or CrossTabReportCust
report included with Running R:BASE Your Way! (Part 14).
Here are a few samples for your viewing pleasure ...
-- CrossTab Report (Vertical Lines)
http://www.rbase.com/rbg8/reports/CrossTabReportStd.pdf
-- CrossTab Report (Horizontal Lines)
http://www.rbase.com/rbg8/reports/CrossTabReportHorz.pdf
-- CrossTab Report (Vertical and Horizontal Lines)
http://www.rbase.com/rbg8/reports/CrossTabReportBoth.pdf
-- CrossTab Report (No Lines)
http://www.rbase.com/rbg8/reports/CrossTabReportNone.pdf
Hope that helps!
Very Best R:egads,
Razzak.
