I am unable to change the period, can anybody help regarding the same..... Thanks [#Menu: Gateway of Tally] Item: "Batch Wise Item Summary" : Display Collection : Batch Report [Collection : Batch Report] Collection: MyBodyPart Variable: MyVar Report: ItemReport Trigger: MyTrigger Title: "List Of Batch's" Full Height: Yes Align: Center [Variable: MyVar] Type: String [Report: MyTrigger] Form : TriggerForm Variable: MyVar Title: "Select Batch Name" [Form: TriggerForm] Parts: TriggerPart Height: 100% Page Width:10% Page [Part: TriggerPart] Lines: TriggerLine [Line: TriggerLine] Field: TriggerField [Field: TriggerField] Use: Name Field Table: BatchReport SubForm :Item Report Show Table: Always Variable: MyVar Modifies: MyVar [Report: Item Report] Form : ItemForm Set : bename : $$batchfilter ;Set : SVFromDate : $$MonthStart$LastVoucherDate:Company:##SVCurrentCompany ;Set : SVToDate : $$MonthEnd:$LastVoucherDate:Company:##SVCurrentCompany [Form: ItemForm] Parts: ItemTitlePart, ItemBodyPart Button: ChangePeriod, PrintButton, ExportButton
Report: Item Report] Form : ItemForm Set : bename : $$batchfilter Set : SVFromDate : $$MonthStart:$LastVoucherDate:Company:##SVCurrentCompany Set : SVToDate : $$MonthEnd:$LastVoucherDate:Company:##SVCurrentCompany OR Set : SVFromDate :##SVFromDate
send to nehalsofttech@gmail.com along with dummy data and screenshot with explanations.... will look into it....as time permits....it is AUDIT season for me.
I solved the system wide period change issues.... Not yet worked on the period wise data collection... will do in a day or two at the weekend..
Hello Johar Sir, Amit sir is a very busy person So, I think you have to wait patiently And You can try it on your own ...to apply date filter in collection you can use Parm Var attribute at collection level Example: [Collection: Example] Parm Var: SvFromDateate:"01-01-18" Parm Var:SvToDateate:"01-01-20" Type: Voucher: VoucherType Child of: $$VchTypeSales
Amit Sir, Thankyou for your valuable time and effort you did on my said TDL, Iam also trying to find out the error as to why the said period data is not getting retrieved. thanks a lot Johar
Maybe will work in coming weekend..... but I think it is due to collection. Your data is being retrieved from another collection of BATCHES.... Will have to check further.....let's see.
Amit Sir If He is using some other collection then You can paas date parameters in the source Collection Right ?
I tried that also..........PARM VAR : SVFFromDate .............not working.......... As per my logic .... There is a LOOP in the initial collection and hence Date is not computing. The Report is being called by a TRIGGER as well as through a Field.
You tried like This? Parm Var: SvFromDateate:##SvFromDate Parm Var:SvToDateate:##SvToDate If Yes then Try like this Parm Var: SvFromDateate:#SvFromDate Parm Var:SvToDateate:#SvToDate
Yep...both ways....also tried user defined "From / TO" date fields with ---- variable and udf methods both.
Not Really, Because Amit Sir is more knowledgeable than Me So, If he is struggling to solve it then I don't think I can solve it