- 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
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.