Отчет

[Skyway]

Поменял:

SELECT  TAB,PERS_LINK, FM,IM,OT,DOC_NUM, BIRTHDATE,FilteredNew_com_trans.New_busines_trip_transId,CRMAF_FilteredNew_Business_trip.New_business_tripId, new_date, FilteredNew_com_trans.New_name,  FilteredNew_com_trans.New_loc, FilteredNew_Kind_trans.New_Kind,new_table_num,New_person,  SystemUserId 
FROM  [Kadry].[dbo].[EMPL], [Kadry].[dbo].[PERSON], dbo.FilteredNew_com_trans, dbo.FilteredNew_Kind_trans, [Keysystems_MSCRM].[dbo].[FilteredSystemUser],dbo.FilteredNew_Business_trip AS CRMAF_FilteredNew_Business_trip
WHERE (FilteredNew_com_trans.New_Trans_KindId =FilteredNew_Kind_trans.New_Kind_TransId ) AND (New_person=SystemUserId) AND (FilteredNew_com_trans.New_busines_trip_transId=New_business_tripId) AND NOT (New_busines_trip_transId is NULL) AND (TAB =new_table_num ) AND (PERS_LINK = PERSON.LINK)

Ничего не изменилось

[a33ik]

Цитата:

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

Поменял:

SELECT  TAB,PERS_LINK, FM,IM,OT,DOC_NUM, BIRTHDATE,FilteredNew_com_trans.New_busines_trip_transId,CRMAF_FilteredNew_Business_trip.New_business_tripId, new_date, FilteredNew_com_trans.New_name,  FilteredNew_com_trans.New_loc, FilteredNew_Kind_trans.New_Kind,new_table_num,New_person,  SystemUserId 
FROM  [Kadry].[dbo].[EMPL], [Kadry].[dbo].[PERSON], dbo.FilteredNew_com_trans, dbo.FilteredNew_Kind_trans, [Keysystems_MSCRM].[dbo].[FilteredSystemUser],dbo.FilteredNew_Business_trip AS CRMAF_FilteredNew_Business_trip
WHERE (FilteredNew_com_trans.New_Trans_KindId =FilteredNew_Kind_trans.New_Kind_TransId ) AND (New_person=SystemUserId) AND (FilteredNew_com_trans.New_busines_trip_transId=New_business_tripId) AND NOT (New_busines_trip_transId is NULL) AND (TAB =new_table_num ) AND (PERS_LINK = PERSON.LINK)

Ничего не изменилось

Откуда Вы вызываете отчёт? Из какой именно карточки сущности, которая участвует в отчёте - укажите, пожалуйста, её системное имя (вроде New_Business_trip)