Hi Marieke,

Thank you for detailed question and screenshots. May I ask you to export your template and attach here? I'll check directly in the template, it will be much easier than suggesting based on the image.

Thank you,

Hi Eugene, 

I would like to attach the template but .repx files are "not allowed" as it seems, so I am sending it you by e-mail. Also, apologies for the late reply! Work keeps getting in between, and I fixed the problems manually at every time, but the problem does persist, so your help would be really appreciated! 

Kind regards, 

Marieke

Hi Marieke,

Thank you for the template. I see your questions now. But your template doesn't look as on the image above. 

1. Why PO date and language pairs disappear. Because it is configured to hide repetitive values. Select this cell in the designer, and find Behavior - Process duplicates property. Change it according to your preferences.

2. Quantities. If you want to have some totals at top and then detailed fuzzy data at bottom, it will require some work. Create a new grouping band and group by Job.Id field. Then in this group header band you can use summary by this group (like total quantity for a job, or total amount), and each detail row will contain individual rows from this group (where you could use quantity, fuzzy type, price etc). I'm attaching example template. But I don't recommend such approach, because if your job contains some words and some hours, summarizing it won't be a good idea. However, there is still a solution, but your grouping will require not only job.id, but also service type.id.

Invoice.zip

Hi Marieke,

Thank you for the template. I see your questions now. But your template doesn't look as on the image above. 

1. Why PO date and language pairs disappear. Because it is configured to hide repetitive values. Select this cell in the designer, and find Behavior - Process duplicates property. Change it according to your preferences.

2. Quantities. If you want to have some totals at top and then detailed fuzzy data at bottom, it will require some work. Create a new grouping band and group by Job.Id field. Then in this group header band you can use summary by this group (like total quantity for a job, or total amount), and each detail row will contain individual rows from this group (where you could use quantity, fuzzy type, price etc). I'm attaching example template. But I don't recommend such approach, because if your job contains some words and some hours, summarizing it won't be a good idea. However, there is still a solution, but your grouping will require not only job.id, but also service type.id.

Invoice.zip