Facts about a country!

Well, I have constant visitors of my blog site but I believe most of you do not know one hidden feature here? Which is you can know some facts about your country or other countries as well. How is that then?

Grid Tricks#4- Clearer Search Results

Where is numbers 1, 2 & 3 Tricks?  We can simply treat #1 as the More Objects inside a Cell blog, #2 as the Various Images II blog and #3 as the Transparent Grid blog.

I decided to start showing some more tricks I do on my side using grids which I deem will be useful for others as well.  This is about making the search result clearer or more visible by highlighting the cell contents where a near match can be found.  If not, it is very tiring for the user's eyes to trace where exactly those near matches are.

Block Breaker Tool

I have been converting image files into HexBinary values, manually breaking those into acceptable blocks and enclosing those with TEXT... ENDTEXT, then finally embedding the codes within ssClasses.  The purpose of that is so I can make my library self-sustaining for its images need. 

I wanted the codes to be embedded inside because I want better control of the class and of course to minimize the unnecessary maintenance which will not be possible should I save those binary values inside a table or a text file; and ship those along with _ssclasses library.  Those outside files will be prone to content alteration and with binary values, a single character changed will mean inability to convert the images back properly later.

Not to mention that when I ship the library, I only wanted to ship these two files:

_ssclasses.vcx
_ssclasses.vct

and nothing else.

Transparent Grids - Now & Then

I have been wondering whether I can make my grid transparent and indeed I found a way.  However, said transparency can only be attained when there is no RecordSource and yes it suits me just fine because who, in his right mind, would want a transparent grid with data?  That is not only painful to the eyes but is likewise annoying, LOL!

Here is a sample how we can achive that:

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

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

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.