Hello Ma'am/Sir!

Please help me create a script that will print only the filled out field in my Official Receipt layout when I click the Print OR  button.

Here is my client's info in Layout Mode:

and this is it in Browse Mode

What I need is that in OFFICIAL RECEIPT Layout will be like this that the empty fields will not be printed:

THANK YOU VERY MUCH in advanced in helping me.

P.S.: I have only little knowledge in scripting.

I would not put fields on your receipt in this case I would write the following script that sets a global variable. And print that, by using tab stop. 

List (

Case ( not IsEmpty ( sample::FCCT ) ; "Fire Code Construction Tax" & Char (9) & sample::FCCT );
Case ( not IsEmpty ( sample::RealtyTax ) ; "Fire Code Realty Tax" & Char (9) & sample::RealtyTax );
Case ( not IsEmpty ( sample::PremiumTax ) ; "Fire Code Premium Tax" & Char (9) & sample::PremiumTax );
Case ( not IsEmpty ( sample::SalesTax ) ; "Fire Code Sales Tax" & Char (9) & sample::SalesTax );
Case ( not IsEmpty ( sample::ProceedsTax ) ; "Fire Code Proceeds Tax" & Char (9) & sample::ProceedsTax );
Case ( not IsEmpty ( sample::FSIF ) ; "Fire Safety Inspection Fee" & Char (9) & sample::FSIF );
Case ( not IsEmpty ( sample::StorageFee ) ; "Storage Clearance Fee" & Char (9) & sample::StorageFee );
Case ( not IsEmpty ( sample::ConveyanceFee ) ; "Conveyance Clearance Fee" & Char (9) & sample::ConveyanceFee );
Case ( not IsEmpty ( sample::InstallationFee ) ; "Installation Clearance Fee" & Char (9) & sample::InstallationFee );
Case ( not IsEmpty ( sample::AdminFine ) ; "Administrative Fine" & Char (9) & sample::AdminFine );
Case ( not IsEmpty ( sample::OthersFee ) ; "Total Other Fees" & Char (9) & sample::OthersFee )

)

Consider changing your structure and turning all those taxes and fees into individual payment records in a related table, with fields for Category and Amount. Then create records only for applicable categories and print from the related table in list view.

This will not only solve your printing issue but also allow you to produce a report on payments by category.

 

Thank you mate for your response. Appreciate it. I will try this and give you feedback. :-)

On 5/14/2021 at 8:22 AM, Ocean West said:

I would not put fields on your receipt in this case I would write the following script that sets a global variable. And print that, by using tab stop. 

List (

Case ( not IsEmpty ( sample::FCCT ) ; "Fire Code Construction Tax" & Char (9) & sample::FCCT );
Case ( not IsEmpty ( sample::RealtyTax ) ; "Fire Code Realty Tax" & Char (9) & sample::RealtyTax );
Case ( not IsEmpty ( sample::PremiumTax ) ; "Fire Code Premium Tax" & Char (9) & sample::PremiumTax );
Case ( not IsEmpty ( sample::SalesTax ) ; "Fire Code Sales Tax" & Char (9) & sample::SalesTax );
Case ( not IsEmpty ( sample::ProceedsTax ) ; "Fire Code Proceeds Tax" & Char (9) & sample::ProceedsTax );
Case ( not IsEmpty ( sample::FSIF ) ; "Fire Safety Inspection Fee" & Char (9) & sample::FSIF );
Case ( not IsEmpty ( sample::StorageFee ) ; "Storage Clearance Fee" & Char (9) & sample::StorageFee );
Case ( not IsEmpty ( sample::ConveyanceFee ) ; "Conveyance Clearance Fee" & Char (9) & sample::ConveyanceFee );
Case ( not IsEmpty ( sample::InstallationFee ) ; "Installation Clearance Fee" & Char (9) & sample::InstallationFee );
Case ( not IsEmpty ( sample::AdminFine ) ; "Administrative Fine" & Char (9) & sample::AdminFine );
Case ( not IsEmpty ( sample::OthersFee ) ; "Total Other Fees" & Char (9) & sample::OthersFee )

)

Thank you mate for your response. Appreciate it. I will try this and give you feedback. :-)

On 5/14/2021 at 1:18 PM, comment said:

Consider changing your structure and turning all those taxes and fees into individual payment records in a related table, with fields for Category and Amount. Then create records only for applicable categories and print from the related table in list view.

This will not only solve your printing issue but also allow you to produce a report on payments by category.

 

Thank you mate for your response. Appreciate it. I will try this and give you feedback. :-)