Changes for page Менеджер вычислительных колонок
Last modified by Alexey Voronov on 2023/11/27 13:29
From version 2.1
edited by Andrey Palmin
on 2020/06/25 07:59
on 2020/06/25 07:59
To version 3.1
edited by Andrey Palmin
on 2021/12/15 12:48
on 2021/12/15 12:48
Change comment: There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -2,19 +2,6 @@ 2 2 (ex. Товар("Норма отгр."; [Код] ) ) - подтянет норму отгрузки по Коду. 3 3 4 4 5 -А так можно sql запрос встроить - 6 -getany(8,'select 7 -case when NN.T_N=2 then 8 - case when ( 9 - Select top 1 tc.Value 10 - from taiEnumData tc 11 - WHERE tc.idEnum = 112 and tc.ValueAdd like cast(NN.From_ as varchar)+';%' 12 - ) is not null then 13 - 'ЛОМ АКБ' else 'РЕАЛИЗАЦИЯ' 14 - end 15 -join SklPickB Box ON Box.Nak_D_Reg = NN.D_Reg and Box.idList = :P1', 16 -DATA.№Коробки) 17 - 18 18 Функция Find просит указать TT_ID 19 19 CT_BNK = 1; ~/~/ Банки 20 20 CT_FND = 2; ~/~/ Фонды ... ... @@ -28,3 +28,17 @@ 28 28 CT_TOV =10; ~/~/ Товары 29 29 CT_CAR =11; ~/~/ Транспорт 30 30 CT_SVC =12; ~/~/ Услуги 18 +\\ 19 + 20 +А так можно sql запрос встроить в quickReport - 21 +getany(8,'select 22 +case when NN.T_N=2 then 23 + case when ( 24 + Select top 1 tc.Value 25 + from taiEnumData tc 26 + WHERE tc.idEnum = 112 and tc.ValueAdd like cast(NN.From_ as varchar)+';%' 27 + ) is not null then 28 + 'ЛОМ АКБ' else 'РЕАЛИЗАЦИЯ' 29 + end 30 +join SklPickB Box ON Box.Nak_D_Reg = NN.D_Reg and Box.idList = :P1', 31 +DATA.№Коробки)