Hi,

I have created a new thread.

Regards,

Anusha

Hi Rajesh,

I have one doubt regarding the parameter. In my requirement I have to add one parameter in the report. That's why I changed 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 you 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