В отчете Сумма Если.... (нужна подсказка)

[slivka_83]

Попробуйте такой вариант...

=Sum(IIF(Fields!<колонка1>.Value = "Хлеб", Fields!<колонка2>.Value, 0) )

[KKNDSTER]

Вот запрос к базе:

SELECT CRMAF_New_paymentorder.new_paymentdata, CRMAF_New_paymentorder.new_originalcodecostname,
CRMAF_New_paymentorder.new_originaltypecostsname, FilteredIncident.new_artificialname, FilteredIncident.new_suppliername,
CRMAF_New_paymentorder.new_platejnoe_poruchenie, FilteredIncident.incidentid, CRMAF_New_paymentorder.new_platejnoe_porucheniename,
FilteredIncident.new_officename, FilteredIncident.customeridname, FilteredIncident.new_invoicedate, FilteredIncident.transactioncurrencyidname,
FilteredIncident.new_paymentamount, CRMAF_New_paymentorder.new_paymentsumma,
CRMAF_New_paymentorder.transactioncurrencyidname AS Expr1, FilteredIncident.new_invoiceamount,
CRMAF_New_paymentorder.new_originalcodecost, CRMAF_New_paymentorder.new_originaltypecosts
FROM FilteredNew_paymentorder AS CRMAF_New_paymentorder INNER JOIN
FilteredIncident ON CRMAF_New_paymentorder.new_platejnoe_poruchenie = FilteredIncident.incidentid

[a33ik]

Цитата:

Сообщение от KKNDSTER

Вот запрос к базе:

SELECT CRMAF_New_paymentorder.new_paymentdata, CRMAF_New_paymentorder.new_originalcodecostname,
CRMAF_New_paymentorder.new_originaltypecostsname, FilteredIncident.new_artificialname, FilteredIncident.new_suppliername,
CRMAF_New_paymentorder.new_platejnoe_poruchenie, FilteredIncident.incidentid, CRMAF_New_paymentorder.new_platejnoe_porucheniename,
FilteredIncident.new_officename, FilteredIncident.customeridname, FilteredIncident.new_invoicedate, FilteredIncident.transactioncurrencyidname,
FilteredIncident.new_paymentamount, CRMAF_New_paymentorder.new_paymentsumma,
CRMAF_New_paymentorder.transactioncurrencyidname AS Expr1, FilteredIncident.new_invoiceamount,
CRMAF_New_paymentorder.new_originalcodecost, CRMAF_New_paymentorder.new_originaltypecosts
FROM FilteredNew_paymentorder AS CRMAF_New_paymentorder INNER JOIN
FilteredIncident ON CRMAF_New_paymentorder.new_platejnoe_poruchenie = FilteredIncident.incidentid

А зачем столько полей в запросе, если в результате получится - 3-4?

[KKNDSTER]

Почему много, это оригинальный запрос. Тут у меня 18 полей.
(про хлеба это просто пример)