J
johnhildreth
Running Acess 03 in Win XP sp2. I have a form containing a listbox
with multiselect option. The idea is to allow the user to select from
the list all the items for which they want to print data in chart
format. I have a report and want create subreports within (number of
subreports equal to number of items selected in listbox). Each
subreport is a pivotchart for one item selected.
The problem is that the pivotcharts created contain no data when
multiselect is on. I can turn off multiselect and create one
subreport/chart with data. I can loop through the selected items,
trap the data from each selection that I need, create the subreports,
and print.....but how can I create charts AND use multiselect?
Thanks,
John
with multiselect option. The idea is to allow the user to select from
the list all the items for which they want to print data in chart
format. I have a report and want create subreports within (number of
subreports equal to number of items selected in listbox). Each
subreport is a pivotchart for one item selected.
The problem is that the pivotcharts created contain no data when
multiselect is on. I can turn off multiselect and create one
subreport/chart with data. I can loop through the selected items,
trap the data from each selection that I need, create the subreports,
and print.....but how can I create charts AND use multiselect?
Thanks,
John