gnue
[Top][All Lists]
Advanced

[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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]