Memo Fields with Multiple Entries

[LDickenson]

Hi

I am doing a report that has a Memo field for people to collate comments, I have written a report that brings all the comments ever added and I want to export this into excel which is fine, the only problem is people now want to use excel add a filter to search on a company name and it bring up all those notes, as the notes are on seperate lines this then goes into a seperate cell when export, is there anything I can do in the formatting to make this export as one cell.

Thanks

 

[IanWaterman]

When exporting the Memo field must be have the can grow turned off.

You might want to duplicate row holding your data and use a parameter called Export with values Y or N.

Use this to suppress the two rows as required, the row for export can have memo field with can grow turned off.

Ian

 

[LDickenson]

Hi Ian

I turned the 'can grow' off, this didn't make any difference.

I don't understand the second solution you recommended.


Please help

Thanks

 

[IanWaterman]

YOur data as shown in Preview can only be one line wide, any other fields which are gowing and cause returns will introduce new rows when exporting to excel.

My other suggestion was for you to have two display versions, one where users just want to view report on screen and do not want to export to excel.

If you data is displayed in details, then split that section into two. Copie all fileds into the new section and turn off can grow on all fields.

Create a parameter called Export and set two default values of Y and N

Then in section section suppression of the top details section enter in the supression formula

{?Export} = 'Y' and in the lower section which contains the fields with can grow turned off.

{?Export} = 'N'

Ian

 

[LDickenson]

Ian

All the data is in the group header, I had to do it this way to get round several issues, also I have sub-reports in the group header of which the comments is one.



Thanks

 

[IanWaterman]

Does not matter where the data is details of header principle is the same.

Just make sure that the subreport can not grow. You can add the subreport in twice it will on execute in the unsuppressed section.

Ian