How to Export a Layout Table Report with Live Forumlas to Excel
/documentation/pages/HowTo/Reports/Live Excel Forumlae in Layout Table Reports.xml
When exporting a Layout Table Report to Excel, calculated fields can be configured to export as Excel Formulas, instead of static data.
The Code Editor Control
/documentation/pages/Guides/Desktop/Xdialog/The Code Editor Control.xml
You can turn a standard text box control into a Xbasic Code Editor using the %L% formatting code. You should define column and row dimensions for the text box that are large enough to display a reasonable size code editor. Here is an example dialog with an embedded code editor.
How to Create a 'Conditional Object' in a Layout Table Report
/documentation/pages/HowTo/Reports/Conditional Objects in Layout Table Reports.xml
When creating Free-form reports, the Conditional Object control is used to dynamically display content. When designing Layout Table reports, the same functionality can be created with Static HTML.
How to Use Chart Events to Add Effects
/documentation/pages/HowTo/Charts/Adding Chart Effects with Events.xml
Pie slices can be "exploded" to add emphasis. Chart events can be used to dynamically explode pie slices in a Chart control when the chart is double-clicked. Events also be used to enhance a chart with effects such as popup help or additional details.
How to Use User-Defined Scalar Functions in Oracle and SQL Server
/documentation/pages/HowTo/Databases/Call User Defined Scalar Functions in SQL Server Oracle.xml
User-defined scalar functions in Oracle and SQL Server can be called from Alpha Anywhere.
How to Use SQL Data in a Google Chart
/documentation/pages/HowTo/Charts/Use SQL Data in Google Chart.xml
Data used to populate a Google Chart can be dynamically created from a SQL database.
How to Add Server-side Event Handlers to the Web2Cal Calendar to Respond to Event Changes
/documentation/pages/HowTo/Web Applications/Add serverside event handlers web2cal.xml
Event handlers can be added to the Web2Cal Calendar when an event is added, edited, moved, or deleted.
How to Set the Height of a Container to the Screen Height
/documentation/pages/HowTo/Styling Applications/Set height to screen height.xml
Learn how to set the height of a container to the full height of the screen.
Report Structure
/documentation/pages/Guides/Report/Report Structure/index.xml
A Report is divided into several sections with headers and footers. These sections are the Report, Detail, and Groups sections.
How to Use Output Arguments with Stored Procedures in Xbasic
/documentation/pages/HowTo/Databases/Use Output Arguments with Stored Procedures.xml
Most queries performed on a SQL database use Input arguments. However, Xbasic offers the ability to also use Output and InputOutput arguments return values from stored procedures.