Group ID as parameter

I want to display data for users who belong to a particular group. Has anyone figured out a way of requesting a user to choose a group id/name other than displaying a textbox for them to type something in? There's a parameter type of user - surely group isn't that difficult to implement as well?

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Selecting a group is not yet possible. This is something I entered as a product bug, and the bug status is still "Open" and scheduled for a future release:

Bug Description (#1911633) - User input on a LiveReport does not allow selection of a group

To get around this limitation, you can create 2 LiveReports: a main LiveReport to list all groups and their ID's, and a sub-report that will display the information particular to the group selected from the main report results page.

Here is an example that gets all the e-mail addresses of users in a group selected from the main LiveReport. The sub-report will be activated from the main report by clicking on a "details" link next to the group for which e-mail addresses are desired. Below is a sample main report and subreport that you can use.

Sub-report:

Title - E-mail addresses of users in a group

Input: Number

Prompt: Enter the numeric ID of the group

SQL: select a.Name, a.FirstName, a.LastName, a.mailaddress from kuaf a, kuafchildren b where a.ID=b.childID and b.ID=%1

Param %1: User Input 1 Report Format: AutoLiveReport

Main report:

Title: Groups Listing with Group IDs

SQL: select name, id from kuaf where type=1

Report Format: AutoLiveReport

Click-thru subreport: (browse Livelink here to select the sub-report "E-mail addresses of users in a group" described above)

Sub-report param 1: ID

- 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
------------------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 23, 2006 4:16 AM
To: eLink Recipient
Subject: Group ID as parameter

Group ID as parameter

Posted by habis (Bilton, Alison) on 08/23/2006 04:12 AM

Alison_Bilton_(habis_-_(deleted))

I did go down this route and got it working fine, but my problem is that I want start and end date parameters as well. I've tried adding them as parameters on the main report and pushing them through along with the group id, and also adding them to the subreport, but I can't get it to work either way. Unless I'm doing something silly...

volvostephen

Message from Fisher, Stephen via eLinkSo you start with date parameters only on the live report, then you put thedates the user selected, into the select statement of the sub report, thenyou pass the dates and group clicked on into the third report? Would thiswork? I just tried it and it was fine.The SQL for report 1 would be something like.....select %1 [StartDate], %2 [endDate], ID, name from kuaf where type=1 anddeleted=0 order by nameThen for Sub Report Param1 it is StartDate, 2 is EndDate and 3 is ID. Should work.... I think the trick is adding the parameters from the userinput into the select statement.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: August 23, 2006 10:24 AMTo: eLink RecipientSubject: I did go down this route and got it working fine, but my problem isthat I want...I did go down this route and got it working fine, but my problem is that Iwant...Posted by Bilton, Alison on 08/23/2006 10:22 AMI did go down this route and got it working fine, but my problem is that Iwant start and end date parameters as well. I've tried adding them as parameters on the main report and pushing themthrough along with the group id, and also adding them to the subreport, butI can't get it to work either way. Unless I'm doing something silly...[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Group ID as parameterhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/7646012Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.*****************************NOTICE - This email (including all attachments) is the sole property of the HATCH group of companies. It may contain personal and confidential information, and is intended solely for the addressee. If you are not the intended recipient, any use, disclosure, copying or any other action is unauthorized and may be unlawful. This email is also subject to copyright. No part of it should be reproduced, adapted or communicated without the written consent of the relevant HATCH company.If you have received this email in error, please notify us immediately by return e-mail or via mailto:MailAdmin@Hatch.ca and delete all copies from your system.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Edit the Main LiveReport, and save the page as an HTML page using the browser's File, Save As menu.

Edit the SubReport, and save it as HTML in the same manner.

Post both HTML files here and I'll see if I can figure out what's going wrong.

What version of Liveilnk, and what monthly patch is installed on that version?

- Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 23, 2006 10:24 AM
To: eLink Recipient
Subject: I did go down this route and got it working fine, but my problem is that I want...

I did go down this route and got it working fine, but my problem is that I want...		Posted by habis (Bilton, Alison) on 08/23/2006 10:22 AM
In reply to: RE Group ID as parameter		Posted by bsingh (Singh, Bhupinder) on 08/23/2006 08:58 AM

I did go down this route and got it working fine, but my problem is that I want start and end date parameters as well.

I've tried adding them as parameters on the main report and pushing them through along with the group id, and also adding them to the subreport, but I can't get it to work either way. Unless I'm doing something silly...

Alison_Bilton_(habis_-_(deleted))

Many thanks - we're running 9.6 with the June patch installed.

Alison_Bilton_(habis_-_(deleted))

...and the subreport.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Are you using an Oracle Database with Livelink? The reason I ask is I myself can't get this to work yet, and I suspect that it may be because of an issue with input parameters and date formats that I've come across quite some time ago. If you are using Oracle, I would recommend opening a support ticket for help with getting this to work, as it will likely require more time than I can dedicate to this at the moment.

- Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 23, 2006 11:12 AM
To: eLink Recipient
Subject: ...and the subreport.

...and the subreport.		Posted by habis (Bilton, Alison) on 08/23/2006 11:09 AM
In reply to: RE I did go down this route and got it working fine, but my problem is that I want...		Posted by bsingh (Singh, Bhupinder) on 08/23/2006 10:49 AM

...and the subreport.

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

By the way, a colleague of mine from the WebReports development team indicates:

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />"...WebReports 4.0 lets you do this. When defining a parameter you can decide whether a user is allowed to browse for users, groups or both." WebReports is an optional module for Livelink, information for which can be found here: https://knowledge.opentext.com/knowledge/llisapi.dll/open/3413900 - Bhupinder

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 23, 2006 8:59 AM
To: eLink Recipient
Subject: RE Group ID as parameter

RE Group ID as parameter		Posted by bsingh (Singh, Bhupinder) on 08/23/2006 08:58 AM
In reply to: Group ID as parameter		Posted by habis (Bilton, Alison) on 08/23/2006 04:12 AM

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

Selecting a group is not yet possible. This is something I entered as a product bug, and the bug status is still "Open" and scheduled for a future release: Bug Description (#1911633) - User input on a LiveReport does not allow selection of a group To get around this limitation, you can create 2 LiveReports: a main LiveReport to list all groups and their ID's, and a sub-report that will display the information particular to the group selected from the main report results page. Here is an example that gets all the e-mail addresses of users in a group selected from the main LiveReport. The sub-report will be activated from the main report by clicking on a "details" link next to the group for which e-mail addresses are desired. Below is a sample main report and subreport that you can use. Sub-report: Title - E-mail addresses of users in a group Input: Number Prompt: Enter the numeric ID of the group SQL: select a.Name, a.FirstName, a.LastName, a.mailaddress from kuaf a, kuafchildren b where a.ID=b.childID and b.ID=%1 Param %1: User Input 1 Report Format: AutoLiveReport Main report: Title: Groups Listing with Group IDs SQL: select name, id from kuaf where type=1 Report Format: AutoLiveReport Click-thru subreport: (browse Livelink here to select the sub-report "E-mail addresses of users in a group" described above) Sub-report param 1: ID - 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
------------------------------------------------------
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 23, 2006 4:16 AM
To: eLink Recipient
Subject: Group ID as parameter

Group ID as parameter

Posted by habis (Bilton, Alison) on 08/23/2006 04:12 AM

Chris_Jones

Message from Jones, Christopher L. \(IT\) via eLinkI think when you pass the dates to the third report the format type ofthe data value has to be input as a string. IF that value is Date thenLivelink presents you with the Date input form...-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Wednesday, August 23, 2006 9:24 AMTo: eLink RecipientSubject: I did go down this route and got it working fine, but myproblem is that I want...I did go down this route and got it working fine, but my problem is thatI want...Posted by Bilton, Alison on 08/23/2006 10:22 AMI did go down this route and got it working fine, but my problem is thatI want start and end date parameters as well. I've tried adding them as parameters on the main report and pushing themthrough along with the group id, and also adding them to the subreport,but I can't get it to work either way. Unless I'm doing somethingsilly...[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Group ID as parameterhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/7646012Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Chris_Jones

Message from Jones, Christopher L. \(IT\) via eLinkYou can do this without Web Reports build a Sub Report that List Groupsfrom the KUAF table and pass the Group ID to the child Report in theKUAF Children Table.Chris -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Wednesday, August 23, 2006 3:16 AMTo: eLink RecipientSubject: Group ID as parameterGroup ID as parameterPosted by Bilton, Alison on 08/23/2006 04:12 AMI want to display data for users who belong to a particular group. Hasanyone figured out a way of requesting a user to choose a group id/nameother than displaying a textbox for them to type something in? There'sa parameter type of user - surely group isn't that difficult toimplement as well?[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Alison_Bilton_(habis_-_(deleted))

Yes we are using an Oracle database. Thanks for your help - I'll raise a ticket and try Webforms.

Alison_Bilton_(habis_-_(deleted))

Thanks for the tip - I'll try both ways.