Crystal Report Parameter for assigned branches

[Fedias]

Hi.

Is there any way to have a parameter in my Crystal Report filtered with the assigned to the user branches?

I am using the following query but brings the dropdown empty

SELECT T0."BPLId", T0."BPLName", T1."UserCode" FROM OBPL T0 INNER JOIN USR6 T1 ON T0."BPLId" = T1."BPLId" WHERE T1."UserCode" ='printbyusername@' //Tried also without quotes.

[former_member11696]

What version of CR and what database are you connecting to?

[Fedias]

Hi Don

We are using crystal 2016 and SAP Business One Hana v10 FP2011