See nicely formatted version at
Dear freelancers,
Please place a bid if you have done any jasper report related work. You are required to provide sample (PDF or design screenshot) of your portfolio.
Requirements for the job is as follow.
REPORT
Parameters:
- companyName: String
- companyAddress: String
- companyTelephone: String
- companyZipcode: String
- date: Date
- contractNumber: String
- invoiceNumber: String
- supplierName: String
- supplierFullAddress: String
- supplierForeignName: String
- supplierTelephone: String
- supplierFax: String
- portOfLoading: String
- portOfDestination: String
- freightCost: BigDecimal
- sayEnglish: BigDecimal
- paymentTerm: String
- estimatedDeliveryDate: Date
- transactionAmount: BigDecimal
- totalNetWeight: BigDecimal
- totalGrossWeight: BigDecimal
- totalPackageQuantity: BigDecimal
- sayTotalPackageQuantity: String
- currency: String
- REPORT_LOCALE: Locale (always [login to view URL])
Fields:
- description: String
- descriptionGroup: String
- quantity: BigDecimal
- unit: String
- price: BigDecimal
- amount: BigDecimal
- currency: String
- packageQuantity: BigDecimal
- packageUnit: String
- mark: String
- markDescription: String
Groups: (see example B, and C)
Example Dataset: (each LevyResult is a row)
LevyResult{description='LOCK BODY 7016 (M model)', descriptionGroup='', quantity=995, unit='PCS', price=6.01, amount=5979.95, currency='US$', packageQuantity=199, packageUnit='CTNS', mark='No. 1-1240', markDescription='ONE LOT OF BICYCLE PARTS (Saddles, Stands, Bells, Pedals, Hub Spindles)'}
LevyResult{description='LOCK BODY 7016', descriptionGroup='', quantity=500, unit='PCS', price=9.00, amount=4500.00, currency='US$', packageQuantity=125, packageUnit='CTNS', mark='No. 1-1240', markDescription='ONE LOT OF BICYCLE PARTS (Saddles, Stands, Bells, Pedals, Hub Spindles)'}
LevyResult{description='4"', descriptionGroup='TWO WAY SCREWDRIVER', quantity=1500, unit='DZS', price=1.60, amount=2400.00, currency='US$', packageQuantity=250, packageUnit='CTNS', mark='No. 1-1240', markDescription='ONE LOT OF BICYCLE PARTS (Saddles, Stands, Bells, Pedals, Hub Spindles)'}
LevyResult{description='6"', descriptionGroup='TWO WAY SCREWDRIVER', quantity=1500, unit='DZS', price=1.60, amount=2400.00, currency='US$', packageQuantity=250, packageUnit='CTNS', mark='No. 1-1240', markDescription='ONE LOT OF BICYCLE PARTS (Saddles, Stands, Bells, Pedals, Hub Spindles)'}
LevyResult{description='5"', descriptionGroup='TWO WAY SCREWDRIVER', quantity=1500, unit='DZS', price=1.60, amount=2400.00, currency='US$', packageQuantity=250, packageUnit='PKGS', mark='No. 1-1240', markDescription='ONE LOT OF BICYCLE PARTS (Saddles, Stands, Bells, Pedals, Hub Spindles)'}
Format:
The excel files are the expected layout. A, B, C have been done. D, E, F, G, H are either missing or in very bad shape. You should refine or create them. Each set has 3 files: [login to view URL] for sheet INV, [login to view URL] for sheet PL, [login to view URL] for sheet SC.
Required font is Songti SC. Font file will be provided later via dropbox.
You are required to use the example dataset for testing.
DELIVERABLES
You should deliver the source jrxml files and its pdf result of example dataset. For parameters, you may use the excel file.
TIMEFRAME
One day