how do I pass current record parameter & additional parameters entered in UI

peraka · 2012-07-09T04:38:55+00:00

Hi All, I've requirement to pass the current record PO number in the report and also the user entered parameters to pass to report query. I'm not able to achieve this by params["where"]. Could you please provide your inputs in building the where clause. thanks, Suresh.

peraka

Hi All,

I've requirement to pass the current record PO number in the report and also the user entered parameters to pass to report query.

I'm not able to achieve this by params["where"].

Could you please provide your inputs in building the where clause.

thanks,
Suresh.

Find more posts tagged with

Comments

jverly01

I want to make sure what your problem is. Are you wanting to show the parameters on the report output or the report isn't filtering results on the entered paramter values?

peraka

Hi,

My report should retrieve results based on 2 parameters i.e.

First Parameter should be taken from the current record in Maximo,
Second Parameter should be taken from the user input.

This report is run against a Purchase Order in PO application, user will open a PO and he will run this report, while the report is running it should consider the current PO number as one parameter and user input parameter as the second parameter i.e. poline number.

How do I achieve this?

Thanks,
Suresh.

sdlemaster

This is not possible. The report either has to be designed to use the where clause or user entered parameters. 
 
<blockquote class='ipsBlockquote' data-author="'peraka'" data-cid="107053" data-time="1341891825" data-date="09 July 2012 - 08:43 PM">
Hi, 
 
My report should retrieve results based on 2 parameters i.e. 
 
First Parameter should be taken from the current record in Maximo, 
Second Parameter should be taken from the user input. 
 
This report is run against a Purchase Order in PO application, user will open a PO and he will run this report, while the report is running it should consider the current PO number as one parameter and user input parameter as the second parameter i.e. poline number. 
 
How do I achieve this? 
 
Thanks, 
Suresh. </blockquote>

wwilliams

If the "use where clause" check box is checked the report will use the where clause and your parameters. 
 
Look in your report development manual under reports.xml. 
<pre class='_prettyXprint _lang-auto _linenums:0'><attributename="usewherewithparam" >0</attribute></pre>
"Will the report execute against both current/selected records and user inputted parameters? 0=No/1=Yes"...