Changing charts from VB.

[enui71]

I am using CR 8 and VB 6. I have set up a pie chart in a report. I want to use the same report for 10 different pie charts. I want to change the "on change of" for the chart. I made it a formula. It has no problem with this. After changing the formula using VB the viewer shows no error and the report pane is blank (gray, not white). Changing the formula in CR designer and changing the formula to the same field that as in design mode cause no problems. Any suggestion on how to fix this or go about it another way?

 

[LV]

I'm changing the chart types from ASP so may be you'll see someting similar to you situation. I'm passing a chart type from HTML form to the ASP page and based on that set the chart type in the report. Here is that part of the code:

iGraphType = cint(request.form("cboGraphType&quot)
'iGraphType can be:
'0 - Flat Bar
'3 - 3D Bar
'10 - Line
'13 - Line w/markers
set session("Sections&quot = session("oRpt&quot.Sections

for i = 1 to session("Sections&quot.Count
set Section = session("Sections&quot.Item(i)
set SectionObjects = Section.ReportObjects
for j = 1 to SectionObjects.Count
'7 is Graph Object
if SectionObjects.Item(j).Kind = 7 then
set session("GraphObject&quot = SectionObjects.Item(j)
session("GraphObject&quot.GraphType = iGraphType
end if
exit for
next
next