Hello,
I am currently working on some reports that are dynamic and change based on which company is viewing the reports. The logo changes to the company's logo, and each company has a main color and alt color that is customizable from the database. I'm creating these features from scratch, so I just need to know how to do it correctly.
So far, I've been able to bind the logo (picturebox) to data that is a URL of type nvarchar(255) in the database. I can then change companies and the logo is definately changing to the company it is set to in the database.
The problem is I have two columns in the company table that define the two custom colors. One is
ReportColorMain and the other is
ReportColorAlt. Right now I have them set to data type
nvarchar(25) and just put some
RGB color values in them (like "0, 97, 178"). I have also tried to use color names like Crimson or DarkRed. I bind these to either the
backcolor or
color attribute of the particular object in the report I want to use this color with. Unfortunately, it is not working like the logo did. I'm getting a report error:
Do I have to use a certain datatype in my SQL Server 2005 database instead of nvarchar? Should I use some other method of collecting this color from the database? Help would be greatly appreciated!