Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » using ONE parameter MANY TIMES in the SQL query
using ONE parameter MANY TIMES in the SQL query [message #170939] Fri, 16 June 2006 10:38 Go to next message
Eclipse UserFriend
Originally posted by: vincent.tiberghien.ird.sn

Hello,
I have defined a data set, with one parameter

Nom | Type de données | Direction | Valeur par défaut
ParamDate | DateHeure | Entrée | 01/01/1983

Then i need to add this parameter in my SQL Query, i want to use it two
times, like this

select *
from Table
where Table.date1 > ? and Table.date2 > ?

The two ? should be replaced bu ParamDate. How can i do this ?
Re: using ONE parameter MANY TIMES in the SQL query [message #170993 is a reply to message #170939] Fri, 16 June 2006 11:40 Go to previous messageGo to next message
Eclipse UserFriend
The only way to do this currently is add the second data set parameter and
then assign the same default value.
You could also tie the defaults to the same report parameter.

Jason

"vincent tiberghien" <vincent.tiberghien@ird.sn> wrote in message
news:e6ufuc$q3j$1@utils.eclipse.org...
> Hello,
> I have defined a data set, with one parameter
>
> Nom | Type de donn
Re: using ONE parameter MANY TIMES in the SQL query [message #171001 is a reply to message #170993] Fri, 16 June 2006 11:46 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: vincent.tiberghien.ird.sn

ok, thank you

Jason Weathersby a écrit :
> The only way to do this currently is add the second data set parameter and
> then assign the same default value.
> You could also tie the defaults to the same report parameter.
>
> Jason
>
> "vincent tiberghien" <vincent.tiberghien@ird.sn> wrote in message
> news:e6ufuc$q3j$1@utils.eclipse.org...
>> Hello,
>> I have defined a data set, with one parameter
>>
>> Nom | Type de données | Direction | Valeur par défaut
>> ParamDate | DateHeure | Entrée | 01/01/1983
>>
>> Then i need to add this parameter in my SQL Query, i want to use it two
>> times, like this
>>
>> select *
>> from Table
>> where Table.date1 > ? and Table.date2 > ?
>>
>> The two ? should be replaced bu ParamDate. How can i do this ?
>
>
Re: using ONE parameter MANY TIMES in the SQL query [message #172279 is a reply to message #170939] Wed, 21 June 2006 12:32 Go to previous messageGo to next message
Eclipse UserFriend
This is easy. Define a report parameter called WHERE_CLAUSE

<list-property name="parameters">
<structure>
<property name="name">WHERE_CLAUSE</property>
<property name="dataType">string</property>
<property name="position">1</property>
<property name="defaultValue">"1"</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>

Then, in the SQL embedded in your .rptdesign file, include this:

WHERE 1 = ?


Finally, build your SQL in Java and then assign to the WHERE_CLAUSE
parameter the following:

1 AND ...[add any SQL you want here, because your ultimate SQL that
will be executed will be:

WHERE 1 = 1 AND ....[your SQL here].
Re: using ONE parameter MANY TIMES in the SQL query [message #184898 is a reply to message #170939] Tue, 15 August 2006 01:56 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: harunhasdal.gmail.com

vincent tiberghien wrote:
> Hello,
> I have defined a data set, with one parameter
>
> Nom | Type de données | Direction | Valeur par défaut
> ParamDate | DateHeure | Entrée | 01/01/1983
>
> Then i need to add this parameter in my SQL Query, i want to use it two
> times, like this
>
> select *
> from Table
> where Table.date1 > ? and Table.date2 > ?
>
> The two ? should be replaced bu ParamDate. How can i do this ?

You can use the beforeOpen script of the dataset to modify the query
freely. In the script queryText variable represents the dataset's query.
Re: using ONE parameter MANY TIMES in the SQL query [message #185751 is a reply to message #184898] Thu, 17 August 2006 17:30 Go to previous messageGo to next message
Eclipse UserFriend
Harun,
To do this, you need to build your WHERE clause entirely in Java and
then set it as a parameter. Then, use the before open method. Please use
this file as an example:

Look for the parameter WHERE_CLAUSE and then track how I use it through
the file.
Pay attention to the beforeOpen method--you will need to do that. If you
have more questions, write me at: tyronehed@earthlink.net


<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 1.0.1 Build
&lt;20051130-1157></property>
<property name="units">in</property>
<text-property name="displayName">Edit Error By Claim</text-property>
<parameters>
<scalar-parameter name="WHERE_CLAUSE" id="7">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">1 = 0</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>

<scalar-parameter name="CURRENT_DATE" id="8">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">01/01/1970</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="CURRENT_TIME" id="9">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">00:00:00.0</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="REQUESTER" id="10">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">Leo Tolstoy</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="FLAG_TYPES" id="11">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">NOFLAGTYPES</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="ENVIRONMENT" id="12">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">NOENVIRONMENT</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="MOST_RECENT_ANALYSIS" id="13">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">01/01/1970</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="CLAIM_ID_RANGE" id="14">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">0 TO 0</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="IMPORT_DATE_RANGE" id="15">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">01/01/1970 to 01/01/1970</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="DATE_OF_SERVICE_RANGE" id="16">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">01/01/1970 to 01/01/1970</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="BATCH_RANGE" id="17">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">0 to 0</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="PROVIDER_RANGE" id="18">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">0 to 0</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="PATIENT_RANGE" id="19">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">0 to 0</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="SORT_BY" id="20">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">no sort</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="ACCOUNTS" id="21">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">no accounts</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="PLANS" id="22">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">no plans</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="FLAGS" id="23">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">no flags</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="CLAIM_STATUS" id="24">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">01/01/1970</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="USERS" id="25">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">01/01/1970</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="PROVIDER_SPECIALTIES" id="26">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">no specialties</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="PLACE_OF_SERVICE" id="27">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">no place of service</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="DIAGNOSIS_CODES" id="28">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">no diag codes</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>
<scalar-parameter name="PROCEDURE_CODES" id="29">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="defaultValue">no proc codes</property>
<property name="controlType">text-box</property>
<property name="format">Unformatted</property>
</scalar-parameter>

</parameters>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="44">
<property
name="odaDriverClass">net.sourceforge.jtds.jdbc.Driver</property >
<property
name="odaURL">jdbc:sqlserver://localhost:1433;databaseName=FREYA_DB</property>
<property name="odaUser">FREYA</property>
<encrypted-property
name="odaPassword">bWlkZ2FyZDE=</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Claim Data Set" id="45">
<property name="dataSource">Data Source</property>
<method name="beforeOpen"><![CDATA[this.queryText =
this.queryText + " " + params["WHERE_CLAUSE"];]]></method>
<property name="queryText">SELECT (CASE WHEN
CLAIM1.SUBMITTED_CLAIM_IID IS NULL
THEN CLAIM1.CLAIM_IID
ELSE CLAIM1.SUBMITTED_CLAIM_IID
END
) AS 'COND CLAIM_IID',
CLAIM_LINE.CLAIM_LINE_IID AS 'CLAIM_LINE_IID',
CLAIM1.CLAIM_EID AS 'Claim Id',
PATIENT.MEDICAL_RECORD_NUMBER AS 'Patient Id',
PATIENT.DATE_OF_BIRTH AS 'Patient DOB',
CLAIM1.BATCH_EID AS 'Batch',
CLAIM1.CLAIM_STATUS AS 'Claim Status',
CLAIM1.ACCOUNT_EID AS 'Account Id',
ACCOUNT.NAME AS 'Account',
PATIENT.GENDER AS 'Gender',
ENTERPRISE.NAME AS 'Enterprise',
CLAIM1.PLAN_EID AS 'Plan Id',
INSURANCE_PLAN.DESCRIPTION AS 'Plan',
CLAIM1.SYSTEM_ENTRY_DATE AS 'Import Date',
CLAIM1.CONTEXT AS 'Environment',
CLAIM_LINE.SERVICE_START_DATE AS 'Begin DOS',
CLAIM_LINE.SERVICE_END_DATE AS 'End DOS',
CLAIM_LINE.ADJUSTED_PROCEDURE_CODE AS 'Adj Proc Code',
CLAIM_LINE_MODIFIER.MODIFIER_CODE AS 'Modifier Code',
CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE AS 'Diagnosis Code',
CLAIM_LINE.SERVICE_UNITS AS 'Units',
CLAIM_LINE.PLACE_OF_SERVICE_CODE AS 'POS',
CLAIM_LINE.TYPE_OF_SERVICE_CODE AS 'TOS',
PRACTITIONER.PRACTITIONER_EID AS 'Provider Id',
PRACTITIONER.FIRST_NAME + ' ' + PRACTITIONER.LAST_NAME AS 'Provider Name',
CLAIM_LINE.CHARGED_AMOUNT AS 'Sub Charge',
CLAIM_LINE.ADJUSTED_AMOUNT AS 'Adj Charge',
CLAIM_LINE.SEQUENCE_NUMBER AS 'Claim Line Seq',
(
CASE
WHEN CLAIM_LINE_EDIT.EDIT_MNEMONIC IS NOT NULL
THEN 'Yes'
ELSE 'No'
END
) AS 'Flag Indicator',
CLAIM_LINE_EDIT.EDIT_MNEMONIC AS 'Edit Mnemonic',
CLAIM_LINE_EDIT.EDIT_MESSAGE AS 'Edit Description',
CLAIM_LINE_EDIT.ACTION AS 'Flag Status',
CLAIM1.SUBMITTED_CLAIM_IID AS 'Submitted CLAIM_IID',
CLAIM1.CLAIM_IID AS 'CLAIM_IID',
CLAIM_LINE.CLAIM_LINE_EID AS 'Line EID',
CLAIM1.IS_MODIFIED AS 'Modified From Claim',
CLAIM_LINE.IS_MODIFIED AS 'Modified From Claim_Line',
CLAIM_LINE.RULESET_NAME AS 'Ruleset Name',
( CASE WHEN ( SELECT COUNT(PROCEDURE_CODE)
FROM PROCEDURE_CODE
WHERE PROCEDURE_CODE = CLAIM_LINE.ADJUSTED_PROCEDURE_CODE
AND CATEGORY = 'CP'
) = 0
THEN 0
ELSE 1
END
) AS 'AMA Adj Proc Code',
( SELECT SUM(CLAIM_LINE.CHARGED_AMOUNT)
FROM CLAIM_LINE
WHERE CLAIM_IID = CLAIM1.CLAIM_IID
AND CLAIM1.IS_MODIFIED = 'N'
GROUP BY CLAIM_IID
) AS 'Total Sub Charge',
( SELECT SUM(CLAIM_LINE.ADJUSTED_AMOUNT)
FROM CLAIM_LINE
WHERE CLAIM_IID = CLAIM1.CLAIM_IID
AND CLAIM1.IS_MODIFIED = 'N'
GROUP BY CLAIM_IID
) AS 'Total Adj Charge',
( CASE WHEN (( SELECT COUNT(DISTINCT CLAIM_IID)
FROM CLAIM
WHERE CLAIM_IID = CLAIM1.CLAIM_IID
OR SUBMITTED_CLAIM_IID = CLAIM1.CLAIM_IID
) > 1
AND CLAIM1.IS_MODIFIED = 'N')
THEN 0
ELSE 1
END
) AS 'Show Results'
FROM CLAIM CLAIM1
INNER JOIN CLAIM_LINE ON CLAIM1.CLAIM_IID = CLAIM_LINE.CLAIM_IID
INNER JOIN ENTERPRISE ON CLAIM1.ENTERPRISE_IID = ENTERPRISE.ENTERPRISE_IID
LEFT OUTER JOIN PROCEDURE_CODE ON CLAIM_LINE.ADJUSTED_PROCEDURE_CODE =
PROCEDURE_CODE.PROCEDURE_CODE
LEFT OUTER JOIN CLAIM_LINE_MODIFIER ON CLAIM_LINE.CLAIM_LINE_IID =
CLAIM_LINE_MODIFIER.CLAIM_LINE_IID
LEFT OUTER JOIN MODIFIER_CODE ON CLAIM_LINE_MODIFIER.MODIFIER_CODE =
MODIFIER_CODE.MODIFIER_CODE
LEFT OUTER JOIN CLAIM_LINE_DIAGNOSIS ON CLAIM_LINE.CLAIM_LINE_IID =
CLAIM_LINE_DIAGNOSIS.CLAIM_LINE_IID
LEFT OUTER JOIN DIAGNOSIS_CODE ON CLAIM_LINE_DIAGNOSIS.DIAGNOSIS_CODE =
DIAGNOSIS_CODE.DIAGNOSIS_CODE
LEFT OUTER JOIN INSURANCE_PLAN ON CLAIM1.PLAN_EID =
INSURANCE_PLAN.INSURANCE_PLAN_EID
LEFT OUTER JOIN ACCOUNT ON CLAIM1.ACCOUNT_EID = ACCOUNT.ACCOUNT_EID
LEFT OUTER JOIN CLAIM_LINE_EDIT ON CLAIM_LINE.CLAIM_LINE_IID =
CLAIM_LINE_EDIT.CLAIM_LINE_IID
LEFT OUTER JOIN PATIENT ON CLAIM1.PATIENT_IID = PATIENT.PATIENT_IID
LEFT OUTER JOIN PRACTITIONER ON CLAIM_LINE.PRACTITIONER_IID =
PRACTITIONER.PRACTITIONER_IID
WHERE
</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="UDF Data Set" id="907">
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">UDF_CL_IID</property>
<property name="dataType">integer</property>
<property name="position">1</property>
<expression name="defaultValue">10007</expression>
<property name="isInput">true</property>
</structure>
</list-property>
<property name="queryText">SELECT
CLAIM.CLAIM_IID AS 'UDFDS CLAIM_IID',
CLAIM_LINE.CLAIM_LINE_IID AS 'UDFDS CLAIM_LINE_IID',
CLAIM_LINE.CLAIM_LINE_EID AS 'UDFDS Line ID',
UDF_DEFINITION.NAME AS 'UDFDS UDF Name',
UDF_DEFINITION.ORDINAL AS 'UDFDS Ordinal',
CLAIM_LINE_USER_DEFINED_FIELD.VALUE AS 'UDFDS UDF Value'
FROM
CLAIM
INNER JOIN CLAIM_LINE ON CLAIM.CLAIM_IID = CLAIM_LINE.CLAIM_IID
LEFT OUTER JOIN UDF_DEFINITION ON CLAIM.ENTERPRISE_IID =
UDF_DEFINITION.ENTERPRISE_IID
LEFT OUTER JOIN CLAIM_LINE_USER_DEFINED_FIELD ON
( CLAIM_LINE.CLAIM_LINE_IID = CLAIM_LINE_USER_DEFINED_FIELD.CLAIM_LINE_IID
AND UDF_DEFINITION.ORDINAL = CLAIM_LINE_USER_DEFINED_FIELD.ORDINAL)
WHERE CLAIM_LINE.CLAIM_IID = ?
</property>
</oda-data-set>
</data-sets>
<styles>
<style name="ReportHeader_Style" id="898">
<property name="fontFamily">Times New Roman</property>
<property name="fontSize">large</property>
<property name="fontWeight">bold</property>
</style>
<style name="Labels_Style" id="899">
<property name="fontFamily">Times New Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
</style>
<style name="Values_Style" id="900">
<property name="fontFamily">Times New Roman</property>
<property name="fontSize">small</property>
</style>
<style name="ReportSubHeading_Style" id="901">
<property name="fontFamily">Times New Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<property name="textUnderline">underline</property>
</style>
<style name="Currency_Style" id="902">
<property name="fontFamily">Times New Roman</property>
<property name="fontSize">small</property>
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$#,##0.00</property>
</structure>
</style>
<style name="ClaimLinesTotals_Style" id="903">
<property name="fontFamily">Times New Roman</property>
<property name="fontSize">small</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<structure name="numberFormat">
<property name="category">Currency</property>
<property name="pattern">$#,##0.00</property>
</structure>
</style>
<style name="Date_Style" id="904">
<structure name="dateTimeFormat">
<property name="category">Custom</property>
<property name="pattern">Short Date</property>
</structure>
</style>
<style name="HeaderBloack_Style" id="905">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</style>
<style name="LineSeperator_Style" id="906">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderTopStyle">none</property>
<property name="borderTopWidth">thin</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="orientation">landscape</property>
<property name="topMargin">0.604in</property>
<property name="leftMargin">0.416in</property>
<property name="bottomMargin">0.468in</property>
<property name="rightMargin">0.072in</property>
</simple-master-page>
</page-setup>
<body>
<list id="41">
<property name="dataSet">Claim Data Set</property>
<header>
<label id="200">
<property name="style">ReportHeader_Style</property>
<property name="fontFamily">Times New Roman</property>
<property name="fontSize">large</property>
<property name="fontWeight">bold</property>
<text-property name="text">Edit Error By
Claim</text-property>
</label>
<grid id="151">
<property name="width">100%</property>
<column id="152">
<property name="style">Labels_Style</property>
</column>
<column id="153"/>
<column id="154">
<property name="style">Labels_Style</property>
</column>
<column id="155"/>
<column id="156">
<property name="style">Labels_Style</property>
</column>
<column id="157"/>
<row id="158">
<cell id="159">
<property
name="backgroundColor">silver</property>
<label id="201">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Date:</text-property>
</label>
</cell>

<cell id="1160">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="12270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["CURRENT_DATE"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="161">
<property
name="backgroundColor">silver</property>
<label id="207">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property name="text">Claim ID
Range:</text-property>
</label>
</cell>
<cell id="2162">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="62270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["CLAIM_ID_RANGE"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="163">
<property
name="backgroundColor">silver</property>
<label id="213">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property name="text">Sort
by:</text-property>
</label>
</cell>

<cell id="92164">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="162270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["SORT_BY"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
</row>
<row id="165">
<cell id="166">
<property
name="backgroundColor">silver</property>
<label id="202">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Time:</text-property>
</label>
</cell>

<cell id="93167">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="32270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["CURRENT_TIME"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="168">
<property
name="backgroundColor">silver</property>
<label id="208">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property name="text">Import Date
Range:</text-property>
</label>
</cell>
<cell id="41969">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="429270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["IMPORT_DATE_RANGE"]</expression >
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="170">
<property
name="backgroundColor">silver</property>
<label id="214">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Account(s):</text-property>
</label>
</cell>
<cell id="41971">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="4942270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["ACCOUNTS"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
</row>
<row id="172">
<cell id="173">
<property
name="backgroundColor">silver</property>
<label id="203">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Requester:</text-property>
</label>
</cell>
<cell id="95174">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="952270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["REQUESTER"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="175">
<property
name="backgroundColor">silver</property>
<label id="209">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property name="text">Date of Service
Range:</text-property>
</label>
</cell>
<cell id="95176">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="9852270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["DATE_OF_SERVICE_RANGE"]</expression >
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="177">
<property
name="backgroundColor">silver</property>
<label id="215">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Plan(s):</text-property>
</label>
</cell>
<cell id="50178">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="502270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["PLANS"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
</row>
<row id="179">
<cell id="180">
<property
name="backgroundColor">silver</property>
<label id="204">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property name="text">Flag
Types:</text-property>
</label>
</cell>
<cell id="60181">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="620270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["FLAG_TYPES"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="182">
<property
name="backgroundColor">silver</property>
<label id="210">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property name="text">Batch
Range:</text-property>
</label>
</cell>
<cell id="61283">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="622270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["BATCH_RANGE"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="184">
<property
name="backgroundColor">silver</property>
<label id="216">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Flag(s):</text-property>
</label>
</cell>
<cell id="61285">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="6922270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["FLAGS"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
</row>
<row id="186">
<cell id="187">
<property
name="backgroundColor">silver</property>
<label id="205">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Environment(s):</text-property>
</label>
</cell>
<cell id="71388">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="732270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["ENVIRONMENT"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="189">
<property
name="backgroundColor">silver</property>
<label id="211">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Provider(s):</text-property>
</label>
</cell>
<cell id="73190">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="723270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["PROVIDER_RANGE"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="191">
<property
name="backgroundColor">silver</property>
<label id="217">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property name="text">Claim
Statuses:</text-property>
</label>
</cell>
<cell id="73192">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="7023270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["CLAIM_STATUS"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
</row>
<row id="193">
<cell id="194">
<property
name="backgroundColor">silver</property>
<label id="206">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property name="text">Most Recent
Analysis:</text-property>
</label>
</cell>
<cell id="71495">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="742270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["MOST_RECENT_ANALYSIS"]</expression >
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="196">
<property
name="backgroundColor">silver</property>
<label id="212">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">Patient(s):</text-property>
</label>
</cell>
<cell id="81497">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="842270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["PATIENT_RANGE"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
<cell id="198">
<property
name="backgroundColor">silver</property>
<label id="218">
<property
name="style">Labels_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">small</property>
<property name="fontWeight">bold</property>
<text-property
name="text">User(s):</text-property>
</label>
</cell>
<cell id="94199">
<property name="style">Values_Style</property>
<property
name="backgroundColor">silver</property>
<text-data id="942270">
<property name="dataSet">Claim Data
Set</property>
<expression
name="valueExpr">params["USERS"]</expression>
<property
name="contentType">html</property>
<property name="textAlign">left</property>
</text-data>
</cell>
</row>
</grid>
</header>
<group id="48">
<property name="groupName">Claim Header Group</property>
<property name="interval">none</property>
<property name="sortDirection">asc</property>
<expression name="keyExpr">row["COND
CLAIM_IID"]</expression>
<list-property name="sort">
<structure>
<expression
name="key">row["CLAIM_IID"]</expression>
</structure>
</list-property>
<header>
<label id="51">
<property
name="style">ReportSubHeading_Style</property>
<property name="fontFamily">Times New
Roman</property>
<property name="fontSize">smaller</property>
<property name="fontWeight">bold</property>
Re: using ONE parameter MANY TIMES in the SQL query [message #185850 is a reply to message #184898] Fri, 18 August 2006 02:21 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jeromevergereau.hotmail.com

hello,
Perharps you could try this .

You define 2 parameters in your "dataSet" (example:
"dsParams1","dsParams2")
but define just one parameter in the "Report Parameter" ("rptTheParams")
and then you define default value of the 2 "ds.." parameters with
"rptTheParams".
Problem solved.
Re: using ONE parameter MANY TIMES in the SQL query [message #186071 is a reply to message #185850] Fri, 18 August 2006 17:00 Go to previous message
Eclipse UserFriend
You can certainly go to the trouble of defining multiple parameters but
I still recommend you build your WHERE clause in Java and pass it down as
one parameter, using the beforeOpen method to replace the query.
Previous Topic:HELP: filtering the columns of a table
Next Topic:HYPERLINK doesn't show up !!!
Goto Forum:
  


Current Time: Sun Jul 27 13:41:20 EDT 2025

Powered by FUDForum. Page generated in 0.06106 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly