How to create calcu...
 
Notifications
Clear all

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

2 Posts
2 Users
0 Likes
93 Views
stepan.len@apriorit.com
Posts: 1
Topic starter
(@stepan-lenapriorit-com)
New Member
Joined: 1 month 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
Dotnet Report
Posts: 28
Admin
(@admin)
Member
Joined: 10 months 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: https://dev.azure.com/dotnetreport/DotnetReportRoadMap/_workitems/edit/14/

 

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

 

Thanks

Reply
Share: