Miss Items on Cross Tab Report

rbuser

Hi,
2 questions
1. I generate a crosstab report from a query in which I'm having trouble
eliminating records where a particular field has none alphanumeric character
ie #!? etc.. Is there an event when the report is generating that I can
write some code to ignore those records.

2. Is is possible to change the headings in the cross tab report to
something other than the fields contained.

TIA
Steve Byrne

nicocizik

Hi Steve,


Try using the OnGetCaptionText event to monitor what values are being
entered into each cell and chang the output accordingly.


Check out the crosstab demo 127 located in the \RBuilder\Demos\CrossTabs\...
directory. This is a good example of how to customize the headings of a
crosstab.

--