Newbie Reporting Questions

Post Author: tel

CA Forum: Crystal Reports

I'm new to Crystal Reports and reporting in general, and i ran accross a problem I can't seem to find an answer for.

I need to display rows in a database as if they are columns. More specifically, I'm writing a report on items. Each item as a list of charges. Each charge has a description and an amount. I want to display the charges as columns (instead of rows) with the description as the column headers.

For example lets say we have an item with the following charges:Charge 1: description: Charge 1 amount: 10.00

Charge 2: description: Charge 2 amount: 5.00

I want a report that displays it something like:

Item Number

Charge 1

Charge 2

1234

10.00

5.00

Is such a thing possible?

Thanks,