How do we add parameter in the data template to get the desired output

Anusha Dupuguntla

Summary

How do we add parameter in the data template to get the desired output

Content

Hi,

I have one doubt regarding the parameter. In my requirement I have to add one parameter in the report. That's why I used the data template as shown below but the output is not as expected.

<dataTemplate name="myDataTemplate">

<properties>

<property name="debug_mode" value="on"/>

</properties>

<parameters>

<parameter name="loc" dataType="integer"/>

</parameters>

<dataQuery>

<sqlStatement name="Q_LOC">

select distinct loc from item_loc_soh

</sqlStatement>

        <sqlStatement name="Q_ITEM_LOC">

            <![CDATA[select item

              ,stock_on_hand

  ,loc

  ,ceil(rownum/65000) countrow

    from item_loc_soh where stock_on_hand > 0

and loc=nvl(:loc,loc)]]>

        </sqlStatement>

    </dataQuery>

    <dataStructure>

<group name="LOC" source="Q_ITEM_LOC">

<element name="LOC" value="LOC"/>

        <group name="G_RECORD_GROUP" source="Q_ITEM_LOC">

            <element name="RECORD_GROUP" value="COUNTROW"/> 

            <group name="ROW" source="Q_ITEM_LOC">

                <element name="ITEM" value="ITEM"/>

                <element name="STOCK_ON_HAND" value="STOCK_ON_HAND"/>

                <element name="LOC" value="LOC"/>

            </group>

        </group>

</group>

    </dataStructure>

</dataTemplate>

Can any one please help me with this? Is the changes made are correct or else can I add anything more to get the output as expected?

Note : When I select a particular location from the drop down  list the report must shows the data regarding to that location and if no location is selected then report has to show all the locations data and at a time if the data reaches maximum limit of 65000 the report has to split into sheets.

Regards,

Anusha