Hello,
I know this might be no-brainer but not able to figure out this problem. So we have a custom POForm ssrs report. Today when we did print preview for few Purchase order we find something weird happening at tax table.
And this is what I am getting in print preview. It should just show up one but it is taking the number of line added in PO.
Please advice.
Thank you for your time.
Those 13 tax lines are for a single PO line? Does the taxable amount equal the PO Line amount?
Does the PO Line have 13 releases?
Is it a mere coincidence that there are 13 lines and the tax amount is 13 percent?
Those 13 lines are for each PO line. That means there are 13 lines added in this PO and in tax table instead of showing one line it is showing for all. In-short, it depends on number of lines in PO. If there are 2 lines added in PO, it will show two line.
About amount to be 13% that is tax rate in Ontario, CA.
Is the order total correct? As in it only adds the tax in once. Or does it add it multiple times.
I’m asking so we can determine if its just displaying wrong or calculating wrong too.
Hi @ckrusen, thank you for you reply.
Yes, order total is correct. It adds tax in once. So, this is something wrong in displaying.
I saw some solution to hide multiple line which were repeating. But now what I am facing is to get rid of the white space when those lines gets hided.
You might need to go to report builder and shorten the report (hover your mouse over the bottom and drag it up, or right click and open the Report Properties window to manually change the height).
If I recall correctly, the tax listing is a subreport. So it might require some changes to both the subreport and the main report.
Just curious does the built-in PO form( the one that Epicor provides) show the same issue?
My first step in debugging forms/reports is to see if the default report (with default RDD) works as expected.
Tried that, but didn’t help.
Thank you though. This has been actually resolved. I had to make “consumewhitespace” property for sub-report as well as main report to true and it worked in my case.
Again, thank you for your time and help. Appreciated.
