Display field based on Status on Report

liizz · **Posted:** Fri Jun 22, 2012 11:42 am

Hi all,

I have a report based on Sales Shipment Header and Sales Shipment Line.

I have defined a boolean field in the Sales Shipment Header namely Status.

IF Status = TRUE THEN
display the variable field (the description from item table)
else do not display it

Please help me.

Thanks
Liizz

mohana_cse06 · **Posted:** Fri Jun 22, 2012 11:49 am

you mean the caption also or only the data?

imclever1205 · **Posted:** Fri Jun 22, 2012 11:54 am

Hello,

First you have to get the Item Description from the Item Table.
Then assign it to an array.
Then using your condition,it should look like that :

If status= TRUE then
array[1]:=item.description
else
array[1] :=item.description;

gerrykistler · **Posted:** Fri Jun 22, 2012 11:57 am

Make a variable ItemDesc, put this in the section of your report and then use this code:

Code: Select all

If Status then
  ItemDesc := Item.Description
else
  ItemDesc := '';

navuser1 · **Posted:** Fri Jun 22, 2012 11:58 am

IF Status THEN
yourVariable := Record.Field
ELSE
yourVariable :='';

Or

If you are using a print section for Report then use the following code sample in OnPreSection() trigger:

CurrReport.SHOWOUTPUT(Status)

faizguy84 · **Posted:** Fri Jun 22, 2012 12:07 pm

imclever1205 wrote:

Hello,

First you have to get the Item Description from the Item Table.
Then assign it to an array.
Then using your condition,it should look like that :

If status= TRUE then
array[1]:=item.description
else
array[1] :=item.description;

No need to create array, simple variable will do as explained by gerrykistler.
_______________
Regards,
Faisal Bukhari.

mibuso.com

Display field based on Status on Report

Who is online