Why we selected Alpha Anywhere over Crystal Reports

By Nicholas Wieland –Alpha Anywhere Developer and Accounting System Expert

As a software solution provider, our clients need us to stay competitive and cost effective. This meant constantly reviewing the set of tools we use to provide our service. Because we specialize in Accounting, flexible and comprehensive reporting were of primary concern.

For many years our primary tools have been Crystal Reports (reporting), Dotnetnuke (website), Visual Basic (Windows Mobile Solutions) and our customers use QuickBooks Pro/Enterprise, Mas90, Navision, Macola, Exact and many other accounting packages.

In the Fall of 2016 a client asked us to build a completely web-based solution that included complex reporting. We needed to find a new software development tool – one that would let us develop the application in a single environment and do it faster than we knew our current tools would let us.

About Alpha Anywhere

I found Alpha Anywhere and read reviews on it from sites like Tec…

So You're Thinking About Using Alpha Anywhere

by: Steve Workings, Alpha Five Developer and Instructor
This little guide is for you if you're a person or company in need of a good database system. You're looking around, trying to decide which database to use. It's a big commitment after all. You'll invest a great deal of time, money and your future in that critical piece of software.

You heard about Alpha Anywhere (and maybe wonder why you haven't heard of it before). You obviously discovered this web site. How can you learn more about Alpha Anywhere?

First, I'm going to give you a short list of reasons why Alpha Anywhere should be your choice. And second, I'm going to recommend other things you can do to learn more.

Why Alpha Anywhere Smokes the Competition

- The advertising is true: You can accomplish more with Alpha Anywhere in a shorter period of time than any other database product.

- Alpha Anywhere has genies for the non-programmer, and powerful programming capabilities fo…

How To Create Filtered, Ordered DropDownBox Lists

Author: Steve Workings

Have you used the DropdownBox control for any of your fields yet? If you haven't, then you should consider trying it where appropriate. If you have, you may have run into a limitation in the point & click interface. The limitation is that there's no way to filter or order the records using the genies. Let's see what you can do about this.
Image 1 shows a typical developer's first attempt to populate a DropDown list using a SQL data source. But if you need to filter (and to a lesser degree order) your list based on variable values or other considerations, you'll quickly run out of road.
The solution lies in setting the radio button at the top of the dialog to "Variable" as shown in Image 2. You'll also note that Image 2 shows that the list will be derived from a variable named vUser_List. 
The remaining question then, is how to create vUser_List. 
If you look through the Grid events, you'll find the OnGridInitialize event, w…