Looking at you what you want to present it seems that Crystal will already do what you want.

 

Here is a layout that might work

 

Group1Hdr {PersonName} -  Name\ClassTextLabel, ClassATextLabel, CllassBTextLabel, etc.

Details - {PersonName} {ClassAttend} {ClassBAttend} etc

 

Suprress the PersonName field in the GroupHeader and you should be close to what you want. If your {Class*Attend} needs to be a formula so it shows the words Attend or Not Attend we would need a bit more information. What in the database tells you the person has attended or not? Once you have that you create a formula that will return the text Attend or Not Attend as is appropriate. However not knowing what this is we cant give you a sample solution.

 

You may have reasons this will not work but those were not explained.  

 

Hope this helps.

 

Regards,

 

John W.

 

 

It seems to me that Crystal Reports does a very good job of laying out a report. It does a good job of dealing with presenting data to the user. In the end it is a fixed design.

 

As an alternative you will need to build a report that handles from 10 to a 100 columns anyway. So build the report to handle the maximum number of colums (100) and turn off (suppress the unused ones)you do not need for that particular report.  I suspect you could use the count function on a given field to determine which ones you need. 

 

I am curious though, 100 columns is a lot of report data.  In my opinion, it may be too much for the user to take in. My question solely based on curiousity is what will be the dimensions of the report. It must be large. Having said that is there a way to redesign the report, since I am sure a person doesnt take a hundred classes at once, perhaps using time frames as a basis. If you could it might make the whole thing a lot more managable.

 

Sorry I could not be of more help.

 

Regards,

 

John W.