print dynamic field names

[kcl]

I am using Crystal Report X1 - I have an SQL table called CUSTOMERS, we have a programs that lets users add/delete customer names(which become field names). Field contains date value of when record was created.

Table = CUSTOMERS fields= APEX, MICROSOFT, ACME

Need to print a report showing current field names only.

 

[Madawc]

That sounds like something you should put in Record Selection. But it's not clear what it is that identifies 'current field names'.

If there was something like a closed date, you would need isnull({date.closed)

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[kcl]

Since users can add or delete fields, I need to be able to print the list of field names that exist at the time of printing

Let me try again:
Table CUSTOMERS

On Dec 1, the table contains the following:

Field Name : ACME Field Value 12/01/07
Field Name: MICROSOFT Field Value 11/15/07

On Dec 3, the table contains the following:

Field Name : ACME Field Value: 12/01/07
Field Name: MICROSOFT Field Value: 11/15/07
Field Name: APEX Field Value: 12/03/07
------
So I need to loop thru the table and print the field Names only
On Dec 1 report would look like:
ACME
MICROSOFT

On Dec 3 report would look like:
ACME
MICROSOFT
APEX

 

[Turkbear]

Hi,
Since the actual structure of the table is constantly changing, CR will have a difficult time even using it..
A change to the MetaData often triggers a 'Database has changed, procede to fix up report?' message..

Why the odd structure?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kcl]

It is third party software, and we have to live with it. Is there no way to dynamically parse through the table and extract the field names into variables or text boxes to allow for printing?
Thanks

 

[lbass]

Just to clarify--are you saying that you only have separate fields containing dates, one field per name? If you place your current fields in the detail section and run a report, what would the report look like? Please show a sample of how that would look just so we can understand your current data.

-LB