Need Tax Breakup in Crystal Report

[Former Member]

HI Experts,

I need Tax Breakup in Crystal Report.

I have TAX CODE VAT 17.5%

TAX CODE 17.5% Include VAT 15% AND VAT 2.5% which is calculated on base amount.

Ex:

Base Amount           = 2000

Input VAT 15%         = 300

Add input VAT 2.5%  = 50

Total tax VAT 17.5% = 350

Grand Total :           = 2350

[former_member184146]

Hi,

     Use the sub report for Tax Breaking , in your sub report pick the Tax table then insert that sub report into main report at the place of Tax Part.

Regards,

Manish

[Former Member]

Hi Manish

I also try this in sub report but i m not get required output in sub report.

Thanks,

Amitgiri

[former_member184146]

can you post your sub query and screen shot of your sub report.

Regards,

Manish

[Former Member]

hi manish

  I'll give you update in sometime. i'll send my sub report as soon as possible

[Former Member]

Hi Manish

If possible by you.

Please give me ur email id.

I send my sub report on your email.

Thanks,

Amit

[former_member184146]

This message was moderated.

[former_member183424]

Dear and

Asking for and sharing an email id is not allowed in SCN. Never share your personal information in public forum. If you want to share your personal information, then make it visible in your profile and tell other user to take the information from your profile.

Never post such information in discussion/blog/document's content.

[Former Member]

Hi Dibyendu Patra.

  I do the same for next time.

Thanks,

Amit

[raghavendra_hullur]

Hi,

Are you trying to display the tax breakup values in detail section?

In case you haven't got the solution yet, try this:

Create a formula (say vat_percent_15) with below code:

{field with total tax at 17.5%} - ({field with total tax at 17.5%} * (2.5/17.5))

Above formula will give you value for 15% tax value

Now, create another formula (say vat_percent_2.5) with below content:

{field with total tax at 17.5%} - {formula created above for 15% vat})

This will give you 2.5% vat value.

Display the formulae in detail section as 15% and 2.5% tax breakups

In case you have varying tax values (i.e not always 17.5% with 15% and 2.5% breakup), then you can replace 17.5 and 2.5 in first formula with actual total tax and lower value of the 2 breakup taxes.

Hope this is what you are looking for.

Thanks,

Raghavendra

[Former Member]

Hi

I create a sub report for Tax Break up.

but how can i link my sub report to my main report.

requirement are i report give a all tax details in my sub report which apply on marketing document.

[raghavendra_hullur]

Hi,

Do you need to pass any information from main report to sub report? Or do you want to filter your sub report using a field from main report?

Which field data needs to be passed from main report to sub report?

Thanks,

Raghavendra

[Former Member]

Hi,

Yes I need to pass the data from Main report to subreport.

Only the tax data applied on lineitem has to be fetched from main report to subreport.

thanks,

Amit

[raghavendra_hullur]

So, you want to pass line item details from main report to sub report?

Try these steps:

1. Right click on the sub report you have included.

2. Select option "Change Sub Report links".

3. From "Available Fields" section, select the main report database field for Line Item and move it to section "Field(s) to link to"

4. Now you can see that there will be 2 additional sections below will be enabled.

5. Link the main report field using the required field from "Report Fields" dropdown on lower right corner by selecting the checkbox for "Select data in sub report based on field:" option.

Hope this is what you are looking for.

Thanks,

Raghavendra