Mark the Database Column based on what counting should be done.
For Example if, Report is related with Purchase order print , then PO_Header_id or Segment1 can be treated as Base Database Column from SQL Query.
or if report belongs to Order Management , and records are fetched based on Order numbers then HEADER_ID from oe_order_headers_all.
then on RTF template Use if/end if condition
<?if:count(//PO_HEADER_ID)=0?>
or
<?if:count(//HEADER_ID)=0?>
For Example if, Report is related with Purchase order print , then PO_Header_id or Segment1 can be treated as Base Database Column from SQL Query.
or if report belongs to Order Management , and records are fetched based on Order numbers then HEADER_ID from oe_order_headers_all.
then on RTF template Use if/end if condition
<?if:count(//PO_HEADER_ID)=0?>
or
<?if:count(//HEADER_ID)=0?>
No comments:
Post a Comment