i have design Sales Register

Mohit_B1

Please help
whether i have twice of tax type VAT or CST but when Report Generate i have to need filter tax type .
if i select VAT then only VAT type record appear .
how can write filter for this issue

Mohit_B1

yes sir it is customize report.

Sowkarthika

If you are using Tax Type in Request page then you have to filter as below :

RecPurchaseHeader - OnPreDataItem()
RecPurchaseHeader.SETRANGE(Structure,TaxVar)

Sowkarthika

Is it your custom report ? If the field you are using is part of DataSet in your report then you can filter your report before selecting Preview in your report.

Mohit_B1

RecPurchaseHeader - OnPreDataItem()
IF recdetail.GETFILTER("Tax Type") <> '' THEN
txtOtherfilter := 'Filter By :- ' + recdetail.GETFILTER("Tax Type")

i have write code like this but i didn't get tax type filter.....

Mohit_B1

yes sir it is customize report.

Sowkarthika

If you are using Tax Type in Request page then you have to filter as below :

RecPurchaseHeader - OnPreDataItem()
RecPurchaseHeader.SETRANGE(Structure,TaxVar)

Mohit_B1

i am unable to solve this issue

Mohit_B1

simply i have a table Purch. Inv. Header . that use in my report
but tax type value comes from Table record "'Detailed Tax Entry"
i have get tax type from Detailed Tax Entry table Data has successfully comes but when i am trying to want data tax type - Vat wise then filter not working.

Sowkarthika

Are you using Detailed Tax Entry in your Data Item ? Are you using request page to get Tax Type ?

Mohit_B1

yes sir......

Mohit_B1

i have only Purch. Inv. Header in Data item ..........

Mohit_B1

Expanded Data Type Data Source Name Include Caption
1 DataItem Purch. Inv. Header RecPurchaseHeader No
0 Column RecCompany.Name CompanyName No
0 Column RecPurchaseHeader."No." InvoiceNo No
0 Column RecPurchaseHeader."Posting Date" PostingDate No
0 Column RecPurchaseHeader."Buy-from Vendor No." VendorCode No
0 Column RecPurchaseHeader."Buy-from Vendor Name" VendorName No
0 Column RecVendor."E.C.C. No." ECCNo No
0 Column RecVendor."T.I.N. No." TINNo No
0 Column decBaseAmount BaseAmount No
0 Column decTaxPercentage TaxPercentage No
0 Column decTaxAmount TaxAmount No
0 Column decOtherCharge VendorCharge No
0 Column RecPurLine."Tax %" Dectax No
0 Column taxVATCST taxVATCST No
0 Column TxtDateFilter DateFilter No
0 Column txtLocationfilter LocationFilter No
0 Column txtOtherfilter Otherfilter No
0 Column RecPurchaseHeader."Location Code" LocationCode No

pavithrap0992

Put the 'Tax Type' filter on the request page. Once you get the Tax Type from Detailed Tax Entry table you can hide those rows using visibility option or simply use CurrReport.SKIP with an IF condition.