Unable to retrieve TypeId from DocuRef table for SSRS report

[dech]

I see in your code if startDateTime contains current 2019 year then endDateTime should contain the date of 2018 year:

endDateTime     = DateTimeUtil::addYears(startDateTime, -1);

Here you substract the value of 1 year from startDateTime and assign result to endDateTime. Such conditions do not allow you to get something else than nothing.

Цитата:

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

I think the while select statement looks correct.

No, it doesn't look correct. Due to your current conditions in a case when docuRef.TypeId != #SPP you should pull the records for any company (RefCompanyId) and any table (RefTableId). I'm sure you pulled the records with empty TypeId field right for this case. Enclose following code in additional braces and you will see the difference.

             (docuRef.createdDateTime >= startDateTime   &&
              docuRef.createdDateTime <= endDateTime     &&
              docuRef.TypeId == #SPP) || docuRef.TypeId != #SPP

P.S. if endDateTime is current date and time you can omit this condition and wrinte only

docuRef.createdDateTime >= startDateTime