EOL (calc) text data export - sdf

[jgould4857]

Is there a way in SQL 10 to force a carriage return (ie EOL command) on a fixed width text export? ____We^re exporting (SDF) a group line but need a header (title) and a footer (summary) line. Adding a conditional count print statement on the first and last group line takes care of this, but we have to break the bandline after the first and before the last record. ____Old DOS R&R had the ability to create an EOL calc field with a (" "). Is there anything similar in SQL? __

[kfleming]

Can you add a blank line using the same logic that you currently use for the footer?____Kathleen__R&R Support

[jgould4857]

Kathleen,__I can add a blank line using the same logic, but it (blank line) does not export. Good idea though. ____When I view the original report, everything appears the way it should (header record, detail, footer record - all from the same group line). Only when exporting to an SDF does the header and footer records appear on the same line as the first and last record. Any ideas about adding a CR or EOL statement?____Thanks for your help.