Add Buttons on Dashboard
Buttons on Dashboards can be used to take certain actions. InfoCaptor dashboard buttons can be set to take a database action or a non-database action.
In case of a database action you can call a database stored procedure
Goto Menu Create -> Parameter
Leave the Parameter Name blank (Optionally- If you need have a title name for the button then you may enter it)
The Display Column property text is displayed on the button.
Select the Datatype as ‘BLET’ from the drop down list.
Finally add the database stored procedure call in the text editor. In the below example we are making a call to an Oracle Package procedure. In the call to the stored procedure you can pass references to other parameters.
How to make non-database calls or actions
In order to call external programs or launch specific URLs you need to follow the above steps except for the Text Area just enter NULL
Select DataType =’BLET’
Select ‘Run Dynamic Java Script’ = ‘Y’
and then click on the Dynamic Java Code
Enter the following command to launch a URL
[Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler " + http://www.infocaptor.com/how_to_build_dashboard_using_excel.pdf);]