I've designed a report using 'Revelation Reporter'. I am trying to run the report from a form using a button control with 'CLICK event- QuickEvent Option-Execute a procedure'. The procedure uses the following line of code to call the report: key=repository('EXECUTE','INVOICE*REPORT**INVOICETEST')

For reasons not obvious to me (but hopefully to someone who, unlike me, actually has an understanding of OI) the above line of code did not work. I've looked in the manuals but could not find any examples.

Also, how do I have the report just print or preview the record that is currently displayed in the form when the button control is clicked?

Thanks for your help.

Jim

Jim,

Something like this should do the trick:

declare function EntID
declare subroutine Repository, Set_Status
ReportID=EntID(@appid, "OIREPORT", "RDLAYOUT", "COLOR.RPT")
Set_Status(0)
Repository("EXECUTE", ReportID, "",1)  /*1 is for preview, 0 for print*/
return 0

The preview vs. print mode is commented above.

Regards,

-Stephen

View this thread on the forum...