Показать сообщение отдельно
Старый 19.10.2019, 22:44   #1  
ajlewa is offline
ajlewa
Участник
 
11 / 10 (1) +
Регистрация: 10.08.2015
Отчёт SSRS в CRM 2011 выглядит не так как должен
Коллеги,
Добрый День,
пытаюсь сделать отчёт, в Visual Studio всё выглядит хорошо,
Но Когда добавляю в СРМ некоторые поля отсутствуют, может кто нибудь знает как поправить и где я накосячил?
SQL:
Код:
SELECT TOP 3000     CRMAF_SalesOrder.name AS OrderName, CRMAF_Invoice.name AS InvoiceName, CRMAF_Invoice.new_invoicetypename AS InvoiceType, CRMAF_Invoice.new_actdate AS ActDate, 
                      CRMAF_Invoice.statuscodename AS Status, CRMAF_SalesOrderDetail.productidname AS Product, CRMAF_SalesOrder.customeridname AS Client, CRMAF_SalesOrderDetail.baseamount AS Income, 
                      CRMAF_Product.be_royaltyfee AS Royalty, CRMAF_Product.be_printingcostrus AS PrintingCost,
                          (SELECT TOP 1     extendedamount
                            FROM          FilteredSalesOrderDetail AS deliveryitem
                            WHERE      (productidname = 'Delivery') AND (salesorderid = CRMAF_SalesOrderDetail.salesorderid)) AS DeliveryCost,
                          (SELECT     COUNT(salesorderid) - 1 AS OrderItemCount
                            FROM          FilteredSalesOrderDetail AS itemcount
                            WHERE      (salesorderid = CRMAF_SalesOrderDetail.salesorderid)) AS OrderItemCount
FROM         FilteredSalesOrderDetail AS CRMAF_SalesOrderDetail LEFT JOIN
                      FilteredSalesOrder AS CRMAF_SalesOrder ON CRMAF_SalesOrderDetail.salesorderid = CRMAF_SalesOrder.salesorderid LEFT JOIN
                      FilteredInvoice AS CRMAF_Invoice ON CRMAF_Invoice.salesorderid = CRMAF_SalesOrder.salesorderid LEFT JOIN
                      FilteredProduct AS CRMAF_Product ON CRMAF_SalesOrderDetail.productid = CRMAF_Product.productid
WHERE      (CRMAF_SalesOrderDetail.productidname != 'Delivery')
Результат:
Из Visual Studio: https://imgshare.io/image/jKTwl
Из CRM: https://imgshare.io/image/jKhGx