export excel fail

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
NickHello 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
> Nick|||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
> > Nick|||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.
Larry
"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
> > > Nicksql

Explicitly fail a SQL Server Job in SQL Server 2000

I have a SQL Server job, which runs mutiple steps. One of the steps
(step 3) looks for a record in the database. How can I explicitly fail
the SQL server job if the database record does not exist?You can use RAISERROR with a severity level of 11 or higher to indicate
failure.

Simon|||Thanks Simon. That worked.