nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create a livereport with input values appearing in dropdown

Priyanka_Srivastava

I want to create a Livereport where the user will be prompted to select a value from drop down like days. Is something like this possible. Also will be creating a webreport using this livereport.

Find more posts tagged with

Comments

Colin_Schmidt

Number of days or Days (1 - 31) or day of a given Month?

Colin J.

On Wed, Feb 18, 2015 at 6:05 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Create a livereport with input values appearing in dropdown Posted bypriyanka.srivastava@alstom.com (Srivastava, Priyanka)On 02/18/2015 06:01 AM

Hi I want to create a Livereport where the user will be prompted to select a value from drop down like days. Is something like this possible. Also will be creating a webreport using this livereport.
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation (mwv.com) or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Priyanka_Srivastava

IT will be days like 1 , 7, 30, 60, and 90.

Thanks Colin.

Colin_Schmidt

It's not possible for a drop down.

You would have them key in the value and do the date calc in the code. If they key in '37' you could take the current date and subtract 37 days from it or add 37 days to it. That's not difficult in Oracle(CURRENT_DATE) or SQL Server(GETDATE()).

DATEADD() works in both, from what the docs say. You can use Positive and Negative values.

Colin J.

On Wed, Feb 18, 2015 at 10:31 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Re Create a livereport with input values appearing in dropdown Posted bypriyanka.srivastava@alstom.com (Srivastava, Priyanka)On 02/18/2015 10:29 AM

IT will be days like 1 , 7, 30, 60, and 90.Thanks Colin.
[To post a comment, use the normal reply function]
Topic: Create a livereport with input values appearing in dropdown
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

Fran_Rogers

You could always create a custom view withthe values in a drop down and a link to the webreport.
Apologies if I am telling you how to 'suck eggs'

<td>
<form name="Completedcontractchecks"method="post" ENCTYPE="multipart/form-data">
<input type="hidden" name="func"value="ll" />
<input type="hidden" name="objAction"value="RunReport" />
<input type="hidden" name="Objid"value="172" />

  <input type="hidden" name="nextUrl"value="%2Fotcs%2Flivelink%2Eexe%3Ffunc%3Dll%26objid%3D178%26objAction%3Dbrowse%26sort%3Dname"/>

Completed checks (in the last
<select name="no_of_days">
<option value="30">30</option>
<option value="60">60</option>
<option value="90" selected>90</option>
<option value="120">120</option>
<option value="150">150</option>
</select> days)  
<INPUT TYPE="SUBMIT" VALUE="Go">

With kind regards/Met vriendelijke groet

Fran Rogers

From:   "eLink Entry:Content Server LiveReports Forum" <livereportsdiscussion@elinkkc.opentext.com>
To:   eLink Recipient <devnull@elinkkc.opentext.com>
Date:   18/02/2015 15:58
Subject:    Re ReCreate a livereport with input values appearing in dropdown

ReRe Create a livereport with input values appearing in dropdown

Postedby colin.schmidt@mwv.com(Schmidt, Colin) On 02/18/2015 10:53 AM

It's not possible for a drop down.

You would have them key in the value and do the date calcin the code. If they key in '37' you could take the current dateand subtract 37 days from it or add 37 days to it. That's not difficultin Oracle(CURRENT_DATE) or SQL Server(GETDATE()).

DATEADD() works in both, from what the docs say. You can use Positive and Negative values.

Colin J.

On Wed, Feb 18, 2015 at 10:31 AM, eLink Entry: ContentServer LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>wrote:

ReCreate a livereport with input values appearing in dropdown

Postedby priyanka.srivastava@alstom.com(Srivastava, Priyanka) On 02/18/2015 10:29 AM

IT will be days like 1 , 7, 30, 60, and 90.

Thanks Colin.

[Topost a comment, use the normal reply function]
Topic:	Createa livereport with input values appearing in dropdown
Forum:	ContentServer LiveReports Forum
ContentServer:	KnowledgeCenter

This electronic message contains information from MeadWestvaco Corporation(mwv.com)or subsidiary companies, which may be confidential, privileged or otherwiseprotected from disclosure. The information is intended to be used solelyby the recipient(s) named. If you are not an intended recipient, be awarethat any review, disclosure, copying, distribution or use of this transmissionor its contents is prohibited. If you have received this transmission inerror, please notify MeadWestvaco immediately at postmaster@mwv.com.

[Topost a comment, use the normal reply function]
Topic:	Createa livereport with input values appearing in dropdown
Forum:	ContentServer LiveReports Forum
ContentServer:	KnowledgeCenter

---------------------------------------------------------------------------------------------------------------
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.
If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system.
If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.

Please consider the environmental impact before printing this document and its attachment(s).
Print black and white and double-sided where possible.

----------------------------------------------------------------------------------

Giovanny Buitrago

Hi,

I've the same requeriment, but I don´t have webreports is there any option just using livereports?

eLink User

In my mind you do not need WR to create a good looking HTML file

The previous poster gave you contents that

Would go into a custom view a object that

You add using the livelink gui

You can use appearances as well

You have to set the URL correct and objids correctly

That is all

Sent from my iPhone

On Feb 18, 2015, at 1:28 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

eLink : Re Re Re Create a livereport with input values appearing in dropdown
Re Re Re Create a livereport with input values appearing in dropdown Posted bygiovannyb@projectioncore.com (Buitrago, Giovanny)On 02/18/2015 02:23 PM

Hi,I've the same requeriment, but I don´t have webreports is there any option just using livereports?
[To post a comment, use the normal reply function]
Topic: Create a livereport with input values appearing in dropdown
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

Colin_Schmidt

Here's code within Oracle to take whatever value keyed and convert it to compare. The related to the table is unimportant compared to the manipulation of the date. I have the type of input as "String".

select dt.dataid, dt.name, dt.modifydate,

(CURRENT_DATE - interval %1 DAY) "BackDate"

from dtree dt

where dt.modifydate >= (CURRENT_DATE - interval %2 DAY)

Colin J.

On Wed, Feb 18, 2015 at 2:28 PM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Re Re Re Create a livereport with input values appearing in dropdown Posted bygiovannyb@projectioncore.com (Buitrago, Giovanny)On 02/18/2015 02:23 PM

Hi,I've the same requeriment, but I don´t have webreports is there any option just using livereports?
[To post a comment, use the normal reply function]Topic:Create a livereport with input values appearing in dropdownForum:Content Server LiveReports ForumContent Server:Knowledge Center

image.png

LastDays.JPG

Priyanka_Srivastava

Thanks a lot Colin. The query was too helpful... It was something i was looking for.