Report Filter issue

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

 

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:""