VB 6 reports.

[toon10]

Hi

I have had to convert a system from Access to VB6. The whole system works apart from the reports. I had two reports based on queries in Access. I have converted the queries into data environment commands and they seem fine. I have reproduced the reports as best as possible given the limitations of the report functionality in VB6.

When I run the reports from my application I get the following error message. “The report width is greater than the page width.” The report should fit nicely into a landscape setting but I can’t see one anywhere and it doesn’t seem to make a difference if I increase the page width setting.

One of my other reports produces the following error. “Report sections do not match data source.” I have matched the reports to the Access ones but I just can’t get any output. Any ideas?

Thanks
Andrew

 

[Forri]

You should install the Service Pack 3 (make it 5 immediately). This service pack has a property which will enable the report to be viewed as landscape.

In the report initialization event write:

me.orientation = landscape (check enumeration for this)

This should fix it!

Also the report has a limit on the far ends i think its 11" or 10 " for a lanscape report! Check it out!

Nick