I am trying to create an boolean expression on selective vendor bill get to My Report.
i want that which i select vendor name(boolean) get report vendor name raw field data which i selected not all vendor data.
please suggest me.
*This post is locked for comments
Can you elaborate more what will be your condition for displaying the vendor name?
You query is little confusing and hard to understand, but looks like you are want to populate a variable based on other variable which you can accomplish by using simple IF or CASE statement.
Hello, I think its a custom table, but you can do also.
write some logic, like
If ven1 then
Stock.Setrange(VendorNo, vendor1)
Else If ven2 then
Stock.Setrange(VendorNo, vendor2)
Else If ven1 then
Stock.Setrange(VendorNo, vendor1)
Note:
For better, update an excel sheet with all data, and in another sheet put what you want to get that data only.
So we can update you.
dataitem : stock : <stock>
column : "stock",bill date :<bill date.>
column : "stock",bill no. :<bill no.>
column : "stock",vendor name :<vendor name>
column : "stock",item :<item>
colum : venr1 vendor1
column : ven2 vendor2
column : ven3 vendor3
ven1,ven2 and ven3 is Boolean Varriables.
Hello comyash,
I'm unable to say exact, because we don't know your report, but you can do something like, Use Setrange,
Setrange(BooleanField,TRUE);
FINDSET;
Note: Based on your Report you have to set filters, You can also use SETTABLEVIEW and then USE RUNMODAL.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (