Thank you, Razzak. I've got it now. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Monday, September 29, 2008 10:59 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Crosstab Report Question
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. It's 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.
