Monday, May 21, 2012

A small Listbox appearance trick!

Another question has been raised by a foxite member inside the forum about a listbox not looking totally disabled when Enabled=.F. is set.  While the items in the listbox becomes disabled, the background color remains to be white.  And really it do not look cool that the rest of the other objects in a form like a textbox, when disabled changes color, while a listbox still remains white.

I have not seen this because I almost don't use Listboxes in favor of Grids. However, for those of you who may be wondering how this attitude can be circumnavigated, the trick lies between two properties:

a.  DisabledBackColor
b.  ItemBackColor

Thursday, May 17, 2012

Why Pivot Report? Why not Crosstab?

A pivot report is among the underrated and underused powerful feature of Excel.  So I want to give some lights onto its importance because this is really helpful, not only to the end users, but also to the developers.

What is a Pivot Table?

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, pivot-table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data. Pivot tables are also useful for quickly creating unweighted cross tabulations. The user sets up and changes the summary's structure by dragging and dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.

- wikipedia

Friday, May 11, 2012

More Objects inside a Grid Cell - Part II

May 7, 2014 Note:   If you are reading this, find an alternative way to achieve the same using DynamicFake method approach:  http://sandstorm36.blogspot.com/2014/05/more-objects-in-grid-cell-part-iii.html

=====

I thought I have explained things well on my first instructions of More Objects Inside a Cell blog because basically that is really it.  However, obviously I left some things which if readers looks closer to the Various Images in Grid Part II blog (BizCore Grid), they will see that the status of the vehicles change colors.  And I never deem it fit to expand the blog about More Objects because that blog is just a prelude of the Various Images I am planning to do next.  Plus I wanted readers to sort of experiment on their side how I was able to achieve that effect of status word changing colors based on conditions; if they like to achieve the same.  Like I said, all the basic ingredients are already on those two blogs.

But then, it appears that not everyone can see through the trick I used to achieve the same.  So based on a request of an ssClasses subscriber inside foxite forum, I decided to create one sample and post it here.  Now you will see how to achieve the same effect inside a cell of a grid with just a few tricks.