Aranha Posted February 25, 2019 Report Share Posted February 25, 2019 Hi there! Im referring to the Video to the manyToMay-Relationships from Caspio on Youtube: https://www.youtube.com/watch?v=7D8u6Lb2BKU Let say I want to have Gallery-Report of all Patients, but I want see in the report the names of all Doctocs they visit. How to build a View for this report? So far I only get for any Visit a new Item in the Report.Thank for any hint! CheersAranha Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted February 28, 2019 Report Share Posted February 28, 2019 Just to see the name of the doctors you can add a Calculated field and use SQL to read the name of the doctors from visit SELECT CAST(Doctor_Name as nvarchar) + N' | ' FROM Visist_Table WHERE Patient_ID = target.[@field:Patient_ID] for xml path(N'') All the red tests need to be replaced with the actual value in the table. The only one that should be selected from picker is [@field:Patient_ID] Quote Link to comment Share on other sites More sharing options...
0 Aranha Posted March 1, 2019 Author Report Share Posted March 1, 2019 Hi May. Wow, that I can paste SQL in Calculated fields is new for me. That expands the horizon! I'll try that one! Awesome. Thanks a lot! Cheers Aranha Quote Link to comment Share on other sites More sharing options...
Question
Aranha
Hi there!
Im referring to the Video to the manyToMay-Relationships from Caspio on Youtube:
https://www.youtube.com/watch?v=7D8u6Lb2BKU
Let say I want to have Gallery-Report of all Patients, but I want see in the report the names of all Doctocs they visit.
How to build a View for this report?
So far I only get for any Visit a new Item in the Report.
Thank for any hint!
Cheers
Aranha
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.