Adding Images to cross tab row headers

[allenri]

HI - hope someone can help me on this.  I'm using iReports running against Oracle 11g.

I'm using a crosstab report to show sales of products by salesrep.  Products down the rows, salesreps across the columns.  i think that's one row group (products) and one column group (salesreps)

For the row header for the row group, I currently have 1 field - the Product_Name.

i want to add an image of the Product to the row header - so the row header would contain two fields Product_name and Product_Image.

- Product_Image shouldn't be a separate row group - because there is a 1:1 relationship between Product_name and Product_Image.

I don't seem to be able to get any output when:

- I try to make the Image it's own report group (but I don't really want to do that anyhow - see above)

- I try to add a second field into the Product_name report group header.

Has anyone tried to do something similar?

Both adding extra fields ino a heading group, or added an image into the headers?

I have seen at least one posting suggesting that you handle the pivot in the database and then just create the report from the pivot table.  However, i think this is going to be a problem for me because I don't know in advance how many rows or columns the pivot table will create.

Any ideas welcome, please...