on 02-24-2024 5:06 AM
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
User | Count |
---|---|
77 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.