Hello....
I am trying to create a PIE CHART in a report that's row source is unknown until the search criteria is selected in a form. I am able to build my sql string with all of my criteria fine...but i can't seem to set the row source for the chart...the property is not available when i setting it dynamically.
Can you even set this programmatically???? or does the chart always have to have the query/table set in design mode?
I am trying to create a PIE CHART in a report that's row source is unknown until the search criteria is selected in a form. I am able to build my sql string with all of my criteria fine...but i can't seem to set the row source for the chart...the property is not available when i setting it dynamically.
Can you even set this programmatically???? or does the chart always have to have the query/table set in design mode?
