Сообщение от
KKNDSTER
>>>Рекомендую полученный rdl файлик открыть блокнотом и посмотреть что там >>>не так. Внутренняя структура файла - XML и ничего военного в себе не >>>содержит.
Проблема в том, что все датасеты открываються, кроме ЭТОГО конкретного!
Там вот такой вот запросик:
DECLARE @SQL nvarchar(max)
SET @SQL = 'select new_paymentorder0.new_textoriginaltypecosts as ''new_textoriginaltypecosts'', new_paymentorder0.new_textoriginalcodecost as ''new_textoriginalcodecost'', new_paymentorder0.new_paymentsumma_base as ''new_paymentsumma_base'', new_paymentorder0.crm_moneyformatstring as ''crm_moneyformatstring'', new_paymentorder0.new_paymentsumma as ''new_paymentsumma'', new_paymentorder0.new_paymentdata as ''new_paymentdata'', new_paymentorder0.new_name as ''new_name'', new_paymentorder0.new_paymentorderid as ''new_paymentorderid'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_artificialname as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_artificialname'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_artificial as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_artificial'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_suppliername as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_suppliername'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_supplier as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_supplier'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_officename as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_officename'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_office as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_office'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.customeridname as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_customeridname'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.customerid as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_customerid'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_invoicedate as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_invoicedate'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_paymentdate as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_paymentdate'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.title as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_title'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_invoiceamount_base as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_invoiceamount_base'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.crm_moneyformatstring as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_crm_moneyformatstring'', new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.new_invoiceamount as ''new_paymentorder_new_platejnoe_poruchenie_incident_incidentid_new_invoiceamount'', new_paymentorder_transactioncurrencyid_transactioncurrency_transactioncurrencyid.currencyname as ''new_paymentorder_transactioncurrencyid_transactioncurrency_transactioncurrencyid_currencyname'' from ('
+ @CRM_FilteredNew_paymentorder + ') as new_paymentorder0 left outer join FilteredIncident as new_paymentorder_new_platejnoe_poruchenie_incident_incidentid on (new_paymentorder0.new_platejnoe_poruchenie = new_paymentorder_new_platejnoe_poruchenie_incident_incidentid.incidentid) left outer join FilteredTransactionCurrency as new_paymentorder_transactioncurrencyid_transactioncurrency_transactioncurrencyid on (new_paymentorder0.transactioncurrencyid = new_paymentorder_transactioncurrencyid_transactioncurrency_transactioncurrencyid.transactioncurrencyid) order by new_paymentorder0.new_paymentdata asc'
EXEC (@SQL)
И вот что выдает:
Вложение 4910