cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report assigned Users Branches

SayEangKheang
Explorer
0 Kudos

Hi Everyone.

Is there any way to have a parameter in my Crystal Report filtered with branches assigned to users? I want to get values list down branch base on users login.

I am using the following query but brings empty the dropdown.

Code3@SELECT T1."BPLId", T0."BPLName" FROM OBPL T0 INNER JOIN USR6 T1 ON T0."BPLId" = T1."BPLId" INNER JOIN OUSR T2 ON T1."UserID"=T2."USERID" WHERE T2."U_NAME"= '@printbyusername'

I try crystal report 2016 and SAP Business One V10.2208

SAP Crystal ReportsSAP Business One, version for SAP HANA

Accepted Solutions (0)

Answers (0)