Hello One And All,

I have to some how create a custom report writer. I know it isn't a 1,2,3 thing, but the problem I have right now is the maximum number of fields a user can select is 11. If I take this into consideration and use the following code:

rptname = sys(2015)+".frx"
CREATE REPORT (JUSTSTEM(rptname)) FROM mycursor

this cuts off the last field because the report by default is being created as portrait and not landscape.

After the report is created, it's too late to open the FRX file as a table and adjust the first record so it is landscape.

is there any way to initially create a report as landscape with the CREATE REPORT FROM
command?

If not, How else could I do this?

Thanks,

Bob Gatto