>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
Found this, not certain if this is a solution
Re: Is there a limit to no. of fields CREATE REPORT can hand Thread #
700223 Message #
700230
If it's not broken, fix it until it is.
My Blog