At 09:51 AM 11/2/2012, Karen Tellef wrote:
Using 9.5. I would like to design a report with a break on a
Salesman column, and have a
crosstab on the report for each salesman. It seems that I get the
full crosstab no matter
where I locate it. I have a page break set for each break, but
locating it in the page
header still didn't fool it.
Has anyone else tried this? If not, do you have any ideas how I
can get one report that
would show all salesmen? The only thing I can figure is to print
each report individually
to a PDF and then combine all PDFs... I'm hoping for something easier.
By definition, the CrossTab Object, part of Advanced Controls in
R:BASE eXtreme 9.5 (32/64),
allows you to generate a set of calculations that summarize the data
for each unique pair
of values from two columns in a table or view, using the specific
WHERE clause with matching
dataset for the entire report which cannot be further aggregated by
Report Break(s), etc.
The most common band to place CrossTab Objects is the Page Header
with further customized
Report Header, Page Footer, and Report Footer.
Thinking outside the box ...
In order to achieve the ultimate goal, prior to printing the CrossTab
report, based on
the report WHERE clause, create a temporary table with DISTINCT
Salesman, and then use
the WHILE ... ENDWHILE to PRINT the CrossTab report with appropriate
WHERE clause for
each Salesman individually with a unique PDF file name, and then use
the R:PDFMerge
(part of R:PDFWorks) to merge 'em all as one PDF document, if deemed necessary.
Did you know that you can customize the Crosstab object using
Horizontal and Vertical
Gridlines? In addition, you can also customize the Title, Font,
Color, and Display
Format for Columns and Rows associated with Crosstab object.
Have fun!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
