I have a table with this format :

[Frank336]

I have a table with this format :

Types ID
----- --
Type1 A
Type1 C
Type2 C
Type3 B


I would like to do a report with this format :


ID\Types | Type1 Type2 Type3
---------
A X
B X
C X X


The X are Picture of Cheked CheckBox. So if for the ID C theres 2 records, then in the report I would have 2 “X”


Using cross table I cant put the X in the report and it don’t seem to work with total fields either...

Whats the best way to do what I want ?

Thanks,
Frank

 

[AndrewBaines]

If there are only a limited number of columns, create a separate formula for each column.
eg
If Type = "Type1" then "X" else ""
etc
You'll need to create a String variable for each column and just keep making it longer each time the formula is tripped Andrew Baines
Chase International

http://www.chase-international.com

 

[Frank336]

There is a limited number of column.

Where would you put your formula ? ID Group Header ? Detail ? The best result I get is :


ID\Types | Type1 Type2 Type3
---------
A X
B X
C X
C X


I want all the X of C to be on the same row...


thanks

 

[AndrewBaines]

Put the formula in the detail section:

if .... then var := var +"X";

then group by ID
In the group footer add
WhilePrintingRecords;
var;

Then hide the detail section Andrew Baines
Chase International

http://www.chase-international.com