Href for drilling down of a Single table
<p>Hi All,</p>
<p> </p>
<p>I have a order table which gives Order number,Order date,Status and comments and is grouped by status.I need to show comments column like running numbers,on click of href i need to show comments.Please let me know how i can achieve this.I dont want to use another rpt file showing only for comments.</p>
<p> </p>
<p>EX:</p>
ORDERNUMBER
ORDERDATE
REQUIREDDATE
SHIPPEDDATE
STATUS
COMMENTS
10167
Oct 23, 2011
Oct 30, 2011
Cancelled
1
10179
Nov 11, 2011
Nov 17, 2011
Nov 13, 2011
Cancelled
10248
May 7, 2012
May 14, 2012
Cancelled
2
10253
Jun 1, 2012
Jun 9, 2012
Jun 2, 2012
Cancelled
3
10260
Jun 16, 2012
Jun 22, 2012
Cancelled
10262
Jun 24, 2012
Jul 1, 2012
Cancelled
4
1
Shipped
2
Check on availability.
Shipped
3
Shipped
4
Shipped
10420
May 29, 2013
Jun 7, 2013
In Process
1
10421
May 29, 2013
Jun 6, 2013
In Process
2
10422
May 30, 2013
Jun 11, 2013
In Process
3
10423
May 30, 2013
Jun 5, 2013
In Process
4
10424
May 31, 2013
Jun 8, 2013
In Process
5
10425
May 31, 2013
Jun 7, 2013
In Process
1
Custom shipping instructions were sent to warehouse
In Process
2
In Process
3
In Process
4
In Process
5
In Process
<p> </p>
<p>Please find the attached rpt file.</p>
<p> </p>
<p> </p>
<p> </p>
<p>Thank you,</p>
<p>Kavitha</p>