Hi everyone, I've spent hours over several weeks looking for a hint of an answer to this, perhaps my situation is unique.
I have a database, that through necessity, has the data for multiple items, we'll call them different tests. Now if I use this database for a chart's data provider, it will of course display along the x-axis, all entries which currently exist. So if there are 10 entries, I'll get 10 data points, whether anything is plotted on the y-axis or not - just a default line chart, no other parameters set, it's not important yet. Okay, so lets say that out of the 10 currently existing data points in the db, only 5 are relevant to me at the moment. I've figured out how to select the five I wish by defining them in the y-axis series, however the remaining 5, still of course exist in the data provider and are shown along the bottom of the chart and because the data is not relevant to my selection, appears as zero, no data. I've probably lost you, so let me explain what I want to do. I would like to be able to filter the data presented in the data provider, before the chart is rendered. So if I wish to show only 5 of the 10 available points in the table, I can do so. Now, can this be done simply by manipulating the x-axis or is it required to be done perhaps with sql calls to the database. How about a hint about how I can filter or control the data delivered in the data provider. Thanks,
