Custom Report Scripting Help Needed

There are couple of approaches for the occurrence counts

1) If you're comfortable with coding in JavaScript you could edit the code generated by the Report Writer.  The code is fairly easy to interpret.  Find the part of the code that is writing the nformation to the cells.  Once you locate that section, add method call to determine the occurrence count.  The method call is <ObjDef>.OccList().length.  This will return the number of occurrence objects for the Definition Object <ObjDef>.

One thing to note...if you manually edit the code created by the Report Writer, it will not be able to be modified by the Report Writer.  You are then committed to maintaining the JavaScript code itself.

We've used this approach and it works but again you need to be comfortable with JavaScript coding.

2) If you do not want to work with JavaScript, use the Report Writer to produce an Excel workbook that lists the occurences of an object.  Then use Excel's Pivot Table function to create the counts.  It looks like you already have the majority of the Report Write definition for the report.  Don't worry about the counts, just list the occurrences. 

There are two drawbacks to this approach.  One is the extra step of creating the pivot table.  The other one is if the number of rows created by the report exceeds 64K, then it will break Excel.  AFAIK, the current release of ARIS 7.x does not support Excel 2007 worksheets that can contain up to 1million rows.

Jim

Thanks, Jim, for your response. I'm not comfortable with JavaScript so I'm looking for an alternate. Your item 2 sounds intriguing, but with the drawbacks you mention, I don't believe it's an ideal solution.

We may need to hire someone to finish this report for us unless someone has the JavaScript code that they can share with me. I can drop it into the code, just not knowledgeable in JavaScript coding.

Hi Jackie,

Did you get this working yet?

I've put together a script for you, it's a javascript only report, let me know, then I can e-mail it to you.

Regards,

Freddy

Hi Freddy/Everyone,

I'm new to ARIS but have been struggling for days with creating a simple report to list Functions, Function descriptions, start event and end event in my BPMN/EPC Models using WYSIWYG. Many thanks for any assistance given.

Cheers

John W

Freddy, I finally had time to work with the script that you sent me. It works perfectly.

Thanks so  much for your efforts.

I've read the post and it would be perfect if I can re-use the script you built. Is it possible?

Thanks a lot

Kind regards

Hi Jaime, 

Sure, I still have the script. Send me your e-mail and I'll send it to you.

Regards,

Freddy

Hi,

Could you please send me the script ?

My email : coucou81@laposte.net

Thank you,

Best regards,

Hi Cyrille

I've just sent it to you.

Kind regards

Jaime

HI Freddy,

Can you please send it to me aswel sanyane1@gmail.com

many thanks

Hi Neo

I've just sent it to you.

Kind regards

Jaime

Hi Vera,

I've just sent it to you.

Kind regards