AW exception?

Does anyone know what the message " Exception of type
Microsoft.ReportingServices.ReportProcessing.aw was thrown." means? I
searched the Knowledge base and couldn't find anything. I kept getting this
error when I try and view the report I am working on in Visual Studio.Net.
I made some changes to the report and now I get this error and can't view
the report to see if the report works.
Any help appreciated,
Nancy LThis sounds like SP1 is not installed and your report has a parameter where
the default or valid value explicitly reference a field that is not in the
dataset returned by the query at runtime.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nancy Lytle" <lytlenj@.yahoo.com> wrote in message
news:uxqrYf52EHA.524@.TK2MSFTNGP09.phx.gbl...
> Does anyone know what the message " Exception of type
> Microsoft.ReportingServices.ReportProcessing.aw was thrown." means? I
> searched the Knowledge base and couldn't find anything. I kept getting
this
> error when I try and view the report I am working on in Visual Studio.Net.
> I made some changes to the report and now I get this error and can't view
> the report to see if the report works.
> Any help appreciated,
> Nancy L
>|||I got the exact same issue and it turned out to be an issue with the default values in a Report Parameter. Modified the default values and the error went away
From http://www.developmentnow.com/g/115_2004_12_0_0_453709/AW-exception.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Avoiding Empty Tags using XML Explicit..

Hey all, a nice little challenge for you as I've searched all over..

Here is some very simple XML Explicit code:

SELECT 1 AS TAG,
NULL AS Parent,
product AS [ParentTag!1!AProduct!Element]

FROM tblTable

WHERE X = Y

FOR XML EXPLICIT

When there is no results, I get an empty tag.

<ParentTag/>

This I do not want. Insted I would like nothing. Is there a simple way to achieve this?

Using SQL Server 2000

Looking forward to your responses!

Roqs

Dunno if its just my SQL Server but mine is working fine. I get a blank when no data is returned (Not the <ParentTag/>)

Tried this with northwind.

SELECT 1 AS TAG,

NULL AS Parent,

CompanyName AS [ParentTag!1!AProduct!Element]

FROM Customers

WHERE CustomerID = 'LFKI'

FOR XML EXPLICIT