Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal XI Exporting w/ Groups

Status
Not open for further replies.

pungigis

Programmer
Dec 5, 2007
71
US
I have a report that I need to export as a TXT file, however I have it grouping on employer name, when I export it it has blank lines throughout, I have the group header and footer suppressed. Any ideas would be helpful as the end user need to be able to effectively import this into their program.

M00838211 M 12/03/1936 01/01/2009 01/01/2009

M00696165 F 06/16/1934 01/01/2009 01/01/2009
M00698889 M 09/15/1938 01/01/2009 01/01/2009

M01371369 F 03/30/1930 01/01/2009 01/01/2009
M01371349 M 03/10/1928 01/01/2009 01/31/2009


M00730237 F 06/05/1929 10/01/2008 12/31/2008
M00730237 F 06/05/1929 10/01/2008 12/31/2008
M00730237 F 06/05/1929 10/01/2008 12/31/2008

M01408375 M 08/06/1942 07/01/2008 07/01/2008

M01543436 M 01/19/1943 02/01/2008 06/30/2008
M01543436 M 01/19/1943 02/01/2008 06/30/2008
M01543436 M 01/19/1943 02/01/2008 06/30/2008
M01543436 M 01/19/1943 02/01/2008 06/30/2008
M01543436 M 01/19/1943 02/01/2008 06/30/2008

M01536946 F 04/15/1943 07/01/2008 12/31/2008
M01536946 F 04/15/1943 04/01/2008 06/30/2008
M01536946 F 04/15/1943 07/01/2008 12/31/2008
M01536946 F 04/15/1943 07/01/2008 12/31/2008
M01536946 F 04/15/1943 04/01/2008 06/30/2008
M01536946 F 04/15/1943 04/01/2008 06/30/2008
M01536946 F 04/15/1943 07/01/2008 12/31/2008
M01536946 F 04/15/1943 07/01/2008 12/31/2008
M01536946 F 04/15/1943 07/01/2008 12/31/2008

M01623624 F 09/24/1943 09/01/2008 09/01/2008
 
I'm surprised groups do that. But as a work-round, you could delete the group and get the same result using Report > Record Sort Expert.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top