There is no direct conversion from SQL*Report (RPT) given the inherent differences between the products. Some tips are:
Most main SELECT macros will turn into queries. You can save these to a file and Edit->Import the text into the query property sheet, remember to remove the INTO clause.
Any .ASK statements will become parameters.
Conditional logic will now turn into PL/SQL within the report.
Any .TELL statements will become SRW.MESSAGE.
After the queries are created let Reports Builder defaulting tool create a default layout.
Add any conditional logic needed and modify default layout if needed.
Another option might be to reverse engineer the RPT reports into Oracle Designer and generate Reports Builder reports in that manner.
Copyright © 1984, 2005, Oracle. All rights reserved.