Skip to content
How to create calcu...
Clear all

How to create calculated fields where the calculation contains references to two or more tables?

2 Posts
2 Users
Posts: 1
Topic starter
New Member
Joined: 2 years ago

I have added all tables from the query below. I have added all relations between the tables. How can I add a calculated field to a report using report designer if the field contains references to 2+ tables?

SELECT CONCAT(CP.PayrollId, '-', CI.PayrollId) 'Unique ID' --THE FIELD
FROM EmployeeChangeLog ECL
JOIN EmployeeProfile EP ON EP.EmployeeId = ECL.EmployeeId
JOIN UserProfile UP ON UP.UserProfileId = EP.UserProfileId
JOIN UserCompanies UC ON UC.UserCompanyProfileId = UP.UserProfileId
JOIN UserCompanyInfo UCI ON UCI.UserCompanyProfileId = UC.UserCompanyProfileId
JOIN CompensationInformation CI ON CI.CompensationInformationId = UCI.CompensationInformationId
JOIN CompanyProfile CP ON CP.CompanyId = UC.CompanyId


1 Reply
Posts: 33
Joined: 3 years ago

Hi Stepan, currently dotnet report only supports creating custom fields only from 1 table using the UI. You can create a sql view with the custom field, and then use the view instead of the table. 


Hope this helps. I also added this feature request to our backlog, you can see it here:


You can also follow it to see when this feature is coded and available.