Using the invoice designer

You have a question or need an advice about how to do something? Ask it here!
Post Reply
meisterpropper
Posts: 86
Joined: 03 Aug 2012 09:36
Using the invoice designer

Post by meisterpropper »

Hi,

I´m struggling a little bit with the invoice designer at the advert => billing section.

I´ve seen on the right side, that I can use different items at the data explorer, but how can I use for example grand total? There is a field Data Source, where I want to choose the count of all playouts for example. Field type would be Int I think, but it is not really guessable how data source should be used. Can you please explain a little bit how the invoice designer works in general with the data explorer fields?

Also it seems that I cannot choose the rows at the billing section for example to exclude the total price and price/sec rows when I want to print the report. Is this intended?

Regards,
User avatar
radio42
Site Admin
Posts: 8295
Joined: 05 Apr 2012 16:26
Location: Hamburg, Germany
Contact:
Re: Using the invoice designer

Post by radio42 »

The invoice designer is a DevExpress Control (the UI lib I am using). It is a Microsoft Word® inspired WinForms reporting platform, designed to simplify the way in which end users generate business reports.
Here are the official documentation links to this control (which is officially called Snap™):

https://www.devexpress.com/products/net ... orms/snap/

https://documentation.devexpress.com/Wi ... aries/Snap

https://m.youtube.com/watch?v=Z-vkVPBXsx8

https://devexpress.github.io/dotnet-eud ... ngine.html

Note, that you can skip the DataSource chapters, as in the Advert Invoice Designer all available fields already provided (these are displayed on the right side). However, you might add new calculated fields, if needed.

In a detail Report you can of course not suppress certain rows, but from what you say it more sounds like you wanted to remove certain fields (columns), which is of course possible.
meisterpropper
Posts: 86
Joined: 03 Aug 2012 09:36
Re: Using the invoice designer

Post by meisterpropper »

Thanks for your explanation. When I insert fields like GrandTotal they should work out of the box? If yes, GrandTotal displays 0.
Is there any field, which can sum up all plays in one integer?

OK, I´ve tried the column chooser, but it isn´t working at the billing section. Is there any other tool, which I need to use for removing certain fields?
User avatar
radio42
Site Admin
Posts: 8295
Joined: 05 Apr 2012 16:26
Location: Hamburg, Germany
Contact:
Re: Using the invoice designer

Post by radio42 »

I can not follow. What field from where do you insert and also to which section? I assume the answer is simply no.
To remove a field you can simply select it and klick delete.
Not sure what you mean by ‘all plays’?
Do you mean a row count of all detail lines?

Please also take a look to the provided documentation. Maybe this is what you are looking for: the grouping feature to add a group footer to eg display to total count:
https://documentation.devexpress.com/Wi ... ument-Data
meisterpropper
Posts: 86
Joined: 03 Aug 2012 09:36
Re: Using the invoice designer

Post by meisterpropper »

Yes, I mean a row count of all detail lines.
With all plays I mean all playouts from the generated billing period and partner selection. When I´ve generated a report I see the fields campaign totasl and items, where I can see the totals of all playouts and the sum of all played seconds (duration) etc.

I assume that these data fields are also available at the invoice designer (I think they are called: subtotal, grandtotal), but when I insert a field at the invoice designer from the data explorer via drag / drop to an empty line, it displays 0.
User avatar
radio42
Site Admin
Posts: 8295
Joined: 05 Apr 2012 16:26
Location: Hamburg, Germany
Contact:
Re: Using the invoice designer

Post by radio42 »

To for example group the invoice by 'Campaign' (using the Sample Invoice template), simply make a right-click on the 'Campaign' column and select the 'Group by Field' from the menu item - this will automatically display a group summary including the count of items in each group - i.e. the count of played items per campaign.
AdvertInvoiceStandard.jpg
Standard Invoice
Select the Campaign's 'Group By Field' option:
AdvertInvoiceGroupByField.jpg
Changes to:
AdvertInvoiceWithGroupByField.jpg

Post Reply