Word Add-in:Create Report

Overview

Using the Word Add-in you can

• Import existing reports: Import reports which already exist in the CoPlanner. Updates on reports will be transferred to Word.
• Import independent reports: You can create reports in Word. 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.

Error creating thumbnail: File missing

Word Add-in,Overview Terms

Import existing reports

You can connect reports which were created in the windows client to your Word document. That means changes which are made in the report using the windows client will be activated in the word 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 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 filter administration) or local filters. To use a global filter change the drop down menu to the symbol . 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.

Error creating thumbnail: File missing

Word 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 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 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 filter administration) or local filters. To use a global filter change the drop down menu to the symbol . 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.

Error creating thumbnail: File missing

Word 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 in the Windows-Client.

Administration of the filters is made via filter administration in the ribbon.

Insert text field

Using text fields filters can be used in the text.

Text fields can be inserted via the ribbon. Select the appropriate filter in the sub menu of item text field.

From version 9.5 HF 1.3 there is the possibility to change the shown attribute via task pane.

Select options

You can define global options for your document.

You can define them in the ribbon under 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. Word_Add-in|Bericht_erstellen