Using the invoice designer
-
- Posts: 86
- Joined: 03 Aug 2012 09:36
Using the invoice designer
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,
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,
Re: Using the invoice designer
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.
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.
Bernd - radio42
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
-
- Posts: 86
- Joined: 03 Aug 2012 09:36
Re: Using the invoice designer
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?
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?
Re: Using the invoice designer
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
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
Bernd - radio42
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
-
- Posts: 86
- Joined: 03 Aug 2012 09:36
Re: Using the invoice designer
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.
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.
Re: Using the invoice designer
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.
Select the Campaign's 'Group By Field' option: Changes to:
Standard InvoiceSelect the Campaign's 'Group By Field' option: Changes to:
Bernd - radio42
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution
ProppFrexx ONAIR - The Playout and Broadcast Automation Solution