PowerPoint Add-in:Create Report - Revision history

Admin at 13:36, 5 April 2017

2017-04-05T13:36:05Z

← Older revision		Revision as of 14:36, 5 April 2017
Line 57:		Line 57:
	Text fields can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. This will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just works if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original report and afterwards save a new offline version.		Text fields can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. This will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just works if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original report and afterwards save a new offline version.

			Additional function with 9.5 HF 1.3: You can choose the attribute which should be shown instead of the name via task pane. If you have [Filtername.Name] in text, you can replace Name with the attribute you want to be shown. E.g. [Filtername.ID]

	==Select options==		==Select options==

Admin at 12:37, 27 February 2017

2017-02-27T12:37:14Z

← Older revision		Revision as of 13:37, 27 February 2017
Line 55:		Line 55:
	Using text fields filters can be used in the text.		Using text fields filters can be used in the text.

	Text fields can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. This will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just works if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original and afterwards save a new offline version.		Text fields can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. This will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just works if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original report and afterwards save a new offline version.

Admin at 12:36, 27 February 2017

2017-02-27T12:36:29Z

← Older revision		Revision as of 13:36, 27 February 2017
Line 55:		Line 55:
	Using text fields filters can be used in the text.		Using text fields filters can be used in the text.

	Text fields can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. This will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just ~~work~~ if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original and afterwards save a new offline version.		Text fields can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. This will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just works if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original and afterwards save a new offline version.

Admin at 12:35, 27 February 2017

2017-02-27T12:35:58Z

← Older revision		Revision as of 13:35, 27 February 2017
Line 55:		Line 55:
	Using text fields filters can be used in the text.		Using text fields filters can be used in the text.

	Text fields can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. ~~These~~ will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just work if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original and afterwards save a new offline version.		Text fields can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. This will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just work if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original and afterwards save a new offline version.

Admin at 12:35, 27 February 2017

2017-02-27T12:35:16Z

← Older revision		Revision as of 13:35, 27 February 2017
Line 55:		Line 55:
	Using text fields filters can be used in the text.		Using text fields filters can be used in the text.

	Text ~~field~~ can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. These will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just work if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original and afterwards save a new offline version.		Text fields can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. These will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just work if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original and afterwards save a new offline version.

Admin at 12:34, 27 February 2017

2017-02-27T12:34:05Z

← Older revision		Revision as of 13:34, 27 February 2017
Line 55:		Line 55:
	Using text fields filters can be used in the text.		Using text fields filters can be used in the text.

	Text ~~fields~~ can be inserted via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. ~~Select~~ the appropriate filter in the ~~sub menu~~ of ~~item~~ text ~~field~~.		Text field can be inserted by using the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Choose your desired filter from the sub menu of text field. If you do not have a place holder a text field will be inserted where you already can see the name of the selected filter element. If you update a filter the text field or the entire document has to be refreshed to see the new value. If you would like to use the name of the selected element in a text you have to place the cursor inside the desired field and then insert a text field via the [[PowerPoint_Add-in:Ribbon\|ribbon]]. These will be inserted for you: [Filtername.Name]. If you start your presentation you will see the replaced value of the appropriate filter element. Keep in mind that this just work if you have a connection to the CoPlanner-Server. If you would like to show your presentation without connection to the CoPlanner Server it is necessary to create an offline version. You can do this by using the button "Export" in the [[PowerPoint_Add-in:Ribbon\|ribbon]]. Afterwards, a version will be created which does not have any references to the CoPlanner. Instead of [Filter.Name] the text of the real elements will be inserted. Reports can not be adjusted and are available only as pictures. If you would like to do changes you can do this by using the original and afterwards save a new offline version.


	==Select options==		==Select options==

Admin at 12:24, 27 February 2017

2017-02-27T12:24:32Z

← Older revision		Revision as of 13:24, 27 February 2017
Line 58:		Line 58:

	==Select options==		==Select options==
	You can define global options for your document.		You can define global options for your document. You can define them in the [[PowerPoint_Add-in:Ribbon\|ribbon]] under [[PowerPoint_Add-in:Options\|options]].

	You can define them in the [[PowerPoint_Add-in:Ribbon\|ribbon]] under [[PowerPoint_Add-in:Options\|options]].

	You can define if the Logon should be displayed automatically when you open the document, reports should be updated automatically on each filter update and if reports should be re-scaled or not.		You can define if the Logon should be displayed automatically when you open the document, reports should be updated automatically on each filter update and if reports should be re-scaled or not.

Admin at 12:22, 27 February 2017

2017-02-27T12:22:58Z

← Older revision		Revision as of 13:22, 27 February 2017
Line 23:		Line 23:
	If the option automatic updating is not selected in your document you have to refresh your report manually to see the filtered data. You can refresh the whole document by using the refresh button in the ribbon or just one report via refreh in the task pane.		If the option automatic updating is not selected in your document you have to refresh your report manually to see the filtered data. You can refresh the whole document by using the refresh button in the ribbon or just one report via refreh in the task pane.

	[[Image:~~WA_Verknuepfter_Bericht~~.png\|thumb\|center\|PowerPoint Add-in,Existing report with explanation]]		[[Image:WA_Verknuepfter_Bericht1.png\|thumb\|center\|PowerPoint Add-in,Existing report with explanation]]

	It is also possible to define for each report if he can change his original size. If the option "automatic size" in the task pane is not checked the report will always keep the same size.		It is also possible to define for each report if he can change his original size. If the option "automatic size" in the task pane is not checked the report will always keep the same size.
Line 40:		Line 40:
	If the option automatic updating is not selected in your document you have to refresh your report manually to see the filtered data. You can refresh the whole document by using the refresh button in the ribbon or just one report via refreh in the task pane.		If the option automatic updating is not selected in your document you have to refresh your report manually to see the filtered data. You can refresh the whole document by using the refresh button in the ribbon or just one report via refreh in the task pane.

	[[Image:~~WA_Verknuepfter_Bericht~~.png\|thumb\|center\|PowerPoint Add-in,Existing report with explanation]]		[[Image:WA_Verknuepfter_Bericht1.png\|thumb\|center\|PowerPoint Add-in,Existing report with explanation]]

	It is also possible to define for each report if he can change his original size. If the option "automatic size" in the task pane is not checked the report will always keep the same size.		It is also possible to define for each report if he can change his original size. If the option "automatic size" in the task pane is not checked the report will always keep the same size.

Admin at 12:22, 27 February 2017

2017-02-27T12:22:21Z

← Older revision		Revision as of 13:22, 27 February 2017
Line 10:		Line 10:
	:* Set options: You can define if the Logon should be displayed automatically when you open the document, reports should be updated automatically on each filter update and if reports should be re-scaled or not.		:* Set options: You can define if the Logon should be displayed automatically when you open the document, reports should be updated automatically on each filter update and if reports should be re-scaled or not.

	[[Image:~~WC_Uebersicht~~.PNG\|thumb\|center\|PowerPoint Add-in,Overview Terms]]		[[Image:WC_Uebersicht1.PNG\|thumb\|center\|PowerPoint Add-in,Overview Terms]]

Admin: Created page with "TOC ==Overview== Using the PowerPoint Add-in you can :* Import existing reports: Import reports which already exist in the CoPlanner. Updates on reports will be transfer..."

2017-02-23T10:18:25Z

Created page with "__TOC__ ==Overview== Using the PowerPoint Add-in you can :* Import existing reports: Import reports which already exist in the CoPlanner. Updates on reports will be transfer..."

New page

__TOC__
==Overview==

Using the PowerPoint Add-in you can

:* Import existing reports: Import reports which already exist in the CoPlanner. Updates on reports will be transferred to PowerPoint.
:* Import independent reports: You can create reports in PowerPoint. These reports are not available in the CoPlanner.
:* Define filters: You can define global filters which can be used for reports.
:* Insert text fields: You can insert text fields which refer to the global filters. These fields can be used in texts and will be updated automatically.
:* Set options: You can define if the Logon should be displayed automatically when you open the document, reports should be updated automatically on each filter update and if reports should be re-scaled or not.

[[Image:WC_Uebersicht.PNG|thumb|center|PowerPoint Add-in,Overview Terms]]

==Import existing reports==

You can connect reports which were created in the windows client to your PowerPoint document. That means changes which are made in the report using the windows client will be activated in the PowerPoint document automatically after refreshing.
You can insert an existing report using the task pane on the right side. Choose your report in the list and press "Paste". If you are in the normal user mode you only can see reports from "My Reports" and "Public Reports". To select reports from "Reports" you have to change to the power user mode using the button "mode" in the [[PowerPoint_Add-in:Ribbon|ribbon]].

If you click on the report you can select filters on the right side which should be active for this report. You can define global filters (via [[PowerPoint_Add-in:Filter_Administration|filter administration]])
or local filters. To use a global filter change the drop down menu to the symbol [[Image:WA_globaler_Filter.png]]. Afterwards you can select your desired filter in the drop down menu. If you choose another element in the filter bar and refresh your document, data will be updated to the selected element. You also can set local filters in your report. Just select the element in the drop down menu on which your report always should be filtered.
If the option automatic updating is not selected in your document you have to refresh your report manually to see the filtered data. You can refresh the whole document by using the refresh button in the ribbon or just one report via refreh in the task pane.

[[Image:WA_Verknuepfter_Bericht.png|thumb|center|PowerPoint Add-in,Existing report with explanation]]

It is also possible to define for each report if he can change his original size. If the option "automatic size" in the task pane is not checked the report will always keep the same size.
The filtered report will always be scaled to this size. If the option is checked the report will be increased/decreased automatically.

==Insert independent reports==

If you need reports only one-time you can create them easily and fast in your document. These reports are not available for other CoPlanner clients.
The report designer will be opened if you click on Paste in the independent area of the task pane. Reports can be created here in the same manner as in the CoPlanner windows client. Please find an explanation how you can create a report [[Enterprise_Edition:CoPlannerReporting|here]]. Using "OK" will insert the report in your document. Independent reports also can be edited. Select your report and find a new button to edit your report in the task pane.

If you click on a report you have the possibility to select filters in the task pane which should be active for this report. You can define global filters (via [[PowerPoint_Add-in:Filter_Administration|filter administration]]) or local filters.

If you click on the report you can select filters on the right side which should be active for this report. You can define global filters (via [[PowerPoint_Add-in:Filter_Administration|filter administration]])
or local filters. To use a global filter change the drop down menu to the symbol [[Image:WA_globaler_Filter.png]]. Afterwards you can select your desired filter in the drop down menu. If you choose another element in the filter bar and refresh your document, data will be updated to the selected element. You also can set local filters in your report. Just select the element in the drop down menu on which your report always should be filtered.
If the option automatic updating is not selected in your document you have to refresh your report manually to see the filtered data. You can refresh the whole document by using the refresh button in the ribbon or just one report via refreh in the task pane.

[[Image:WA_Verknuepfter_Bericht.png|thumb|center|PowerPoint Add-in,Existing report with explanation]]

It is also possible to define for each report if he can change his original size. If the option "automatic size" in the task pane is not checked the report will always keep the same size.
The filtered report will always be scaled to this size. If the option is checked the report will be increased/decreased automatically.

==Filter area==
Filters of the report will be shown in a filter bar underneath the ribbon and above the working area.

Filter selection and filter operators are the same as the [[Filter_Area|filter area in the Windows-Client]].

Administration of the filters is made via [[PowerPoint_Add-in:Filter_Administration|filter administration ]] in the [[PowerPoint_Add-in:Ribbon|ribbon]].

==Insert text field==
Using text fields filters can be used in the text.

Text fields can be inserted via the [[PowerPoint_Add-in:Ribbon|ribbon]]. Select the appropriate filter in the sub menu of item text field.

==Select options==
You can define global options for your document.

You can define them in the [[PowerPoint_Add-in:Ribbon|ribbon]] under [[PowerPoint_Add-in:Options|options]].

You can define if the Logon should be displayed automatically when you open the document, reports should be updated automatically on each filter update and if reports should be re-scaled or not.

__NOEDITSECTION__
[[Category:PowerPoint_Add-in|Create_Report]]
[[en:PowerPoint_Add-in:Create_a_report]]

PowerPoint Add-in:Create Report - Revision history

Admin at 13:36, 5 April 2017

Admin at 12:37, 27 February 2017

Admin at 12:36, 27 February 2017

Admin at 12:35, 27 February 2017

Admin at 12:35, 27 February 2017

Admin at 12:34, 27 February 2017

Admin at 12:24, 27 February 2017

Admin at 12:22, 27 February 2017

Admin at 12:22, 27 February 2017

Admin: Created page with "__TOC__ ==Overview== Using the PowerPoint Add-in you can :* Import existing reports: Import reports which already exist in the CoPlanner. Updates on reports will be transfer..."

Admin: Created page with "TOC ==Overview== Using the PowerPoint Add-in you can :* Import existing reports: Import reports which already exist in the CoPlanner. Updates on reports will be transfer..."