estimate document
Submitted by david_cloudegic on Tue, 26/05/2020 - 00:02
Hi,
Am having a challenge on estimate document. The zeros on the amount are being stripped off
see attached pdf and screenshot
Re: estimate document
You will need to modify the Estimate Items.jrxml or Estimate Items-PT.jrxml for the document size you are using.
You can either increase the field width for the Low and High amount columns, or reduce the font size to allow more characters, or do a combination of both.
The templates are located in <OPENVPMS_HOME>/reports/Customer/Estimate/<size>/ e.g.:
If you have selected Use Product Types in Letterhead & Document Control you need to modify Estimate Items-PT.jrxml.
The .jrxml files are edited using Jaspersoft Studio 6.2.0 or higher: https://community.jaspersoft.com/project/jaspersoft-studio/releases
The updated template needs to be uploaded via Administration - Templates to the Document Template named Estimate Items
See also:
Re: estimate document
am getting the below error;
am using jasper 6.12
Re: estimate document
Try setting Source .jrxml Version compatiblity to JasperReports 6.2.0.
This is done via Window - Preferences - Jaspersoft Studio - Compatibility
Re: estimate document
this is what am getting;
1. Warning : Element bottom reaches outside band area : y=2 height=20 band-height=15
2. Warning : Element bottom reaches outside band area : y=2 height=25 band-height=15
3. Warning : Element bottom reaches outside band area : y=0 height=100 band-height=13
4. Warning : Element bottom reaches outside band area : y=0 height=50 band-height=13
This is needed by report: Estimate Items-PT.jrxml
Re: estimate document
It looks like you've added an empty subreport to Estimate Items.
Also, those warnings indicate that the fields are too big for the band they are in.
If you can't get it to to work with the JasperSoft Studio version you are running, try downgrading to version 6.6.0.
Re: estimate document
i have tried to tweak the .jrxml file but still seeing the same error. See the attached file.
Re: estimate document
Hey,
I have edited the PT document uploaded with no error but still am getting the High Total and low Total amounts being "cut" or stripped
Re: estimate document
If they are being truncated, the field width isn't big enough to display them.
You need to increase width of the affected fields, or reduce the font size, or both.
Re: estimate document
Thanks alot, am playing with fields size. I will update you how the final document looks.
Re: estimate document
The estimate document is now okay.
Thanks
Re: estimate document
Hey,
I would like to change the background color of the invoice document. Which document do i edit?
Re: estimate document
See: <OPENVPMS_HOME>/reports/Customer/Invoice/A4
Start with:
You may also need to update: