Skip to main content
Solved

Report Designer Sales Order Form SO641010 - Output Grid in PDF Format?


Forum|alt.badge.img+5

I am developing what I think should be a pretty straightforward Sales Order form. For the transaction lines, I would like to have a grid format where there is a border around each cell. This works fine if I put a border around each cell in the detailSection1 part of the form (I have adapted this from SO641010.rpx… the out of the box Sales Order printed form for Acumatica).

 

When I preview this in Report Designer, I get my grid with borders and everything is good. However, if I output to PDF, then only some of my vertical borders appear, and no horizontal borders around each cell.

Preview in Report Designer (or in Acumatica with PDF Preview disabled)...

 

Output in PDF Format… grid lines are basically gone

 

I have seen some previous hand wringing about this in other posts. I don’t need this to work perfect (it obviously doesn’t), but I just need A way to do this. If it involves a specific configuration for each individual cell, so be it. But can someone demonstrate a working way to create a simple grid in an Acumatica report that will correctly output in PDF format?

This seems like one of those printed form basics that really does have to work right for an ERP product. Is there some way to do it?

Best answer by ChandraM

Hi @rosenjon Your report is corrected. See below

 

View original
Did this topic help you find an answer to your question?

11 replies

Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • February 7, 2022

Hi @rosenjon Is it possible to upload the report, so that we can review and update you.


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@rosenjon , please let us know which Acumatica version you use. I have this in 2021R2:

So, no issues observed.


Forum|alt.badge.img+5
  • Author
  • Semi-Pro III
  • 293 replies
  • February 7, 2022

@ChandrasekharM …  Report uploaded

 

@yurik05 … Can you please export as PDF and show the same?

 


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@rosenjon , yes, I see it after the export too:

 


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@rosenjon , you need to set up the border width for every cell in the Details section:

You can either use the Default for all sides, or set specific ones for different sides. Just try it on one cell, and you will see results:

This is PDF print out.

Finally, you can create a new style in the template (you would need to open TemplateFormExternal.rpx, and create a new style. And then open the SO641010 and utilize that new style. Let me know if this doesn’t solve your issue and / or if you have other questions!


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • Answer
  • February 7, 2022

Hi @rosenjon Your report is corrected. See below

 


Forum|alt.badge.img+5
  • Author
  • Semi-Pro III
  • 293 replies
  • February 7, 2022

Ok, good to know, thanks Yuri. Let me give that a try and see if it helps.


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • February 7, 2022

@rosenjon  PFA report with borders shown.

 

 


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • February 7, 2022

Hi @rosenjon  FYI, 21R2 report designer was used for the above report.


TimRodman
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 144 replies
  • March 29, 2022

Because of these differences between HTML and PDF (and there are a lot of them), as a general rule, whenever a report is going to get printed, I like defaulting that report to PDF.

In my experience, PDF is more reliable and more consistent between computers.


Forum|alt.badge.img
  • Jr Varsity II
  • 65 replies
  • July 7, 2022

Hi @ChandrasekharM I’m running into a similar issue and was wondering if you’ve come across a solution for it. I have a grid-like view on the rpx file using borders on the individual text boxes and it works fine until one of text boxes in the row ‘grows’ because the text wraps and make that particular box larger than the others. In the image below you can see that one border (attached) to the text box that wrapped the text correctly continues to show the border however, the other borders linked to the other text boxes have gaps between the rows in the grid. Is there maybe a different way to account for the borders or is there a way to make one text box “grow” dependent on another text box? 
 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings