Вот как мля вручную можно зафигачить такую штуку?
(пример одного из самых простых отчетов, ведомость инвентаризации)
<SemanticQuery xmlns="
http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling" xmlns:xsd="
http://www.w3.org/2001/XMLSchema" xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance" xmlns:qd="
http://schemas.microsoft.com/sqlserver/2004/11/semanticquerydesign" xmlns:rb="
http://schemas.microsoft.com/sqlserver/2004/11/reportbuilder">
<Hierarchies>
<Hierarchy>
<BaseEntity>
<!--Icm-->
<EntityID>G1280fedf-af4f-49d1-aa49-2896355b521f</EntityID>
</BaseEntity>
<Groupings>
<Grouping Name="Cur">
<Expression Name="Cur">
<Path>
<RolePathItem>
<!--Site-->
<RoleID>Gef48a6a0-b66e-40f6-aed8-90e9f07d46b0</RoleID>
</RolePathItem>
<RolePathItem>
<!--Cur-->
<RoleID>G3168f422-4e3a-4dec-bc81-da4caed8edc0</RoleID>
</RolePathItem>
</Path>
<EntityRef>
<!--Curmaster-->
<EntityID>G5a64a230-01d6-4cad-8b51-2a34320c71e9</EntityID>
</EntityRef>
</Expression>
<Details>
<Expression Name="Curcode">
<AttributeRef>
<!--Curcode-->
<AttributeID>G731f8d0f-8743-4d12-9bcf-cb2c34eb5bac</AttributeID>
</AttributeRef>
</Expression>
</Details>
</Grouping>
<Grouping Name="Descr 1">
<Expression Name="Descr 1">
<Path>
<RolePathItem>
<!--Itemno-->
<RoleID>G372ac575-950d-4a26-9689-6efda4eb59a9</RoleID>
</RolePathItem>
</Path>
<AttributeRef>
<!--Descr 1-->
<AttributeID>G2775be31-3bae-4ab0-b905-a59e16d4c700</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
<Grouping Name="Reordpnt">
<Expression Name="Reordpnt">
<AttributeRef>
<!--Reordpnt-->
<AttributeID>G55815fec-9681-43f4-a9bc-aa1553dea2bb</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
<Grouping Name="Reordqty">
<Expression Name="Reordqty">
<AttributeRef>
<!--Reordqty-->
<AttributeID>Gd7ade17b-a32a-404f-a5a0-384ab6e3c226</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
<Grouping Name="Abccode">
<Expression Name="Abccode">
<AttributeRef>
<!--Abccode-->
<AttributeID>Gb6b9c5f4-bde8-4c43-ae16-76bc3a3387ac</AttributeID>
</AttributeRef>
</Expression>
</Grouping>
<Grouping Name="Icm">
<Expression Name="Icm">
<EntityRef>
<!--Icm-->
<EntityID>G1280fedf-af4f-49d1-aa49-2896355b521f</EntityID>
</EntityRef>
</Expression>
<Details>
<Expression Name="Invcost">
<AttributeRef>
<!--Invcost-->
<AttributeID>G9c21ad15-ac3d-444a-8f81-1960c3b114a8</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Pricefact">
<AttributeRef>
<!--Pricefact-->
<AttributeID>G52e92c19-2ec0-4295-8733-aaa1cc79619e</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Convfact">
<AttributeRef>
<!--Convfact-->
<AttributeID>G2c47eb21-79f2-4a5a-af65-62e63cd6c931</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Refcode">
<AttributeRef>
<!--Refcode-->
<AttributeID>G4d703e74-c98e-4143-aa39-da36b1dca1c9</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Defloc">
<AttributeRef>
<!--Defloc-->
<AttributeID>Ga11973ca-74c3-4ca7-b6bc-e3d6537f1cf2</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Stockreq[2]">
<Function>
<FunctionName>If</FunctionName>
<Arguments>
<Expression>
<Function>
<FunctionName>Equals</FunctionName>
<Arguments>
<Expression Name="Stockreq">
<AttributeRef>
<!--Stockreq-->
<AttributeID>G10ca9a10-e9df-4245-a6d9-dd82c0dae641</AttributeID>
</AttributeRef>
</Expression>
<Expression>
<Literal>
<DataType>Boolean</DataType>
<Value>true</Value>
</Literal>
</Expression>
</Arguments>
</Function>
</Expression>
<Expression>
<Literal>
<DataType>String</DataType>
<Value>yes</Value>
</Literal>
</Expression>
<Expression>
<Literal>
<DataType>String</DataType>
<Value>no</Value>
</Literal>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:DefaultName">
<Value xsi:type="xsd:string">Stockreq[2]</Value>
</CustomProperty>
</CustomProperties>
</Expression>
<Expression Name="Buy">
<Path>
<RolePathItem>
<!--Buy-->
<RoleID>G2be009d8-de18-4314-9980-90290b753ad4</RoleID>
</RolePathItem>
</Path>
<AttributeRef>
<!--Name-->
<AttributeID>G152d8322-6298-4f11-a0af-2000d5007b9e</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Acct Acctcode">
<Path>
<RolePathItem>
<!--Acct-->
<RoleID>G1c672903-bce7-4dce-939f-012e546f5362</RoleID>
</RolePathItem>
</Path>
<AttributeRef>
<!--Acctcode-->
<AttributeID>G114fd259-7354-4ddb-8fb4-9191c602bccf</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Uom">
<AttributeRef>
<!--Uom-->
<AttributeID>Gc9f409f9-4f09-4d67-a6cc-f3d93fcce3d9</AttributeID>
</AttributeRef>
</Expression>
<Expression Name="Itemno Itemno">
<Path>
<RolePathItem>
<!--Itemno-->
<RoleID>G372ac575-950d-4a26-9689-6efda4eb59a9</RoleID>
</RolePathItem>
</Path>
<AttributeRef>
<!--Itemno-->
<AttributeID>G2dc2a5ed-5454-4fdb-9084-97d21d43997e</AttributeID>
</AttributeRef>
</Expression>
</Details>
</Grouping>
</Groupings>
<Filter>
<Expression Name="expr1">
<Function>
<FunctionName>And</FunctionName>
<Arguments>
<Expression>
<Function>
<FunctionName>Equals</FunctionName>
<Arguments>
<Expression>
<Path>
<RolePathItem>
<!--Itemno-->
<RoleID>G372ac575-950d-4a26-9689-6efda4eb59a9</RoleID>
</RolePathItem>
</Path>
<AttributeRef>
<!--Itemno-->
<AttributeID>G2dc2a5ed-5454-4fdb-9084-97d21d43997e</AttributeID>
</AttributeRef>
</Expression>
<Expression>
<ParameterRef>
<ParameterName>Itemno Itemno</ParameterName>
</ParameterRef>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:FilterCondition" />
</CustomProperties>
</Expression>
<Expression>
<Function>
<FunctionName>Equals</FunctionName>
<Arguments>
<Expression>
<Path>
<RolePathItem>
<!--Site-->
<RoleID>Gef48a6a0-b66e-40f6-aed8-90e9f07d46b0</RoleID>
</RolePathItem>
</Path>
<AttributeRef>
<!--Sitedesc-->
<AttributeID>G299257af-0176-4ce4-9cb3-913cc3cf84fd</AttributeID>
</AttributeRef>
</Expression>
<Expression>
<ParameterRef>
<ParameterName>Site Sitedesc</ParameterName>
</ParameterRef>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:FilterCondition" />
</CustomProperties>
</Expression>
</Arguments>
</Function>
<CustomProperties>
<CustomProperty Name="qd:Filter" />
<CustomProperty Name="qd:ContextEntityID">
<Value xsi:type="xsd:string">G1280fedf-af4f-49d1-aa49-2896355b521f</Value>
</CustomProperty>
<CustomProperty Name="qd:AutoChangeBaseEntity" />
<CustomProperty Name="qd:Design">
<Value xsi:type="xsd:string">expr2</Value>
</CustomProperty>
</CustomProperties>
</Expression>
</Filter>
</Hierarchy>
</Hierarchies>
<Parameters>
<Parameter Name="Itemno Itemno">
<DataType>String</DataType>
<Nullable>true</Nullable>
</Parameter>
<Parameter Name="Site Sitedesc">
<DataType>String</DataType>
<Nullable>true</Nullable>
</Parameter>
</Parameters>
</SemanticQuery>
