|
under2811
Constraint Violating Yak Guru
India
347 Posts |
 Posted - 06/14/2012 : 02:25:58
|
Hi All,
I am facing problem with carriage return scenarios. I am generating report like
Last_Date | Notes
01/02/11 | Need to check the output and result
| into excel send back.
|
| Module still not prepared as it was taing time
| We will visit again on Monday.
|
|
----------------------------------------------------------------
01/03/11 | No data is available for this module. So we will wait for
| next session.
-----------------------------------------------------------------
01/05/11 | After that we would have a week to do our Work.
|
| Same notes found like above
| Module still not prepared as it was taing time
|
| We will visit again on Monday.
|
|
----------------------------------------------------------------
See above in some of the records i am getting extra line space at end of text box which i dont want. I am joining the same date "Notes" by using STUFF function in report data query. I need exact output like below
Last_Date | Notes
01/02/11 | Need to check the output and result
| into excel send back.
|
| Module still not prepared as it was taing time
| We will visit again on Monday.
----------------------------------------------------------------
01/03/11 | No data is available for this module. So we will wait for
| next session.
-----------------------------------------------------------------
01/05/11 | After that we would have a week to do our Work.
|
| Same notes found like above
| Module still not prepared as it was taing time
|
| We will visit again on Monday.
-----------------------------------------------------------------
The Notes column has RTF data.
T.I.A |
|
Need to remove extra line space for RTF data.
