I have two stored procedures in one report. My main stored procedure is procSSFTP_RPT_WorkAndRestD
and 2nd stored procedure name is procSSFTP_RPT_GetCrewComme
I want to display "Seafarer name" from my 1st stored procedure and "comments" from 2nd stored procedure.
I have multiple rows for the comments against the single seafarer name.
Instead of showing multiple rows of comments for single "seafarer name", I want to display one comment per "seafarer name".
Attached is the report for your reference