Crosstab Column Formatting

rbuser

I am using RB7.03 and am trying to remove a column in the report's crosstab
display. I cannot set it to unvisible because there is actually no
value/caption in the configure area. The caption's are automatically set at
run-time (Sum of..). All I can do is change the text to a blank space at
run-time, but the column lines still appear. I just want to remove or
delete this column at run-time and have looked through all the demo's and
there is nothing that will work. Any other ideas?

Thanks

nicocizik

Hi Gary,

Check out the TppCrossTab.Matrix.DeleteColumns method. This allows you to
delete a certain number of columns from the crosstab matrix at runtime. See
the help topic for the above method for more information.

--

rbuser

Hi,

I implemented a pass-through function, as you suggested. My report is

similar to your crosstab demo #23, in that it has one column, one row,

and two values. The second column, with "Sum of Amountpaid" and "Count

of Amountpaid" all the way down the page, is the one I want to delete.

When I call CrossTab.Matrix.DeleteColumns(1,1) in the ExecuteFunction of

my TraSystemFunction descendant, I have two problems:

- I get an AV in TppMatrix.DeleteColumns. I'd suggest that there may be

a line missing in the code:

while (liRow < lColumnList.Count) do

begin

TppCellValue(lColumnList[0]).Free;

lColumnList.Delete( 0 ); // add this line

Inc(liRow);

end;

- When I made this change, calling DeleteColums(1,1) does make the

crosstab go from 6 rows to 5, but it makes the grid go out of whack.

The new second column doesn't have any data in it and the border at the

bottom of the crosstab partially disappears. Is this a bug in

DeleteColumns, or do I have to set up the borders, etc. after calling

DeleteColumns?

Gary

-----Original Message-----

From: Nico Cizik (Digital Metaphors) [mailto:nico@digital-metaphors.com]

Hi Gary,

I'm sorry, I was unaware you were using RAP. RAP is fully extensible,

meaning that you can extend the capability of the RAP compiler by adding

PassThru functions created in Delphi to perform any task you need. There is

a complete example of creating a RAP PassThru function in the ReportBuilder

Developer's guide as well as a very simple example below.

http://www.digital-metaphors.com/tips/RapPassThroughBoolean.zip

nicocizik

This question is being handled through email.

--