Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2012-06-14 : 02:25:58
|
| Hi All,I am facing problem with carriage return scenarios. I am generating report like Last_Date | Notes01/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 belowLast_Date | Notes01/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.