Crystal and Excel Add Column

[Ladyazh]

Here is the question.
I have one department that keeps adding product names to the database.
For me to get it in Report I have to retrive it like this
If({t.CODE})='FPG'then {t.PG}

And I need to write this formula for all products and those are growing.

I was thinking about having it done dynamically somehow.
My though was to create Excel Pivot Report and have VB procedure check for product, if anyone is new - add column and then...I do not know if this can be picked up by Crystal somehow. From Excel.

Or maybe there is another solution.

Please, comment.

 

[IdoMillet]

Just add a 2-column table to your database...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Ladyazh]

Please, why?

 

[Ladyazh]

I mean this field are growing. What will 2 field table change?
I will still have to go
If({t.CODE})='ABC'then {t.PG}
If({t.CODE})='DEF'then {t.PG} etc. every time new product added.

Thanks