[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
6.4

XSL transforamtion output is not coming correctly

Asked by ramadevimandala in Extensible Stylesheet Language Transformation (XSLT), Extensible Markup Language (XML)

Hi,

I want to generated xml from xml using xsl,
In the output xml Iam not getting the parameters, can anybody tell me where I am making mistake

 here is my source xml: 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:
365:
366:
367:
368:
369:
370:
371:
372:
373:
374:
375:
376:
377:
378:
379:
380:
381:
382:
383:
384:
385:
386:
387:
388:
389:
390:
391:
392:
393:
394:
395:
396:
397:
398:
399:
400:
401:
402:
403:
404:
405:
406:
407:
408:
409:
410:
411:
412:
413:
414:
415:
416:
417:
418:
419:
420:
421:
422:
423:
424:
425:
426:
427:
428:
429:
430:
431:
432:
433:
434:
435:
436:

<?xml version = '1.0'?>
<ROWSET>
   <ROW num="1">
      <APPLICATION_ID>85000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS Reporting Administrator</EIS_RESP_NAME>
      <REPORT_ID>653</REPORT_ID>
      <REPORT_NAME>Test Report</REPORT_NAME>
      <CATEGORY_ID>119</CATEGORY_ID>
      <CATEGORY_NAME>Admin Test Category</CATEGORY_NAME>
      <PARAMETER_ID>4523</PARAMETER_ID>
      <PARAMETER_NAME>Apply Database Link</PARAMETER_NAME>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>1</DISPLAY_ORDER>
   </ROW>
   <ROW num="2">
      <APPLICATION_ID>85000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS Reporting Administrator</EIS_RESP_NAME>
      <REPORT_ID>653</REPORT_ID>
      <REPORT_NAME>Test Report</REPORT_NAME>
      <CATEGORY_ID>119</CATEGORY_ID>
      <CATEGORY_NAME>Admin Test Category</CATEGORY_NAME>
      <PARAMETER_ID>4525</PARAMETER_ID>
      <PARAMETER_NAME>Column Name</PARAMETER_NAME>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>2</DISPLAY_ORDER>
   </ROW>
   <ROW num="3">
      <APPLICATION_ID>85000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS Reporting Administrator</EIS_RESP_NAME>
      <REPORT_ID>653</REPORT_ID>
      <REPORT_NAME>Test Report</REPORT_NAME>
      <CATEGORY_ID>119</CATEGORY_ID>
      <CATEGORY_NAME>Admin Test Category</CATEGORY_NAME>
      <PARAMETER_ID>4527</PARAMETER_ID>
      <PARAMETER_NAME>Object Name</PARAMETER_NAME>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>3</DISPLAY_ORDER>
   </ROW>
   <ROW num="4">
      <APPLICATION_ID>85000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS Reporting Administrator</EIS_RESP_NAME>
      <REPORT_ID>653</REPORT_ID>
      <REPORT_NAME>Test Report</REPORT_NAME>
      <CATEGORY_ID>119</CATEGORY_ID>
      <CATEGORY_NAME>Admin Test Category</CATEGORY_NAME>
      <PARAMETER_ID>4529</PARAMETER_ID>
      <PARAMETER_NAME>Object Owner</PARAMETER_NAME>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>4</DISPLAY_ORDER>
   </ROW>
   <ROW num="5">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <RESPONSIBILITY_ID>21540</RESPONSIBILITY_ID>
      <RESPONSIBILITY_NAME>US Super HRMS Manager(BG =&gt; Vision Corporation)</RESPONSIBILITY_NAME>
      <REPORT_ID>343</REPORT_ID>
      <REPORT_NAME>Application Analysis - Vacancy Summary</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3055</PARAMETER_ID>
      <PARAMETER_NAME>Recruitment Type</PARAMETER_NAME>
      <LOV_ID>191</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>1</DISPLAY_ORDER>
   </ROW>
   <ROW num="6">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <REPORT_ID>343</REPORT_ID>
      <REPORT_NAME>Application Analysis - Vacancy Summary</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3055</PARAMETER_ID>
      <PARAMETER_NAME>Recruitment Type</PARAMETER_NAME>
      <LOV_ID>191</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>1</DISPLAY_ORDER>
   </ROW>
   <ROW num="7">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <RESPONSIBILITY_ID>21540</RESPONSIBILITY_ID>
      <RESPONSIBILITY_NAME>US Super HRMS Manager(BG =&gt; Vision Corporation)</RESPONSIBILITY_NAME>
      <REPORT_ID>343</REPORT_ID>
      <REPORT_NAME>Application Analysis - Vacancy Summary</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3056</PARAMETER_ID>
      <PARAMETER_NAME>Recruitment Activity Name</PARAMETER_NAME>
      <LOV_ID>166</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>2</DISPLAY_ORDER>
   </ROW>
   <ROW num="8">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <REPORT_ID>343</REPORT_ID>
      <REPORT_NAME>Application Analysis - Vacancy Summary</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3056</PARAMETER_ID>
      <PARAMETER_NAME>Recruitment Activity Name</PARAMETER_NAME>
      <LOV_ID>166</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>2</DISPLAY_ORDER>
   </ROW>
   <ROW num="9">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <RESPONSIBILITY_ID>21540</RESPONSIBILITY_ID>
      <RESPONSIBILITY_NAME>US Super HRMS Manager(BG =&gt; Vision Corporation)</RESPONSIBILITY_NAME>
      <REPORT_ID>343</REPORT_ID>
      <REPORT_NAME>Application Analysis - Vacancy Summary</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3057</PARAMETER_ID>
      <PARAMETER_NAME>Business Group Name</PARAMETER_NAME>
      <LOV_ID>153</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>3</DISPLAY_ORDER>
   </ROW>
   <ROW num="10">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <REPORT_ID>343</REPORT_ID>
      <REPORT_NAME>Application Analysis - Vacancy Summary</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3057</PARAMETER_ID>
      <PARAMETER_NAME>Business Group Name</PARAMETER_NAME>
      <LOV_ID>153</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>3</DISPLAY_ORDER>
   </ROW>
   <ROW num="11">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <RESPONSIBILITY_ID>21540</RESPONSIBILITY_ID>
      <RESPONSIBILITY_NAME>US Super HRMS Manager(BG =&gt; Vision Corporation)</RESPONSIBILITY_NAME>
      <REPORT_ID>344</REPORT_ID>
      <REPORT_NAME>Application Analysis Age Analysis</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3059</PARAMETER_ID>
      <PARAMETER_NAME>Requisition Name</PARAMETER_NAME>
      <LOV_ID>192</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>1</DISPLAY_ORDER>
   </ROW>
   <ROW num="12">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <REPORT_ID>344</REPORT_ID>
      <REPORT_NAME>Application Analysis Age Analysis</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3059</PARAMETER_ID>
      <PARAMETER_NAME>Requisition Name</PARAMETER_NAME>
      <LOV_ID>192</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>1</DISPLAY_ORDER>
   </ROW>
   <ROW num="13">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <RESPONSIBILITY_ID>21540</RESPONSIBILITY_ID>
      <RESPONSIBILITY_NAME>US Super HRMS Manager(BG =&gt; Vision Corporation)</RESPONSIBILITY_NAME>
      <REPORT_ID>344</REPORT_ID>
      <REPORT_NAME>Application Analysis Age Analysis</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3061</PARAMETER_ID>
      <PARAMETER_NAME>Vacancy Status</PARAMETER_NAME>
      <LOV_ID>193</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>2</DISPLAY_ORDER>
   </ROW>
   <ROW num="14">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <REPORT_ID>344</REPORT_ID>
      <REPORT_NAME>Application Analysis Age Analysis</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3061</PARAMETER_ID>
      <PARAMETER_NAME>Vacancy Status</PARAMETER_NAME>
      <LOV_ID>193</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>2</DISPLAY_ORDER>
   </ROW>
   <ROW num="15">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <RESPONSIBILITY_ID>21540</RESPONSIBILITY_ID>
      <RESPONSIBILITY_NAME>US Super HRMS Manager(BG =&gt; Vision Corporation)</RESPONSIBILITY_NAME>
      <REPORT_ID>344</REPORT_ID>
      <REPORT_NAME>Application Analysis Age Analysis</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3060</PARAMETER_ID>
      <PARAMETER_NAME>Vacancy Name</PARAMETER_NAME>
      <LOV_ID>183</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>3</DISPLAY_ORDER>
   </ROW>
   <ROW num="16">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <REPORT_ID>344</REPORT_ID>
      <REPORT_NAME>Application Analysis Age Analysis</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3060</PARAMETER_ID>
      <PARAMETER_NAME>Vacancy Name</PARAMETER_NAME>
      <LOV_ID>183</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>3</DISPLAY_ORDER>
   </ROW>
   <ROW num="17">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <RESPONSIBILITY_ID>21540</RESPONSIBILITY_ID>
      <RESPONSIBILITY_NAME>US Super HRMS Manager(BG =&gt; Vision Corporation)</RESPONSIBILITY_NAME>
      <REPORT_ID>344</REPORT_ID>
      <REPORT_NAME>Application Analysis Age Analysis</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3058</PARAMETER_ID>
      <PARAMETER_NAME>Business Group Name</PARAMETER_NAME>
      <LOV_ID>153</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>4</DISPLAY_ORDER>
   </ROW>
   <ROW num="18">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <REPORT_ID>344</REPORT_ID>
      <REPORT_NAME>Application Analysis Age Analysis</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3058</PARAMETER_ID>
      <PARAMETER_NAME>Business Group Name</PARAMETER_NAME>
      <LOV_ID>153</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>4</DISPLAY_ORDER>
   </ROW>
   <ROW num="19">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <RESPONSIBILITY_ID>21540</RESPONSIBILITY_ID>
      <RESPONSIBILITY_NAME>US Super HRMS Manager(BG =&gt; Vision Corporation)</RESPONSIBILITY_NAME>
      <REPORT_ID>345</REPORT_ID>
      <REPORT_NAME>Application Analysis Applicant Statuses</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3065</PARAMETER_ID>
      <PARAMETER_NAME>Recruiter Name</PARAMETER_NAME>
      <LOV_ID>195</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>1</DISPLAY_ORDER>
   </ROW>
   <ROW num="20">
      <APPLICATION_ID>80000</APPLICATION_ID>
      <EIS_RESP_NAME>XXEIS iRecruitment Reports</EIS_RESP_NAME>
      <REPORT_ID>345</REPORT_ID>
      <REPORT_NAME>Application Analysis Applicant Statuses</REPORT_NAME>
      <CATEGORY_ID>45</CATEGORY_ID>
      <CATEGORY_NAME>Analysis Reports</CATEGORY_NAME>
      <PARAMETER_ID>3065</PARAMETER_ID>
      <PARAMETER_NAME>Recruiter Name</PARAMETER_NAME>
      <LOV_ID>195</LOV_ID>
      <DATA_TYPE>VARCHAR2</DATA_TYPE>
      <REQUIRED_FLAG>N</REQUIRED_FLAG>
      <DISPLAY_ORDER>1</DISPLAY_ORDER>
   </ROW>
   </ROWSET>
 
 
Destination sample xml is:
 
<?xml version = '1.0' encoding="UTF-8" ?>
<eXpressReporting>
   <module id="101" name="XXEIS General Ledger Reports">
      <responsibilty id="20434" name="General Ledger Super User(SOB => Vision Operations (USA))">
	    <category id="2" name="Applicant report">
         <report id="373" name="Account Analysis - (180 Char) Report">
            <parameters>
               <parameter id="4751">
                  <parameter_name>Type</parameter_name>
                  <lov_id>427</lov_id>
                  <data_type>VARCHAR2</data_type>
                  <required_flag>Y</required_flag>
               </parameter>
               <parameter id="4752">
                  <parameter_name>Currency</parameter_name>
                  <lov_id>428</lov_id>
                  <data_type>VARCHAR2</data_type>
                  <required_flag>Y</required_flag>
               </parameter>
               <parameter id="4756">
                  <parameter_name>Balance Type</parameter_name>
                  <lov_id>430</lov_id>
                  <data_type>VARCHAR2</data_type>
                  <required_flag>Y</required_flag>
               </parameter>
               <parameter id="4753">
                  <parameter_name>Starting Period</parameter_name>
                  <lov_id>209</lov_id>
                  <data_type>VARCHAR2</data_type>
                  <required_flag>Y</required_flag>
               </parameter>
               <parameter id="4754">
                  <parameter_name>Ending Period</parameter_name>
                  <lov_id>209</lov_id>
                  <data_type>VARCHAR2</data_type>
                  <required_flag>Y</required_flag>
               </parameter>
               <parameter id="4755">
                  <parameter_name>GL Account</parameter_name>
                  <lov_id>429</lov_id>
                  <data_type>VARCHAR2</data_type>
                  <required_flag>Y</required_flag>
               </parameter>
            </parameters>
         </report>
</responsibilty>
   </module>
</eXpressReporting>
 
 
XSL I am using is:
 
<?xml version="1.0" encoding="UTF-8"?>
    <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
        <xsl:output  method="xml" encoding="iso-8859-1" indent="yes" />
        <xsl:key name="application" match="ROW" use="APPLICATION_ID"/>
        <xsl:key name="responsibility" match="ROW" use="concat(APPLICATION_ID,RESPONSIBILITY_ID)"/>
        <xsl:key name="category" match="ROW" use="concat(APPLICATION_ID,RESPONSIBILITY_ID,CATEGORY_ID)"/>
        <xsl:key name="report" match="ROW" use="concat(APPLICATION_ID,RESPONSIBILITY_ID,CATEGORY_ID,REPORT_ID)"/>
        <xsl:template match="ROWSET">
    	<eXpressReporting>
                <xsl:for-each select="ROW[generate-id() = generate-id(key('application', APPLICATION_ID)[1])]">
                	<module id="{APPLICATION_ID}" name="{EIS_RESP_NAME}">	
    		<xsl:variable name="moduleid" select="APPLICATION_ID"/>		
    		<xsl:for-each select="../ROW[generate-id() = generate-id(key('responsibility', concat($moduleid,RESPONSIBILITY_ID))[1])]">
    		   <responsibility id="{RESPONSIBILITY_ID}" name="{RESPONSIBILITY_NAME}">
    		      <xsl:variable name="respid" select="RESPONSIBILITY_ID"/>	
    		<xsl:for-each select="../ROW[generate-id() = generate-id(key('category', concat($moduleid,$respid,CATEGORY_ID))[1])]">
    		   <category id="{CATEGORY_ID}" name="{CATEGORY_NAME}">
    		      <xsl:variable name="categoryid" select="CATEGORY_ID"/>	    		      
                          <xsl:for-each select="../ROW[generate-id() = generate-id(key('report', concat($moduleid,$respid,$categoryid,REPORT_ID))[1])]">
    			<report id="{REPORT_ID}" name="{REPORT_NAME}">	
                        <parameters>		
           			    <xsl:for-each select="key('report', concat($moduleid,$respid,REPORT_ID))">
    			        <xsl:sort select="DISPLAY_ORDER" />      			
    				   <parameter id="{PARAMETER_ID}">
    				      <parameter_name>  <xsl:value-of select="PARAMETER_NAME" /> </parameter_name>
    				      <lov_id>  <xsl:value-of select="LOV_ID" /> </lov_id>
    				      <data_type> <xsl:value-of select="DATA_TYPE" /> </data_type>
    				      <required_flag> <xsl:value-of select="REQUIRED_FLAG" /> </required_flag>
    				   </parameter>	    			
    			    </xsl:for-each>	
                    </parameters>		
    			</report>
    		      </xsl:for-each>
                </category>	
    		    </xsl:for-each>    		      
    		   </responsibility>	
    		</xsl:for-each>
                    </module>
                </xsl:for-each>
    	</eXpressReporting>
        </xsl:template>
    </xsl:stylesheet>
 
sample output xml what I am getting now with this xsl is:
 
<?xml version="1.0" encoding="iso-8859-1"?>
<eXpressReporting>
	<module id="85000" name="XXEIS Reporting Administrator">
		<responsibility id="" name="">
			<category id="119" name="Admin Test Category">
				<report id="653" name="Test Report">
					<parameters/>
				</report>
			</category>
		</responsibility>
	</module>
	<module id="80000" name="XXEIS iRecruitment Reports">
		<responsibility id="21540" name="US Super HRMS Manager(BG =&gt; Vision Corporation)">
			<category id="45" name="Analysis Reports">
				<report id="343" name="Application Analysis - Vacancy Summary">
					<parameters/>
				</report>
				<report id="344" name="Application Analysis Age Analysis">
					<parameters/>
				</report>
				<report id="345" name="Application Analysis Applicant Statuses">
					<parameters/>
				</report>
			</category>
		</responsibility>
		<responsibility id="" name="">
			<category id="45" name="Analysis Reports">
				<report id="343" name="Application Analysis - Vacancy Summary">
					<parameters/>
				</report>
				<report id="344" name="Application Analysis Age Analysis">
					<parameters/>
				</report>
				<report id="345" name="Application Analysis Applicant Statuses">
					<parameters/>
				</report>
			</category>
		</responsibility>
	</module>
</eXpressReporting>
[+][-]10/30/09 02:54 AM, ID: 25701418Accepted Solution

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

About this solution

Zones: Extensible Stylesheet Language Transformation (XSLT), Extensible Markup Language (XML)
Sign Up Now!
Solution Provided By: ramadevimandala
Participating Experts: 0
Solution Grade: A
 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625