Unfortunately not, it looks like the problem is caused prior, in fact I think
that query doesn't even return an empty cellset, just a null object. The
dialog box returns the following (when trying to execute the report with
parms that don't result in a cellset). When running the same MDX in the MDX
Sample App you get a similar error raised (re: one or more axes not having
any members).
An error has occured during report processing.
Query execution fialed for data set 'ds_Revenue_By_Customer'.
Objected reference not set to an instance of an object.
|OK|
[quoted text, click to view] "Douglas McDowell" wrote:
> Does putting a value in "NoRows" work for this scenario?
>
> From:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_8epf.asp
> Empty Data Regions
> When the dataset for a data region returns no data, the data region is not
> rendered. Instead, a text box is rendered that displays the value of the
> NoRows property. You can edit the NoRows property in the Property window of
> Report Designer. The appearance properties for the data region (for example,
> Color, Font, and Padding) apply to the NoRows text box.
> --
> Douglas McDowell douglas@nospam.solidqualitylearning.com
>
>
>
> "stevefromoz" <stevefromoz@discussions.microsoft.com> wrote in message
> news:B6315E83-B7EE-41D4-9004-BF57C5D66249@microsoft.com...
> > Does anyone know how to catch the error/exception raised when using MDX to
> > query AS and the cellset is not returned due to one or mroe empty axes? I
> > have a near perfect reporting solution with parameters etc however the
> > users
> > get a rather plain and useless (to them) error message if the parameters
> > they've chosen return an emtpy cellset.
>
>
