I need to find out exactly which database fields are used in a report programmically. This is proving to be quite difficult. I achieved this in the past by getting the SQL query as a string and parsing the fields that way. However since upgrading to Crystal 11 there seems to be know way to do this. Instead you can interate the tables collection and for each field check its usecount value. However this property has a bug as described here - http://technicalsupport.businessobjects.com/Publishing/998/c2017430_f.html.
The workaround given in the above article works but only up to a point. It can't work with charts and many of our reports use charts.
So my question is - is there a way in Crystal 11 to achieve this? It seem sa fairly simple thing that i can imagine many people might need to do and yet it seems impossible due to this bug. If anyone has achieved it in some way i would be most grateful for any advice.
Thanks in advance.
The workaround given in the above article works but only up to a point. It can't work with charts and many of our reports use charts.
So my question is - is there a way in Crystal 11 to achieve this? It seem sa fairly simple thing that i can imagine many people might need to do and yet it seems impossible due to this bug. If anyone has achieved it in some way i would be most grateful for any advice.
Thanks in advance.
