Задать макет оформления СКД для детальных записей #736031


#0 by StillEnough
День добрый. Структура отчета СКД следущяя Для каждой из 2 группировок (склад, номенклатура) задал макет группировки и переопределил их вывод как мне надо. Но получилось так, что моя шапка "уехала" внутрь группировки номенклатура, и отчет выглядит так: мне эта шапка вообще не нужна, как ее убрать? нарисовал макет для детальных записей - одна строка выводимых данных - не прокатило подскажите что еще можно сделать?!
#1 by тарам пам пам
Попробуй задать макет заголовка не для детальных записей, а для группировки "Склад".
#2 by StillEnough
я уж по-разному пытался, никак не правится
#3 by StillEnough
когда устанавливаю макет по имени группировки - он не работает! только по полю! но для детальных записей нельзя указать поле, значит я не могу переопределить макет!
#4 by DirecTwiX
Так в же всё работает -.-
#5 by StillEnough
надо сделать вот так сверху заголовок я нарисовал, он выводиться. а вот как из группировки убрать - проблема
#6 by DirecTwiX
У тебя три группировки, а макет заголовка один. Первое, что пришло в голову.
#7 by StillEnough
ну вообще 2 заданы. А третий никак не могу переопределить, смотрите
#8 by DirecTwiX
У меня получилось :) Запрос из схемы:
#9 by DirecTwiX
Самое главное забыл..
#10 by StillEnough
волшебно.... можете на почту скинуть, уважаемый?
#11 by DirecTwiX
Отправил Либо вот: [1C]<?xml version="1.0" encoding="UTF-8"?> <DataCompositionSchema xmlns="; xmlns:dcscom="; xmlns:dcscor="; xmlns:dcsset="; xmlns:v8="; xmlns:v8ui="; xmlns:xs="; xmlns:xsi=";     <dataSource>         <name>ИсточникДанных1</name>         <dataSourceType>Local</dataSourceType>     </dataSource>     <dataSet xsi:type="DataSetQuery">         <name>НаборДанных1</name>         <field xsi:type="DataSetFieldField">             <dataPath>Группировка1</dataPath>             <field>Группировка1</field>         </field>         <field xsi:type="DataSetFieldField">             <dataPath>Группировка2</dataPath>             <field>Группировка2</field>         </field>         <field xsi:type="DataSetFieldField">             <dataPath>Рек1</dataPath>             <field>Рек1</field>         </field>         <field xsi:type="DataSetFieldField">             <dataPath>Рек2</dataPath>             <field>Рек2</field>         </field>         <field xsi:type="DataSetFieldField">             <dataPath>Рек3</dataPath>             <field>Рек3</field>         </field>         <dataSource>ИсточникДанных1</dataSource>         <query>ВЫБРАТЬ     1 КАК Группировка1,     2 КАК Группировка2,     "А" КАК Рек1,     "Б" КАК Рек2,     "В" КАК Рек3 ОБЪЕДИНИТЬ ВСЕ ВЫБРАТЬ     1,     2,     "А",     "Z",     "W" ОБЪЕДИНИТЬ ВСЕ ВЫБРАТЬ     1,     3,     "W",     "E",     "R" ОБЪЕДИНИТЬ ВСЕ ВЫБРАТЬ     2,     3,     "W",     "W",     "W" </query>     </dataSet>     <template>         <name>Макет1</name>         <template xmlns:dcsat="; xsi:type="dcsat:AreaTemplate">             <dcsat:item xsi:type="dcsat:TableRow">                 <dcsat:tableCell>                     <dcsat:item xsi:type="dcsat:Field">                         <dcsat:value xsi:type="dcscor:Parameter">Рек1</dcsat:value>                     </dcsat:item>                     <dcsat:appearance>                         <dcscor:item>                             <dcscor:parameter>ЦветФона</dcscor:parameter>                             <dcscor:value xmlns:d8p1="; xsi:type="v8ui:Color">d8p1:MistyRose</dcscor:value>                         </dcscor:item>                         <dcscor:item>                             <dcscor:parameter>СтильГраницы</dcscor:parameter>                             <dcscor:value xsi:type="v8ui:Line" width="0" gap="false">                                 <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">None</v8ui:style>                             </dcscor:value>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Слева</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Сверху</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Справа</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Снизу</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                         </dcscor:item>                     </dcsat:appearance>                 </dcsat:tableCell>                 <dcsat:tableCell>                     <dcsat:item xsi:type="dcsat:Field">                         <dcsat:value xsi:type="dcscor:Parameter">Рек2</dcsat:value>                     </dcsat:item>                     <dcsat:appearance>                         <dcscor:item>                             <dcscor:parameter>ЦветФона</dcscor:parameter>                             <dcscor:value xmlns:d8p1="; xsi:type="v8ui:Color">d8p1:MistyRose</dcscor:value>                         </dcscor:item>                         <dcscor:item>                             <dcscor:parameter>СтильГраницы</dcscor:parameter>                             <dcscor:value xsi:type="v8ui:Line" width="0" gap="false">                                 <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">None</v8ui:style>                             </dcscor:value>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Слева</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Сверху</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Справа</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Снизу</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                         </dcscor:item>                     </dcsat:appearance>                 </dcsat:tableCell>                 <dcsat:tableCell>                     <dcsat:item xsi:type="dcsat:Field">                         <dcsat:value xsi:type="dcscor:Parameter">Рек3</dcsat:value>                     </dcsat:item>                     <dcsat:appearance>                         <dcscor:item>                             <dcscor:parameter>ЦветФона</dcscor:parameter>                             <dcscor:value xmlns:d8p1="; xsi:type="v8ui:Color">d8p1:MistyRose</dcscor:value>                         </dcscor:item>                         <dcscor:item>                             <dcscor:parameter>СтильГраницы</dcscor:parameter>                             <dcscor:value xsi:type="v8ui:Line" width="0" gap="false">                                 <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">None</v8ui:style>                             </dcscor:value>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Слева</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Сверху</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Справа</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Снизу</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="1" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                         </dcscor:item>                     </dcsat:appearance>                 </dcsat:tableCell>             </dcsat:item>         </template>         <parameter xmlns:dcsat="; xsi:type="dcsat:ExpressionAreaTemplateParameter">             <dcsat:name>Рек1</dcsat:name>             <dcsat:expression>Рек1</dcsat:expression>         </parameter>         <parameter xmlns:dcsat="; xsi:type="dcsat:ExpressionAreaTemplateParameter">             <dcsat:name>Рек2</dcsat:name>             <dcsat:expression>Рек2</dcsat:expression>         </parameter>         <parameter xmlns:dcsat="; xsi:type="dcsat:ExpressionAreaTemplateParameter">             <dcsat:name>Рек3</dcsat:name>             <dcsat:expression>Рек3</dcsat:expression>         </parameter>     </template>     <template>         <name>Макет2</name>         <template xmlns:dcsat="; xsi:type="dcsat:AreaTemplate">             <dcsat:item xsi:type="dcsat:TableRow">                 <dcsat:tableCell>                     <dcsat:item xsi:type="dcsat:Field">                         <dcsat:value xsi:type="v8:LocalStringType">                             <v8:item>                                 <v8:lang>ru</v8:lang>                                 <v8:content>Группировка1</v8:content>                             </v8:item>                         </dcsat:value>                     </dcsat:item>                     <dcsat:appearance>                         <dcscor:item>                             <dcscor:parameter>ЦветФона</dcscor:parameter>                             <dcscor:value xsi:type="v8ui:Color">#7EDDDD</dcscor:value>                         </dcscor:item>                         <dcscor:item>                             <dcscor:parameter>СтильГраницы</dcscor:parameter>                             <dcscor:value xsi:type="v8ui:Line" width="0" gap="false">                                 <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">None</v8ui:style>                             </dcscor:value>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Слева</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="2" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Сверху</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="2" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Справа</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="2" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Снизу</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="2" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                         </dcscor:item>                         <dcscor:item>                             <dcscor:parameter>Шрифт</dcscor:parameter>                             <dcscor:value xsi:type="v8ui:Font" faceName="Calibri" height="10" bold="false" italic="false" underline="false" strikeout="false" kind="Absolute"/>                         </dcscor:item>                     </dcsat:appearance>                 </dcsat:tableCell>                 <dcsat:tableCell>                     <dcsat:appearance>                         <dcscor:item>                             <dcscor:parameter>ОбъединятьПоГоризонтали</dcscor:parameter>                             <dcscor:value xsi:type="xs:boolean">true</dcscor:value>                         </dcscor:item>                     </dcsat:appearance>                 </dcsat:tableCell>                 <dcsat:tableCell>                     <dcsat:appearance>                         <dcscor:item>                             <dcscor:parameter>ОбъединятьПоГоризонтали</dcscor:parameter>                             <dcscor:value xsi:type="xs:boolean">true</dcscor:value>                         </dcscor:item>                     </dcsat:appearance>                 </dcsat:tableCell>             </dcsat:item>             <dcsat:item xsi:type="dcsat:TableRow">                 <dcsat:tableCell>                     <dcsat:item xsi:type="dcsat:Field">                         <dcsat:value xsi:type="v8:LocalStringType">                             <v8:item>                                 <v8:lang>ru</v8:lang>                                 <v8:content>Группировка2</v8:content>                             </v8:item>                         </dcsat:value>                     </dcsat:item>                     <dcsat:appearance>                         <dcscor:item>                             <dcscor:parameter>ЦветФона</dcscor:parameter>                             <dcscor:value xmlns:d8p1="; xsi:type="v8ui:Color">d8p1:PaleTurquoise</dcscor:value>                         </dcscor:item>                         <dcscor:item>                             <dcscor:parameter>СтильГраницы</dcscor:parameter>                             <dcscor:value xsi:type="v8ui:Line" width="0" gap="false">                                 <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">None</v8ui:style>                             </dcscor:value>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Слева</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="2" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Сверху</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="2" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Справа</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="2" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                             <dcscor:item>                                 <dcscor:parameter>СтильГраницы.Снизу</dcscor:parameter>                                 <dcscor:value xsi:type="v8ui:Line" width="2" gap="false">                                     <v8ui:style xsi:type="v8ui:SpreadsheetDocumentCellLineType">Solid</v8ui:style>                                 </dcscor:value>                             </dcscor:item>                         </dcscor:item>                         <dcscor:item>                             <dcscor:parameter>Шрифт</dcscor:parameter>                             <dcscor:value xsi:type="v8ui:Font" faceName="Calibri" height="10" bold="false" italic="false" underline="false" strikeout="false" kind="Absolute"/>                         </dcscor:item>                     </dcsat:appearance>                 </dcsat:tableCell>                 <dcsat:tableCell>                     <dcsat:appearance>                         <dcscor:item>                             <dcscor:parameter>ОбъединятьПоГоризонтали</dcscor:parameter>                             <dcscor:value xsi:type="xs:boolean">true</dcscor:value>                         </dcscor:item>                     </dcsat:appearance>                 </dcsat:tableCell>                 <dcsat:tableCell>                     <dcsat:appearance>                         <dcscor:item>                             <dcscor:parameter>ОбъединятьПоГоризонтали</dcscor:parameter>                             <dcscor:value xsi:type="xs:boolean">true</dcscor:value>                         </dcscor:item>                     </dcsat:appearance>                 </dcsat:tableCell>             </dcsat:item>             <dcsat:item xsi:type="dcsat:TableRow">                 <dcsat:tableCell>                     <dcsat:item xsi:type="dcsat:Field">                         <dcsat:value xsi:type="v8:LocalStringType">
#12 by DirecTwiX
...кусок схемы -.-
#13 by StillEnough
волшебно, но не совсем. Мой макет (как и ваш) при участии ресурсов в СКД не работает, а мне именно ресурсами и надо оперировать...
#14 by DirecTwiX
Нужно было назначать макеты по именам группировок. На почту отправил.
Тэги: 1С 8
Ответить:
Комментарии доступны только авторизированным пользователям

В этой группе 1С