- How to Export a Layout Table Report with Live Forumlas to Excel
/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
/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
/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 User-Defined Scalar Functions in Oracle and SQL Server
/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 Chart Events to Add Effects
/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 SQL Data in a Google Chart
/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 Set the Height of a Container to the Screen Height
/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.
- How to Add Server-side Event Handlers to the Web2Cal Calendar to Respond to Event Changes
/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 Determine the current Alpha Anywhere server version
/pages/HowTo/Application_Server/How to determine the current Alpha Anywhere server version.xml
In an A5W page, insert this code to display the version:
- How to Capture and Restore the List's Scroll Position
/pages/HowTo/List Control/Capture and Restore Scoll Position.xml
Refreshing data in a list can sometimes cause it also reset it's scroll position. You can restore the List's scroll position by capturing the position before refreshing or performing some operation on the List and restore the scroll position after the operation completes with a few lines of code.