WebApps:ReportViewer

Using the report viewer app CoPlanner reports can be displayed in the web.

System requirements

The requirements can be found here.

Invocation of CoPlanner report in Web

<WebAppUrl of server (replace "+" with Servername/IP adress)>/reportviewer/?reportid=<Reportid of report in table tb_biobdetails>

oder

<WebAppUrl of server (replace "+" with Servername/IP adress)>/reportviewer/?reportname=<Reportname>

Example with ID:

https://servername:4444/coplanner/reportviewer/?reportid=636038342383274491

Example of invocation with Tiles:

@Session_WebAppUrl@/reportviewer/?reportid=636038342383274491

Allowed syntax for report ID:

• ReportId
• ReportID
• reportId
• reportid

Allowed syntax for report name:

• ReportName
• reportname
• ReportNAME
• REPORTname

Extended invocation

From 9.5 HF 2.4:

• hideSessionHeader: Defines if the session header should be visible or not (true fades out the Session-Header). Default while opening is false

Example:

https://servername:4444/coplanner/reportviewer/?reportid=636038342383274491&hideSessionHeader=true

From 9.5 HF 4.1:

• contextFilters: Defines filter values which are used while opening the report

Example:

Transfer to filter time, filter operator =, element 2 and entity, filteroperator me+under, element 1

&contextFilters=timeeq 2 and entity mu 1

When using " and " in filter name with transferred value or space this has to be done:

&contextFilters="My text filter" eq "Text with space"

Example for use in a calculated measure in a cube. The report BER_Rueckstellungen will be opened and filters SonstigeErloesundKostenarten, time and PC/KST transferred.

Link for the windows client:

IIF([ErloesKosten LC]<>0,'cop://name=Rückstellungen & aktion=Berichtswesen & p1=Bericht auswählen & p2=BER_Rueckstellungen_PLAN & p3= & p4=ContextFiltersetting:SonstigeErloesundKostenarten=[Attribut_SonstigeErloesundKostenarten]=2=FilterDim=SonstigeErloesundKostenarten|Zeit=[Attribut_Zeit]=2=FilterDim=Zeit|PC/KST=[Attribut_PCKST]=2=FilterDim=PCKST & frmlocation=Work',)

correspons to the Webclient:

IIF([ErloesKosten LC]<>0,'@Session_WebAppUrl@/reportviewer/?reportname=BER_Rueckstellungen_PLAN&contextFilters="SonstigeErloesundKostenarten" mu [Attribut_SonstigeErloesundKostenarten] and "Zeit" mu [Attribut_Zeit] and "PC/KST" mu [Attribut_PCKST]',)

Operators:

Filter operator	Invocation in context	Description
	mu	Selected element and all levels below will be displayed.
	mf	Selected element and one level below will be displayed.
	fu	All levels below the selected element will be displayed.
	un	One level below the selected element will be displayed.
=	eq	Only values from this dimension element will be displayed.
<>	ne	All values will be displayed but values from the selected filter element.

Requirements

WebAppUrl has to be defined for the CoPlanner Service or CoPlanner Server. Additionally the Reportserver has to be started via console or service.

Report Designer

Starting from 9.5 HF 3.6 a report designer is integrated in the report viewer to edit and save reports directly via the web client. Further information to the report designer can be found here.

Menu

	Back to last page.
	Open/Close of display text of menu.
	Update of data in the report.
	Activate/Deactivate null value suppression.
	Fade in/Fade out filter area.
	Fade in/Fade out parameter area.
	Export report to Excel.
	Export report to PDF
	Export report to HTML
	Export report to Picture
	Back to superior report
	Edit report (only as PowerUser)

Menu with display text: