Changing the width of the report

[SchuhTL]

My company has a policy that does not allow web servers to map to printers. I have several reports that I have created which are very wide(they contain 30 plus fields). I thought if I mapped to a plotter printer from my desktop computer it would give me additonal width, which it did. I now have 40" to work with when designing the reports. The problem is when I try to move the report to the web server (which has no printers installed) the report get's cut off at 17". Why 17"? Does anyone no of a work around? These reports are used for exporting only. They don't have to look pretty of the web they just have to export to excel without having a bunch of blank columns and rows. Thanks in advance.

 

[jkurtz]

Not sure why you are not sending it straight to Excel if that is the final output needed.

You could do something in asp like:

Response.ContentType = "application/vnd.ms-excel"
<!-- code to create the recordset here -- >


<TABLE border=1 cellpadding=0 cellspacing=0>
<TR>
<!-- output header names -->
<% For i = 0 to rs.Fields.count - 1
Response.Write(&quot;<TD>&quot; & rs(i).Name & &quot;</TD>&quot
next%> </TR>
<!-- output data -->
<% do while not rs.EOF
Response.Write(&quot;<TR>&quot
For i = o to rs.Fields.count - 1
Response.Write(&quot;<TD valign=top>&quot; & rs(i) & &quot;</TD>&quot
Next
rs.MoveNext
loop


rs.Close
set rs = nothing
%>
</TABLE>

 

[SchuhTL]

I have thought about doing what you have suggested but the reports I created have a lot of grouping, supressing and formula's that are much easier/faster to create in Crystal vs ASP.