This if my first Crystal Report! I using CR XI.

I am creating a report from a MySQL table.  There are 1400+ rows.  Each row is a separate report.  That is, what is on page 1 has nothing to do with what is on page 2 or page 1000.  I'm just dumping 1 row of data on one report  1400+ times. 

In each table row, I have the RGB values that I want to apply to that page only.  After I place the RGB values on the report and set them non-display, how do I combine the 3 values and set the background property?

Also, where can I find a list of properties I can modify?

Thanks much.
Cheers!


Edited by rcflyer2005 - 26 Jan 2009 at 11:49am

Some Background:
This is not a production report.  It is a "means to an end" to get invoice data into pdf format.  It is just that some pages have a background color.  That is all.  It's not logical or it is supposed to make sense. 

The table contains test invoice data.  Most invoices are printed on white paper.  However, some vendors print their invoices on color paper.  I'm trying to simulate that.  Think of each page being an invoice a company has received from 1400+ vendors.  That's why the pages are not related.  When CR prints page 1, I want it to get the RGB values and make the background the values of RGB.  Do the same for page 2,3,...,page1400+.  Each row in the db is a page break. 

If I created a formula, what would I type in it?  If I put the RGB values on the report they would be fields colorR, colorG and colorB.  Or I can put the three values in one field, separated by a comma and use one field.

Sorry for the confusion!

thanks much!

If the above is accurate you can bypass dealing with page numbers and handle it based on your joins to the vendors. If you only have the vendors that use color in the "color table" you would need to handle instances where they are not listed. I have never tried this and don't really have good data for testing the process but this might work (replace the {table.field} with the appropraite fields from your color table):

Edited by DBlank - 26 Jan 2009 at 2:28pm