boolean expression

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: boolean expression

Can you elaborate more what will be your condition for displaying the vendor name?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 49,418 Super User 2025 Season 2 on at

Like (0)

Report

RE: boolean expression

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.

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: boolean expression

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: boolean expression

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.

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

RE: boolean expression

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.

Was this reply helpful? Yes No