cancel
Showing results for 
Search instead for 
Did you mean: 

Row Type: Text in Sales Quotation

Former Member
0 Kudos

Hi to everyone,

Anyone knows how to make the Row Type: Text to appear when doing a layout in Print layout designer when creating a Sales Quotation so that pre defined text can be displayed

Thanks

Kentish

Accepted Solutions (1)

Accepted Solutions (1)

kvbalakumar
Active Contributor
0 Kudos

Hi Kentish,

First of all remove the Background colour for all fields in the Repetitve Area and do the following

1. Create a database field (let it be F_1) in Repetitve area, 
  Table - 'QUT1' and Column - 'Row Type'
2. Create a formula field (F_2) in Repetitve area 
   with this formula: F_1 == 'T'
3. Create a database field (F_3) in Repetitve area, 
  Table - 'QUT10' and Column - 'Row Text'

Now hide the fields F_1 and F_2

Hope this helps.

Regards,

Bala

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Bala,

its so good there is an answer for the PLD but do you have an idea when creating a Crystal report on this? I'm doing crystal report form for Sales quotation and there is a type for text.  I put details on the text type but when i view the crystal report layout it doesn't show. Hope you can help me on this.

Thank you.

Louie Pio

former_member196081
Active Contributor
0 Kudos

Hi,

In PLD ,Make a field of database type .now on property window click on content tab,

select table " sales quotation -row" and column is " free text"

if this table is not displaying then go to field press alt button and hold then double click on table field in properties window

Hope helps you