Problems Creating Reports !!!!

[jeissonsierrac]

Hi good day

We are trying to make reports using BIRT but when making the configuration of Data Set we select the dpGetPeriod and configure the requested parameters.
we generated the XML correctly but at the time of the assignment of values and for perform the test that the information if it is being proper; we us throws the empty table values.
we would like to know how we can solve the problem or if we are making an incorrect configuration.

We enclose the structure of XML





&?startTime?&
&?endTime?&
&?bonus?&
&?dpName?&





we enclose the image of table empty






We appreciate a prompt answer

[Andorhal]

Hello.

XML is correct.
Using -dbg 10 as option for the reporting manager allows you to monitor the traffic and might provide - in case of an error - additional information.

How are you setting the values? Reporting parameter or default values ?
Best idea would be to include your .rptdesign file here so we can take a look at your configuration.

Best regards,
Robert

[jeroen.vanos]

Hello,

For a client I started a research if "Reporting Manager" is something for them.
But I get the following error in the "Demo Application 3:14" if I generate the following report “dpGetPeriod_1DPE_Line_2D.rptdesign” in WinCC OA Example Reports: BIRT-Reports.

Error:
SOAP-ENV:Client HTTP GET method not implemented

If I run it by the Eclipse editor I don’t get this error.

I am using Tomcat for runtime.

Best regards,

Jeroen van Os

[Andorhal]

Hello Jeroen,

sounds like the panel cant connect to the webserver.

The Demo Application Report setup is based on a fixed port for the preview server of the Eclipse Editor (it has a Jetty included).
Preferences -> Report Design -> Preview -> Preview Server (pick a free one e.g. 8085)

If you run a report in den Eclipse Editor, the Jetty server is activated and you can use it within the Demo Application, by storing its IP/Port Combo in the demo birt report panel.
If you didnt fix the port, you get a new one with every start while you might have stored another combo on the internal DP Type: _Reporting Name:_Birt


You can run your report in Tomcat as well, but there are things to consider:
The Birt runtime usually is in a subdirectory (e.g. 127.0.0.1:777/birt), the panel needs to be adapted for the path.

Furthermore the demo panel runs the demo templates from the demo project, you need to tell Tomcat to run "external" reports:

Code: Select all

		WORKING_FOLDER_ACCESS_ONLY
		false
	

This is done in the web.xml (e.g. \\webapps\\birt\\WEB-INF\\web.xml)

Guess it would be easier to copy the demo templates directly to Tomcat and run them there or just use the Jetty from the editor with a fixed port.
You get the parameter input page with our demo panels so you can have the same inputs on tomcat like in the demo panel.

Best regards
Robert

[jeroen.vanos]

Hello Robert,

I achieve to solve the above problem.
Thank you very much for your help.

Best regards,
Jeroen van Os

[jeroen.vanos]

Hello Robert

I want to make a report with the data set “alertGetPeriod” with an additional column that’s give the duration of an alert.
If I want to get the duration (calculate time between the partners) of an alert I need to have the partner attribute of that alert.

My question: is the “reporting manager” capable to return the “_partner” attribute?

The standard column mapping of the data set “alertGetPeriod” contains the next attributes:

value (the data point value),
date (the date when the value was set),
state (the attribute state contains the status bits _obsolete, _ackable etc. in a bit32.),
abbr (the Short sign (e.g.: A for an Alert) of the alert priority.),
prior (the Alert priority),
text (the State text),
direction (the Alert direction: CAME/WENT),
ack-state (the acknowledgement type of the alert),
ack-time (the acknowledgement time of the alert),
ack user (the user who acknowledged the alert),
comment (the user comment for an alert)

I've already customized the interface “Reporting.wsdl” file, but this will not work if the “reporting manager” the “_partner” attribute not give back!

Best regards,

Jeroen van Os

[Andorhal]

Hello Jeroen and sorry for the late reply.

At the moment this is not possible.
Editing the wsdl alone will not be sufficient since the reporting manager doesnt know it.

Since you cant be 100% sure you have the right CAME/WENT Combo in consecutive rows sophisticated aggregations (e.g. http://www.informit.com/articles/articl ... 6&seqNum=4) wont work.

Perhaps you can calculate the duration within OA, have 2 data sets and join them on the timestamp.

Sorry, nothing out of the box so far.

Best regards,
Robert