Skip to Content
0
Mar 16, 2021 at 09:51 PM

Crystal Report Parameter for assigned branches

67 Views

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.