Tracking Task List with LiveReports

Manoharan_Venkidusamy_(sanmin011_-_(deleted))

I'm trying to track a group of tasks that are either active, completed, pending, on hold or cancelled. Each group has three sub-groups. The information I want to capture would be the number of each group, the number of each sub-group within the active group, how many days each task is open then average them together, how many days each completed task was open then average those numbers together. I know this is pretty involved any advice or suggestions on how I should go about capturing this information would be greatly appreciated.

Find more posts tagged with

Comments

***_****_(citlon01admin_-_(deleted))

The LiveReports will not handle the request you have. I would suggest Cognos impromptu or MS Crystal Reports for written such an advanced report.We mostly use Cognos and have place the reports in Livelink. When a user clicks on the report it automatically runs the report in Cognos. It is seamless to the user.David LoffhagenCity of London

Lee_Butler_(lbutler_(Delete)_2946657)

Message from Lee Butler <<A HREF="mailto:lbutler@opentext.com">lbutler@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

John,

There is a PSO module called WebReports which would allow you to achieve this. It would use a LiveReport to select all tasks or a broad subset of tasks keeping the SQL really simple. The WebReport would then feed the data into a JavaScript array where you can use complex selection, sort and display criteria.

Benefits of this solution would be:

You can access information stored in the DTREE EXTENDEDDATA field (e.g. Comments and Instructions) for the task

SQL queries greatly simplified

Client software not required

If you are interested in pursuing it further, I would be happy to provide you with a trial copy and/or assist you in developing the report below.

Regards,

Lee.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 02 July 2003 18:14
To: eLink Recipient
Subject: Tracking Task List with LiveReports

Tracking Task List with LiveReports Posted by SANMIN011 (DeRoche, John) on 07/02/2003 01:06 PM

I'm trying to track a group of tasks that are either active, completed, pending, on hold or cancelled. Each group has three sub-groups. The information I want to capture would be the number of each group, the number of each sub-group within the active group, how many days each task is open then average them together, how many days each completed task was open then average those numbers together. I know this is pretty involved any advice or suggestions on how I should go about capturing this information would be greatly appreciated.

Drane_Matthew

What is the syntax of getting to the ExtendedData field within a WebReport?Thanks.

Drane_Matthew

Are there any functions with Web Reports to format something as currency? i.e. $46.50 instead of just 46.5. Thanks.

Lee_Butler_(lbutler_(Delete)_2946657)

You would access a field within extended data with the following syntax:[LL_REPTAG=EXTENDEDDATA ASSOC: /]EXTENDEDDATA being the column name returned from the LiveReport.ASSOC being the data type we wish to access - it could also be LIST, RECORD or RECARRAYKEY being the key value field we want to access in the ASSOC (Extended data)Cheers,Lee.

Lee_Butler_(lbutler_(Delete)_2946657)

There is no currency formatting as of WebReports 2.0.0. It is possible to do a lot of formatting with JavaScript though.Extensive data formatting is included already and I'm sure enhancements for currencies would be considered - maybe you could email the exact requirements...Cheers,Lee.

Nathan Brizzi

Try using these two lines:

[LL_REPTAG_'$' SETVAR:VarValueDollar /]

[LL_REPTAG_!VarValue ROUND:2 SEPARATE:, CONCATVAR:VarValueDollar CURRENTVAL /]

In particular the Separate command saves a lot of code, inserting commas after every three digits.