I have to create an interesting report in which both the rows & columns are derived from the database.
1st, I need to query the database to retrieve all of the different types of service plans my company currently offers. Each plan type will have its own column.

I then need to query the database to find out the total number of sales each employee has had for each plan type(each employee name and their total sales for each plan will be 1 row in the report).

So, my question is, since I'm going to have an unknown number of both columns(plan types) and rows(employee sales of each plan type), is there any way to set up crystal to handle this type of information or do the columns have to be static?

Thanks in advance.

-Goalie35

Check out Crosstab Report. Use Plan Type as Column Header and have employee name as row and sales as their summary field.

Try out this

Venkat