Report on button (printit?)

[martbarr]

Hi I need some one-off buttons on my index page that run specific reports.

Am testing using JPG01 sample report in samplenufinancial

JPG01 runs fine from "run activity" obviously,
but when I make a button object and use printIt('JPG01') on dble click then it runs the sql at the end of this post and fails.
So is there another way of firing a specific report from an index page button please?
(I know I can openform run to get a button with run activities - but don't want all users running all reports)
Martin

#CREATE TABLE a___nu1509fbf903765d___ SELECT NOW() as timestamp , "" AS accessLevelButton , "" AS AddActivities , "" AS AddLists , "" AS Code Library , "" AS Debugbt , "" AS FMAccountList , "" AS FMaddbatchbutton , "" AS FMcategoryButton , "" AS FMcustomergroupsButton , "" AS FMcustomersButton , "" AS FMeditbatchbutton , "" AS FMemployeebutton , "" AS FMfinancialsetting , "" AS FMGeneralLedger , "" AS FMinvoicebutton , "" AS FMpaymentbutton , "" AS FMPaymentforSupplier , "" AS FMProductButton , "" AS FMproductgroupbutton , "" AS FMpurchaseorder , "" AS FMreceipts , "" AS FMreceipttypes , "" AS FMReceiveRefunds , "" AS FMrefundbutton , "" AS FMreversecreditclearbutton , "" AS FMreversepaymentbutton , "" AS FMReversePaymentsMade , "" AS FMsupplierbutton , "" AS FMsuppliergroupbutton , "" AS FormsButton , "" AS fwiz , "-1" AS id , "" AS Inage , "" AS ObjectsButton , "-1" AS recordID , "" AS reportbutton , "Graph Examples" AS ReportTitle , "" AS RunActivity , "" AS Setup , "" AS sfwiz , "" AS ssddsd , "" AS stock , "" AS StyleButton , "" AS transbt , "" AS UserGroups , "" AS Users , ___nu1509fbf903765d___.* FROM ___nu1509fbf903765d___

[admin]

Martin,

Try changing the name of Object Code Library to CodeLibrary

nuBuilder makes a field for every Object on the open Edit Form, so it needs valid field names.

Steven