[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Using parameter in datasource condition
From: |
Kishan Bhat |
Subject: |
Using parameter in datasource condition |
Date: |
Mon, 14 Mar 2011 08:30:53 +0530 |
Hello All,
Can I use parameter values inside datasource condition definition? I've underlined the line of interest, the excerpt from my report.grd xml
=============================
<parameters>
<parameter name="printInvId" description="Invoice ID" default="0"/>
</parameters>
<sources>
<datasource database="mipltest" name="dts_invoice_item" table="invoice_item">
<condition>
<and>
<eq>
<cfield name="uid_invoice"/>
<cconst value="printInvId"/>
</eq>
<gt>
<cfield name="quantity"/>
<cconst value="0"/>
</gt>
</and>
</condition>
</datasource>
</sources>
=============================
I need to generate reports for a specific invoice id only, by passing the id as a parameter.
Thanks,
Kishan
- Using parameter in datasource condition,
Kishan Bhat <=