Displaying a chart in view only on client w/o OWC

[brian_madden]

Hi,
I have a page with a pivot table and chart on it. The pivot table is using a
cube as its data source. I want to be able to display a read only version of
the chart on clients that do not have OWC installed but have been unable to
get this to work.
With the controls on the page, it will only show the control outline on
clients without OWC. I am using a service to get the datasource XML and I
tried to build the chart here using PivotTableClass and PivotView, but it
always returns an empty chart. Does anyone know how to do this ??

Thanks for helping,
Brian Madden

 

[Alvin Bruney [MVP]]

OWC is a requirement on the client. Your only other option is to stream out
the chart as a gif image from the server to the client.

 

[brian_madden]

Thanks Alvin!
Finally managed to get that done on the server. One more thing, is it
possible to change the chart type, the measures that are on the data area,
etc on a chart that is bound to a pivot table from code? I've been trying to
do this and I'm not having any luck at all.
Briefly, I have a PivotTableClass, ChartSpaceClass, binding using
csc.DataSource = (msdatasrc.DataSource)ptc, except on the chart only the last
added measure is shown on the chart, not all of them.

Thanks again!
Brian Madden

OWC is a requirement on the client. Your only other option is to stream out
the chart as a gif image from the server to the client.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi,
I have a page with a pivot table and chart on it. The pivot table is using
a
cube as its data source. I want to be able to display a read only version
of
the chart on clients that do not have OWC installed but have been unable
to
get this to work.
With the controls on the page, it will only show the control outline on
clients without OWC. I am using a service to get the datasource XML and I
tried to build the chart here using PivotTableClass and PivotView, but it
always returns an empty chart. Does anyone know how to do this ??

Thanks for helping,
Brian Madden

 

[Alvin Bruney [MVP]]

you should just be able to change the type


objChart.Type = ChartChartTypeEnum.chChartTypeBar3D;

to plot all the measure you need to set plotallaggregates to true


--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Thanks Alvin!
Finally managed to get that done on the server. One more thing, is it
possible to change the chart type, the measures that are on the data area,
etc on a chart that is bound to a pivot table from code? I've been trying
to
do this and I'm not having any luck at all.
Briefly, I have a PivotTableClass, ChartSpaceClass, binding using
csc.DataSource = (msdatasrc.DataSource)ptc, except on the chart only the
last
added measure is shown on the chart, not all of them.

Thanks again!
Brian Madden

OWC is a requirement on the client. Your only other option is to stream
out
the chart as a gif image from the server to the client.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi,
I have a page with a pivot table and chart on it. The pivot table is
using
a
cube as its data source. I want to be able to display a read only
version
of
the chart on clients that do not have OWC installed but have been
unable
to
get this to work.
With the controls on the page, it will only show the control outline on
clients without OWC. I am using a service to get the datasource XML and
I
tried to build the chart here using PivotTableClass and PivotView, but
it
always returns an empty chart. Does anyone know how to do this ??

Thanks for helping,
Brian Madden