Page 1 of 1
EOL (calc) text data export - sdf
Posted: Tue Apr 13, 2004 12:17 pm
by 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? __
=> EOL (calc) text data export - sdf
Posted: Thu Apr 15, 2004 8:19 am
by kfleming
Can you add a blank line using the same logic that you currently use for the footer?____Kathleen__R&R Support
==> RE: EOL (calc) text data export
Posted: Thu Apr 15, 2004 10:06 am
by 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.