Parent child dimension from OLAP (AS) in Maxtrix control for SRS 2 -- sql server reporting services

petery NO[at]SPAM online.microsoft.com
3/7/2006 12:00:00 AM

Hello Henrik,

What's the version of AS and RS? Could you provide us a simple repro with
sample database/reports if possible?

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
[quoted text, click to view]

Henrik Juel
3/7/2006 12:27:14 AM

Hi Peter and thanks for the answer

I use AS & RS 2005.

I have tried with a simple table and got the same problem in the
reportmanager. I have also tried using the ReportViewer with URL access on
Administrator credentiels for eliminating the security issue.

Below is the report rdl. Do you need screenshots from the reportmanager and
maeby the cube ?

<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="AS">
<DataSourceReference>AS</DataSourceReference>
<rd:DataSourceID>d68bfc85-b141-4f39-9f84-3d5f140c7d25</rd:DataSourceID>
</DataSource>
<DataSource Name="dw">
<DataSourceReference>dw</DataSourceReference>
<rd:DataSourceID>23de4e0c-32ea-4c58-867f-5c953c7ce47c</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<ReportParameters>
<ReportParameter Name="Customer">
<DataType>String</DataType>
<Prompt>Konto</Prompt>
</ReportParameter>
<ReportParameter Name="Vendor">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>-</Value>
</Values>
</DefaultValue>
<Prompt>LeverandÃ¸r</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>Vendor</DataSetName>
<ValueField>vendorid</ValueField>
<LabelField>vendorname</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Matrix Name="matrix1">
<MatrixColumns>
<MatrixColumn>
<Width>2.53968cm</Width>
</MatrixColumn>
</MatrixColumns>
<Left>0.25cm</Left>
<RowGroupings>
<RowGrouping>
<Width>6.75cm</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="TopGroup">
<rd:DefaultName>TopGroup</rd:DefaultName>
<ZIndex>2</ZIndex>
<Action>
<Drillthrough>
<ReportName>Bruger Salg pÃ¥ varer</ReportName>
<Parameters>
<Parameter Name="AccountId">
<Value>=Parameters!Customer.Value</Value>
</Parameter>
<Parameter Name="Vendor">
<Value>=Parameters!Vendor.Value</Value>
</Parameter>
<Parameter Name="ItemGroup">
<Value>=Fields!GroupId.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>=2 + Level() * 10 &
"pt"</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>

<BackgroundColor>=iif(Level()=0,"Gainsboro",iif(Level()=1,"Gray","Silver"))</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!GroupId.Value</Value>
</Textbox>
</ReportItems>
<Subtotal>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>=2 + Level() * 10 &
"pt"</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>MediumAquamarine</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
</Subtotal>
<Visibility>
<ToggleItem>TopGroup</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
<Sorting>
<SortBy>

<SortExpression>=sum(Fields!Line_Amount_MST.Value)</SortExpression>
<Direction>Descending</Direction>
</SortBy>
</Sorting>
<Grouping Name="matrix1_TopGroup">
<Parent>=Fields!GroupId.ParentUniqueName</Parent>
<GroupExpressions>

<GroupExpression>=Fields!GroupId.UniqueName</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<ColumnGroupings>
<ColumnGrouping>
<DynamicColumns>
<ReportItems>
<Textbox Name="Year">
<rd:DefaultName>Year</rd:DefaultName>
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Bottom>Solid</Bottom>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<BorderWidth>
<Bottom>1pt</Bottom>
</BorderWidth>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<Direction>RTL</Direction>
<BorderColor>
<Bottom>Black</Bottom>
</BorderColor>
<BackgroundColor>MediumAquamarine</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=" Ã…r " & Fields!Year.Value</Value>
</Textbox>
</ReportItems>
<Subtotal>
<ReportItems>
<Textbox Name="textbox5">

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Parent child dimension from OLAP (AS) in Maxtrix control for SRS 2