Using Pervasive SQL, through ODBC and CR 2008.
I tapped into the system tables of the database to create a report that lists all the fields available in each table. That was easy. I was hoping to do the same thing for the 700 views in the database but ran into a brick wall. What I need is the list of field names returned by the view to Crystal, including field names for calculated columns. In other words I need the list of fields that you see in the field explorer for each view.
I read that a programmer can use an ODBC function (odbc_columns) to pull up that list and I believe that is how CR generates the list of available fields. Does any one know any other ways or tools to generate or capture that list? I want to read that list with CR so transferring it to a table is probably the final result.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
I tapped into the system tables of the database to create a report that lists all the fields available in each table. That was easy. I was hoping to do the same thing for the 700 views in the database but ran into a brick wall. What I need is the list of field names returned by the view to Crystal, including field names for calculated columns. In other words I need the list of fields that you see in the field explorer for each view.
I read that a programmer can use an ODBC function (odbc_columns) to pull up that list and I believe that is how CR generates the list of available fields. Does any one know any other ways or tools to generate or capture that list? I want to read that list with CR so transferring it to a table is probably the final result.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks