I am back. After comfortably accomplishing my database needs in v10.5 I duped myself into upgrading to v11 thinking compatibility would not be a problem and salivating to have the dialog Component Chart Control. Back to compatibility problems later. For now I am very disappointed in the lack of simplicity using the chart control.
After watching all the videos about the chart control it absolutely befuddles me that not one of the 25 show binding charts to DBF tables. In fact almost all examples use static data or it goes way complex and uses custom xbasic to pull series from something like Northwind in SQL which also avoids using any of the property dialogs that apparently can do such things w/o writing xbasic. And absolutely no love for the DBF I guess.
So I think it must be so easy since no videos are required. After all one can see the menu items for binding and the choices present the DBF tables and columns well when defining the series. Seems straight forward, wrong! Now try filtering the data that is shown in a chart based on a value in a dropdown that comes from a DBF table. I defined an Argument to get the value form a dropdown. The value is of the type Character (because it it someones last name). I then defined the filter expression to reference the Argument. Set it and press ok. NO LUCK. The filter complains that the expression does not evaluate to a logical value. WHY? It is not supposed to evaluate to a logical value. It is a Character value. Nothing I do can make it accept the character value. I am not filtering based on a logical. I am filtering based on a last name.
Hoping someone can save me from shooting myself before I spend another 7 hours not knowing how to do a simple filter for a data series in the chart control based on the value in a dropdown. Should be able to do it using the menus and prompts provided not editing xbasic.
Many many thanks.
After watching all the videos about the chart control it absolutely befuddles me that not one of the 25 show binding charts to DBF tables. In fact almost all examples use static data or it goes way complex and uses custom xbasic to pull series from something like Northwind in SQL which also avoids using any of the property dialogs that apparently can do such things w/o writing xbasic. And absolutely no love for the DBF I guess.
So I think it must be so easy since no videos are required. After all one can see the menu items for binding and the choices present the DBF tables and columns well when defining the series. Seems straight forward, wrong! Now try filtering the data that is shown in a chart based on a value in a dropdown that comes from a DBF table. I defined an Argument to get the value form a dropdown. The value is of the type Character (because it it someones last name). I then defined the filter expression to reference the Argument. Set it and press ok. NO LUCK. The filter complains that the expression does not evaluate to a logical value. WHY? It is not supposed to evaluate to a logical value. It is a Character value. Nothing I do can make it accept the character value. I am not filtering based on a logical. I am filtering based on a last name.
Hoping someone can save me from shooting myself before I spend another 7 hours not knowing how to do a simple filter for a data series in the chart control based on the value in a dropdown. Should be able to do it using the menus and prompts provided not editing xbasic.
Many many thanks.