Dear Admin & Experts, I am Developed module for colonizer. in a report first filter is working correct but in second filter button is not working properly. pls guide me. here i share screen shoot of the report & code of the filter button. ;;=================This is button for filter colony wise data===== [Button : Colony] Key : CTRL+C Action : Alter:ColonyRepFltr [Report : ColonyRepFltr] Form : ColonyRepFltr [Form : ColonyRepFltr] Part : ColonyRepFltr [Part : ColonyRepFltr] Line : ColonyRepFltr [Line : ColonyRepFltr] Field : Medium Prompt,ColonyRepFltr Local:Field:Medium Prompt:Set as:"Select Colony" [Field : ColonyRepFltr] Use : Name Field Table : ListofColony,All Colony Show Table : Always Width : 27 Modifies : VarColonyName:Yes [Variable : VarColonyName] Type : String [System : Variable] VarColonyName:"" [Collection:ListofColony] Type :Group Child Of :"Colony" Belongs To :Yes Fetch :Name Format :$Name,30 ;;=====================End the colony filter button==================== ;;=================This is button for filter Broker wise data===== [Button : Broker] Key : CTRL+B Action : Alter:BrokerRepFltr [Report : BrokerRepFltr] Form : BrokerRepFltr [Form : BrokerRepFltr] Part : BrokerRepFltr [Part : BrokerRepFltr] Line : BrokerRepFltr [Line : BrokerRepFltr] Field : Medium Prompt,BrokerRepFltr Local:Field:Medium Prompt:Set as:"Select Broker" [Field : BrokerRepFltr] Use : Name Field Table : ListofBroker,All Broker Show Table : Always Width : 27 Modifies : VarBrokerName:Yes [Variable : VarBrokerName] Type : String [System : Variable] VarBrokerName:"" [Collection:ListofBroker] Type : Ledger Belongs To : $$GroupSundryCreditors Child Of : "Broker" Belongs To : Yes Fetch : Name Format : $Name,30
Without tally data -- cannot be checked ---- You have 2 variables and both variable call on a Different report -------- you will need to incorporate in same report by using OPTION -- based on selected variable.
Dear Amit Ji, Can you pls give me your mail id i will send you data & tdl file. Thanks & Regards, Mani
Perhaps you take help of this To filter the report in this transporterwise loadmanwise borker wise used all three http://tdlexpert.com/index.php?threads/party-wise-broker-report-tdl.7866/#post-33620
Hi, Is there Any Expert to help me out in the above issue pls, Awaiting for your valuable replay. Mani
[Field : BrokerRepFltr] Use : Name Field Table : ListofBroker,All Broker Show Table : Always Width : 27 Variable : VarBrokerName Modifies : VarBrokerName [Collection:ListofBroker] Type : Ledger Belongs To : $$GroupSundryCreditors Child Of : "Broker" Belongs To : Yes Fetch : Name Format : $Name,30 Filter :BrokerWise [System:Formula] BrokerWise : If $$IsEndOfList:##VarBrokerName or ##VarBrokerName="" Then $BrokerName Else ##VarBrokerName [Variable:VarBrokerName] Type : String [System:Variables] VarBrokerName:""