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>…

Hi, I have created a new thread. Regards, Anusha

Hi Again, Thanks a lot for sharing the example. I am getting the XML data like as you have mentioned in the example. I also added XDO_SHEET_? by specifying the group name as <?.//G_RECORD_GROUP?> in XDO_METADATA sheet. My problem is when I am viewing the template in excel I am getting 65000 records in sheet1 and another…

Hi, Please find the below xml data: <LIST_G_RECORD_GROUP> <G_RECORD_GROUP> <RECORD_GROUP>1</RECORD_GROUP> <LIST_ROW> <ROW> <ITEM>1000000532098</ITEM> <STOCK_ON_HAND>24</STOCK_ON_HAND> <LOC>568</LOC> </ROW> <ROW> <ITEM>1000000308556</ITEM> <STOCK_ON_HAND>92</STOCK_ON_HAND> <LOC>568</LOC> </ROW> <ROW>…

Hi, Thank you so much !!! It worked. Regards, Anusha

Hi Rajesh, Thank you so much for your inputs. 1. I added CEIL(ROWNUM/65000) COUNTROW in the query. Please find the below query: select item,stock_on_hand,loc,ceil(rownum/65000) countrow from item_loc_soh where stock_on_hand>0; 2. My doubt was where to create new group G_COUNTROW and how to create that. Can you please…

Hi Rajesh, Thanks. The link you have provided is of version 12.2.1.1.0 but we are using 10.1.3.4. We don't have as many options as in 12.2.1.1.0 . Can You please help me with that? Thanks once again for your inputs. Regards, Anusha

Hi, Please find the attached data model and excel template which I have designed. The query is giving above 1k records. I wan to split the report in to multiple sheets based on the row count. Please help me with the changes which I have to change in my SQL code as well as in the template to obtain the result in multiple…

Hi Rajesh, Thanks for your response! I have seen the document previously which you have mentioned. But it doesn't work in my case. I want to know how do we split the report into another sheet if the first sheet reaches maximum of 65K records by using single data model only. Can we mention any logic in the SQL code in order…

Hi, We have excel template. Regards, Anusha