Please Help me in a formula

Set As:$LedgerContact:Ledger:$LedgerName

 

or
Set as:$LedgerContact:Ledger:#EiConsignee

 

its not a default report...i create 2 report for contact list like (cipla contact list & reliance contact list)
i want to if i select ledger like "cipla ltd under group "cipla" its showing "cipla contact list" and if i select ledger like "reliance ltd under group "reliance" its showing reliance price list

 

If contact list is a aggregate udf under ledger master report

then aggregate collection should be of
type : Ledger
Childof : $Name

 

This query solved.....but when i select particular ledger "mob no" not fetch in field (mob no is in my own contact list)

[Field: MMSalesmanName]
Use : Name Field
Storage : MMSalesmanName
Set as :$MMSalesmanName
Width : 30
Size : 30
Table : ContactNameCollection,EndOfList@forCIPLA
Table : ContactNameCollectionReliance,EndOfList@forRELIANCE
Show Table: Always

[System: Formulae]
forCIPLA :$Parent:Ledger:$PartyLedgerName = "CIPLA"
forRELIANCE :$Parent:Ledger:$PartyLedgerName = "RELIANCE"

top of the formulae working but below field how to fetch mobile no as per contact name;; below field like this.....

[Field: MobileName Field]
Set as : $$Table:MMSalesmanName:$SalemanMob ;;;;;;its showing only one contact list table(mob no).. how to fetch value as per "contact person"

 

[Field: MMSalesmanName]
Common Table: No


add this also then try

 

Its not working....in set as :?????(as usal) or some changes

 

Use only one table in Table : Statement... you can use "If:"conditional statement to make one of the table applicable for that field...

rest of the field definition is ok.

 

Tell me the "if" formula...I tried but no result

 

Example :

Table : FirstTableColl : #RbcField = "Voucher Field"
Table : SecondTableColl: #RbcField = "Master Field"

result of these two statements is only one table will be selected based on value of field "RbcField"

 

use this type in my "mobile no field"?

 

[Field: MMSalesmanName]

SalesMan Field

Mobile Number field Formula is correct if both tables have the same field/column i.e. $SalemanMob


or modify your formulae

forCIPLA :$Parent:Ledger:$PartyLedgerName = "CIPLA"
forRELIANCE :$Parent:Ledger:$PartyLedgerName = "RELIANCE"


I think $PartyLedgerName is not giving proper value..

 

My problem solve
[Field: MobileName Field]
Set as : $$Table:MMSalesmanName:$SalemanMob + $$Table:MMSalesmanName:$SalemanMobReliance

Can you tell me in a field can i use 2 key for showing different report?

 

[Field: MMSalesmanName]
Use : Name Field
Storage : MMSalesmanName
Set as :$MMSalesmanName
Width : 30
Size : 30
Table : ContactNameCollection,EndOfList@forCIPLA
Table : ContactNameCollectionReliance,EndOfList@forRELIANCE
Key : Create ContactName

[System: Formulae]
forCIPLA :$Parent:Ledger:$PartyLedgerName = "CIPLA"
forRELIANCE :$Parent:Ledger:$PartyLedgerName = "RELIANCE"


[Key: Create ContactName]
Key :Alt + C
Action: Alter: ContactName ;;;;;;its open 1 report.my 2nd report is "ContactNamereliance"how to open if showing reliance contact list

 

[Field : YourField]
Keys : 1stKey, 2ndKey

[Key : 1stKey]
Inactive : #condition

[Key : 2ndKey]
Inactive : #condition

 

Problem wise with your field/Column name in SalesManCollection. Right ?

 

its not working

 

JUST SEE IMAGE WHAT I WANT

 

[Field : YourField]
Keys : 1stKey, 2ndKey

[Key : 1stKey]
Inactive : #condition

[Key : 2ndKey]
Inactive : #condition

Keys which satisfies the condition will work, if both satisfy then both will work

Post your field definition and Key defintions

 

[Fieldartyadd6]
Fields:Simple Prompt, MMSalesmanName
Local:Field:simple prompt : info :$$localestring:"CONTACT PERSON"


[Field: MMSalesmanName]
Use : Name Field
Storage : MMSalesmanName
Set as :$MMSalesmanName
Table : ContactNameCollection,EndOfList@forCIPLA
Table : ContactNameCollectionReliance,EndOfList@forRELIANCE
Show Table: Always
Key : Create ContactName,Create ContactName1

[System: Formulae]
forCIPLA :$Parent:Ledger:$PartyLedgerName = "CIPLA"
forRELIANCE :$Parent:Ledger:$PartyLedgerName = "RELIANCE"


[Key: Create ContactName];;;;;;;;ONLY WORK THIS KEY
Key :Alt + C
Action: Alter: ContactName


[Key: Create ContactName1];;;;;;;THIS KEY NOT WORKING
Key :Alt + C
Action: Alter: ContactNamereliance

 

where is Inactive : # Condition ????

Code:

[Key: Create ContactName];;;;;;;;ONLY WORK THIS KEY
Key :Alt + C
Action: Alter: ContactName
Inactive : @@forRELIANCE

[Key: Create ContactName1];;;;;;;THIS KEY NOT WORKING
Key :Alt + C
Action: Alter: ContactNamereliance
Inactive :  @@forCIPLA

 

Not Working.... only open "ContactName" this report

 

Use Action List

 

i got solutions for this

[Key: Create SalesmanName]
Key :Alt + C
ActionEx: 001 : Do If : @@forCIPLAPricelist : Alter : ContactName
ActionEx: 002 : Do If : @@forRELIANCEPricelist : Alter : ContactNamereliance