Paper size and orientation in CR9

[pranoy]

The requirement: Generate report in CR 9, export in PDF/Excel/Text format and view the output file
The Method used : Wrote a Activex dll which will generate and export the report. The report name, output format, paper size and orientation properties that are settable in the dll.

The Problem: When the dll is called from ASP, the paper size and orientation properties are being ignored where as when called from VB it works on the same PC. I'm working on Win XP and using the IIS on it for testing.

A part of the code is

Dim ReportApp As New CRAXDRT.Application
Dim ReportObject As CRAXDRT.Report

Set ReportObject = ReportApp.OpenReport(mReport, 1)
With ReportObject
With .ExportOptions
.DestinationType = crEDTDiskFile
.FormatType = mFileFormat 'crEFTPortableDocFormat
.DiskFileName = mOutputName
End With
.PaperSize = mPaperSize
.PaperOrientation = mPaperOrientation
.Export False
End With

[pranoy]

Nobody has a solution to this problem? Can anyone help out

[Pasvorto]

I have never tried using a DLL to do this. MAybe CR9 doesn't like variables. You could try something like

select mPaperSize
case <something>
.PaperSize = crPaperLegal
case something else
.PaperSize = crPaperdefault
...
end select

That's all I can think of.

[pranoy]

Thnx for atleast looking in the problem, but it did'nt work.
I think that this problem arises because of the fact that C uses the printer settings on the client PC but am at a loss at overcoming this problem.