When you give two or more grouping in your query , serial number make hell lot of problem in EXCEL output. To resolve this problem a simple xml code has to be inserted in the RTF design.
1. Insert your design and then copy paste any of your field to the front.
2. Then double click your first field and then change the code as
<xsl:value-of select="position()"/>
SNO
|
Date
|
Trans Type
|
Credit
|
F SNO
|
ACCOUNTED_DATE
|
CATEGORY
|
CREDIT E
|
3. Then you are done, here i will share my output format
| SNO | Date | Trans Type | Credit |
| 1 | 12-Jun-12 | Misc Receipts | 40 |
| 2 | 13-Jun-12 | Receiving | 20 |
| 3 | 13-Jun-12 | Receiving India | |
| 4 | 18-Jun-12 | Misc Receipts |
Thank You So much Mr. Shree
ReplyDeleteTHANK YOU SIR
ReplyDeletethankuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
ReplyDeleteI need serial no but in alphabetical order (a,b,c...z) kindly send solution.
ReplyDeleteIt's Impossible bachy !!
ReplyDeletegive me the code for sysdate
ReplyDeletehow to put a, d, c ,d instead of numbering
ReplyDeleteSNO Date Trans Type Credit
a 12-Jun-12 Misc Receipts 40
b 13-Jun-12 Receiving 20
c 13-Jun-12 Receiving India
d 18-Jun-12 Misc Receipts
Hi
ReplyDeleteWhenever I am applying parameter then the Sequence no are not appearing in proper order .
wOW,, NANDRI
ReplyDeleteThank you.
ReplyDeleteMy program is running with warning. When I view the log it says - Enter Password
ReplyDeleteThanks so much. Very helpful
ReplyDelete