Just for the one report? I don't think so. For the whole server? Sure, I
think. :-) Try removing the \Configuration\Extensions\Render\Extension for
the Excel renderer from RSReportServer.config. I believe that will disable
it. There may be an easier way, but that is the first one that comes to mind.
"Nick" wrote:
> Thanks mate.
>
> Just wonder that is that any way i can remove excel export from the report
> view as i don't really need this export function.
>
> Cheers
>
> Nick
>
> "lsmithmier" wrote:
>
> > Hello Nick,
> >
> > This is a limitation of the Excel render engine:
> >
http://www.microsoft.com/technet/prodtechnol/sql/2005/rsdesign.mspx > > "Excel does not support nested containers other than lists."
> >
> > and:
> >
http://msdn2.microsoft.com/en-us/library/ms155976.aspx > > "Any data region nested inside of a table or matrix data region is not
> > supported. An error is displayed in Excel if this layout is encountered. "
> >
> > You can look at:
> >
http://msdn2.microsoft.com/en-us/library/ms156268.aspx > > and find tips on designing your report to look good when rendered in
> > different formats. Modify your report to use lists rather than tables and
> > you should be able to overcome this issue.
> >
> > Good luck!
> >
> > Larry
> >
> >
> > "Nick" wrote:
> >
> > > Hi All:
> > >
> > > I create a report and it works perfectly when i export repor to PDF, CVS etc
> > > except Excel.
> > > The error i got is: Subreports within table/mastrix cells are ignored.
> > >
> > > any hepl are appreciated.
> > >
> > > Thanks