[SOLVED]Blank First Row in SKIP-LINE

December 17, 2013, 10:54 AM

Michele Brooks

I am running a report and exporting it into Excel. I am doing a sort and a skip-line which is causing the first row to be blank. I need to get rid of the first blank row. Pasted below is a Car File example

 

-SET &ECHO = ALL;
TABLE FILE CAR
SUM DCOST
BY CAR
BY COUNTRY
BY MODEL
BY BODYTYPE
ON CAR RECOMPUTE
ON CAR SKIP-LINE
ON TABLE PCHOLD FORMAT EXL2K
END
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=OFF,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=8,
     SQUEEZE=ON,
$
ENDSTYLE
END

I could not use the SUBHEAD suggestion because it caused the macro template not to run in Excel. I created a duplicate sort field and did a noprint on it and color coded the duplicate field "white" so that the field value does not display in Excel. Thanks for all of the feedback.

This message has been edited. Last edited by: Michele Brooks,

December 17, 2013, 11:39 AM

Danny-SRL

  
TABLE FILE CAR
SUM DCOST
BY CAR
BY COUNTRY
BY MODEL
BY BODYTYPE
ON CAR RECOMPUTE
ON CAR SUBFOOT
" "
ON TABLE PCHOLD FORMAT EXL2K
END
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=OFF,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=8,
     SQUEEZE=ON,
$
ENDSTYLE
END

December 17, 2013, 12:09 PM

Prarie

There ya go.

December 17, 2013, 12:21 PM

Michele Brooks

quote:
ON TABLE SET PAGE NOLEAD

Thanks. That worked. I'm running the report using a macro template that was created prior to my temp assignment and when the report opens up in Excel, a dialog box pops up that says "Excel Name." This happens whenever I use subfoots, subheads or footings in the report request. I'll have to see if the customer does not mind the dialog box popping up when the report opens up in Excel. Once you click OK, the reports opens up. Thanks again.