Advanced reporting - Summarizing tagged values

[Andreas1975]

Hi.

I'm a little bit new to this RTF reporting facilities.

I use EA to model the companys production environment with servers, networks, etc, etc.
I would need to produce some sort of statistical reports of that environment.
I.e. - Each Server has a Tagged Value called Monthly Cost - In my report I wanna summarize all Monthly Cost tagged values and print the total in my report. I also wanna make various other data calculations, such as total Monthly Cost for all Servers belonging to a specific Network.

Is such mathematical computations in reports possible at all in EA... Or do I have to look up Jasper Reports on top of the repoistory..... Or do you guys have any other ideas of such more mathematical statistical reports?

regards
Andreas

[Exart]

I would propose two suggestion:

First: Create sql query that will extract tagged values and then you could summarize values eg. in MS Access or in MS Excel.
I'm not sure if you are able simply put "sum" statement in sql because value of tagged value is String.

Second: Create RTF Template as a table. Report each server in a separate row. After creating a report you can select whole table in MS Word and then paste it to the MS Excel. I've done in this way several times when I have to report data about servers.
The table cannot have more then 16 columns.

[Ian Mitchell]

..or have a look at eaDocX. The Corporate version lets you put Excel inside EA, so you can generate regular reports, and let Excel do the adding-up and charting.

[Eve]

There's an automation interface to the document generator that includes the ability to insert any text you want. So you can run the templates for each element and then add your summary at the end.

[Andreas1975]

Thanks for the replies.

Still however, for us it seems like adding another reporting tool on top of the repository is the most tasteful solution.
Also,
This gives more flexibility in terms of style reportdistribution and automation, as well as I have some other ideas of using it for some basic BI pieces - I'll raise another thread on that.

regards
Andreas

[qwerty]

I once create a whole documentation suite based on the API for a customer. This worked very well and produced excellent results. However, the effort was high and could only be achieved on the basis of another framework built earlier.

q.