Hello, Emma,

Good question! I've came to it many times while was working on different templates. Sometimes template looks good for one invoice, but worse for another.

So, my main and quickest solution is to switch to the Field list, select Invoice (could be another name, just select top node in the tree) and in properties find Sorting property. Open it and sort by Date in descending order. From now, preview window will display invoices starting from the latest one.

Also, we can control how many invoices are shown by default in the Preview window. Click on empty space to select the whole report, and then find Report print options:

Finally, if you still need to display concrete invoice, you can use Criteria property for data set:

Here you can specify criteria to get an invoice which you need. For example by number. However, in this case don't forget to clear Criteria before saving a template, otherwise you won't see invoice when printing from UI.

Hope that helps! And sorry that there is no super easy solution

Hello, Emma,

Good question! I've came to it many times while was working on different templates. Sometimes template looks good for one invoice, but worse for another.

So, my main and quickest solution is to switch to the Field list, select Invoice (could be another name, just select top node in the tree) and in properties find Sorting property. Open it and sort by Date in descending order. From now, preview window will display invoices starting from the latest one.

Also, we can control how many invoices are shown by default in the Preview window. Click on empty space to select the whole report, and then find Report print options:

Finally, if you still need to display concrete invoice, you can use Criteria property for data set:

Here you can specify criteria to get an invoice which you need. For example by number. However, in this case don't forget to clear Criteria before saving a template, otherwise you won't see invoice when printing from UI.

Hope that helps! And sorry that there is no super easy solution

Thanks for your fast response, Eugene.

I don't see the same as you in your first screenshot (two cogs, measure units at top), but based on your second screenshot, I've managed to filter by IsThisYear in the Criteria field, so I see all invoices issued this year. 

That works for me, but I'd still be interested to know how to reach "Report Print Options" in your first screenshot.

Emma Goldsmith said:

I don't see the same as you in your first screenshot (two cogs, measure units at top), but based on your second screenshot, I've managed to filter by IsThisYear in the Criteria field, so I see all invoices issued this year. 

Hello, Emma,

I suppose you didn't select report in a whole. To do that, click on grey area on the designer surface (outside of paper). This select report. Or, the same could be achieved if to select report in the drop-down list right above that two cogs In this list, find element which has Report type. On the screenshot above, it's Invoice_v8. And then you'll find this property. 

And third way. Click on small arrow in the corner between two rulers. This property (Detail count at design time) will be there as well.

Hope this helps!

Aha! That solves it. Thanks for the explanation, Eugene!