Writing a LiveReport and choosing a group?

Nina_Lewau_(sablinadmin_-_(deleted))

I would like to write some different LiveReports where the user first selects a group, for exampel:-List the email addresses for all members of this group-When has the members of this group logged into Livelink during last month?- and more reportsBut, I can not find a way to let the users select a group before they run the report. Is there any way we can solve this, or what are our options?

Bhupinder_Singh

Message from Bhupinder Singh via eLinkI tried this and found that the "User" input in a LiveReport does not allow selection of a group. To get around this limitation, youcan create 2 LiveReports: a main LiveReport to list all groups and their ID's, and a sub-report that will display all the e-mailaddresses of users in a group selected from the main LiveReport. The sub-report will be activated from the main report by clickingon a "details" link next to the group for which e-mail addresses are desired. Below is a sample main report and subreport that youcan use. I've attached a screen shot showing the results of running the two reports.Attachment: report_results.jpgSub-report:Title - E-mail addresses of users in a groupInput: NumberPrompt: Enter the numeric ID of the groupSQL: select a.Name, a.FirstName, a.LastName, a.mailaddress from kuaf a, kuafchildren b where a.ID=b.childID and b.ID=%1Param %1: User Input 1Report Format: AutoLiveReportMain report:Title: Groups Listing with Group IDsSQL: select name, id from kuaf where type=1Report Format: AutoLiveReportClick-thru subreport: (browse Livelink here to select the sub-report "E-mail addresses of users in a group" described above)Sub-report param 1: IDHope that helps...- Bhupinder------------------------------------------------------------------------- Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------------------------- -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, February 03, 2004 8:07 AMTo: eLink RecipientSubject: Writing a LiveReport and choosing a group?Writing a LiveReport and choosing a group?Posted by Englund, Nina on 02/03/2004 08:03 AMI would like to write some different LiveReports where the user first selects a group, for exampel: -List the email addresses forall members of this group -When has the members of this group logged into Livelink during last month?- and more reportsBut, I can not find a way to let the users select a group before they run the report. Is there any way we can solve this, or whatare our options?[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe