true
true
Textbox4
SlateBlue
2pt
2pt
2pt
2pt
1.95833in
0.25in
true
true
=Sum(Fields!Internet_Sales_Amount.Value)
Internet_Sales_Amount
2pt
2pt
2pt
2pt
=Fields!Calendar_Year.Value
=Fields!Calendar_Year.Value
0.25in
true
true
=Fields!Calendar_Year.Value
Calendar_Year
SlateBlue
2pt
2pt
2pt
2pt
=iif(Parameters!GroupBy.Value = "product",
Code.IsFieldMissing(Fields!Category),
Code.IsFieldMissing(Fields!Country)
)
1.90625in
true
true
=iif(Parameters!GroupBy.Value = "product",
Code.IsFieldMissing(Fields!Category),
Code.IsFieldMissing(Fields!Country)
)
Textbox1
2pt
2pt
2pt
2pt
dsetMain
0.25917in
0.16542in
0.5in
3.86458in
1.00875in
4.14583in
1in
1in
1in
1in
0
OLEDB-MD
Data Source=.;Initial Catalog="Adventure Works DW 2008R2"
true
Integrated
e1cc24bd-330f-445f-88ef-8a6c03d4ca80
dsMDX
=Parameters!GroupMDX.Value
SELECT
{
[Measures].[Internet Sales Amount]
} ON 0,
NON EMPTY {
[Date].[Calendar].[Calendar Year]*
StrToSet(@GroupMDX)
} ON 1
FROM [Adventure Works]
MDX
Query
Adventure Works
SELECT
{
[Measures].[Internet Sales Amount]
} ON 0,
NON EMPTY {
[Date].[Calendar].[Calendar Year]*
StrToSet(@GroupMDX)
} ON 1
FROM [Adventure Works]
GroupMDX
[Product].[Product Categories].[Category]*[Customer].[Customer Geography].[Australia]
GroupMDX
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Date].[Calendar].[Calendar Year]" />
System.String
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Product].[Product Categories].[Category]" />
System.String
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Internet Sales Amount]" />
System.Int32
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Customer].[Customer Geography].[Country]" />
System.String
String
Group By
product
country
String
=iif(Parameters!GroupBy.Value = "product",
"[Product].[Product Categories].[Category]",
"[Customer].[Customer Geography].[Country]"
)
true
Public Function IsFieldMissing(field as Field) as String
If (field.IsMissing) Then
Return Nothing
Else
Return field.Value
End If
End Function
en-US
true
Inch
100086d8-34b4-490d-b415-ec5f2ca5559f