How to display different subreports based on data in main report

[deepakg27]

Hi Guys,

I am trying to make a Invoicing database. I have created a rptbill in report format based on qryBill. It is going to have to 2 Sub Reports. First One is SaleDetails, which is all ok. Second one is rptSaleTax, now different types of Tax Reports (Two Types Only) need to be displayed based on the location Code of the buyer , which is displayed on main report , for which the value is take from tblBuyer. Is there a way to displayed one type on report based on buyer Location.

OR

I was also wondering, can I display data from qrySaleTax in rptBill directly (not as a sub report).

Looking forward to your help and guidance.
Thanks and Regards


Deepak Gupta

[ranman256]

make 3 sub rpts
both subTax rpts are invisible,
then in the ON PRINT event of the detail (or where ever the subReports sit), turn on the one you want

if txtTax = 1 then
    subTax1.visible =true
else
    subTax2.visible =true
endif

[deepakg27]

Thanks worked perfectly