Conditional Sub-Total on Report

Most of Foxite forum members are aware that I have been blogging in Weblogs way before I decided to blog here in blogspot.  However, I have a lot of new visitors here who might not be aware of that so I decided to repost this knowing it may also help others.

This trick is on removing sub-total when there is only one item on native VFP report.  Take a look at the image I grabbed from said Weblogs posting below:

The trick lies with a variable.  Create a variable, name it to whatever you like (mine is overall), with the following settings:

value to store = 0
initial value = 0

reset value based on a group

calculation type = count

then of course, tick the release after report checkbox.

Now, on anything that is in the group footer, double-click, click print when tab, tick remove if blank checkbox, then place this condition on print only when expression is true textbox: overall > 1

and that is it.  enjoy your report with conditional sub-total printing!

Cheers!

ssUltimate/ssClasses Sample Video

For the first time, I decided to show by way of video how one of my apps look like.  This one is a very small app I called Easy ID Creator which is what I develop to be used here on our end in creating  IDs on-the-ply.  I plan to later  enhance this to be used in Daily Time Recording by scanning the IDs (that is why the barcode) and thereby calculating the employee time; to replace the old Bundy Clock.

I would like to show how it really looks like but I am forced to convert said video from .avi to .wmv format which has lower resolution as uploading of the .avi takes time due to size.  Here though is how it looks near, near because this is likewise a jpeg resized image so it still do not actually show the real appearance.

Dynamic Detailed Summary in Report?

Need something like this? At the bottom of the report, a detailed summary based on the entries on the report? 

Surprisingly, this is very easy to do if you know the knobs to twist.   The process and tricks involved is in creating a cursor for your report, generating another cursor out of the first cursor to hold the summary, and finally seeding those back to the original cursor.

Another is by employing grouping to break presentation of the data.  Study the sample data:

Sandstorm's Quick Search Tool

Here is another tool to help you search for files in your unit.  You can search multiple types by using asterisk (*) and you can search on multiple locations by either typing the paths straight in the box for Target Folder and/or clicking on the dotted button on the right.

This uses filer.dll that is shipped along with VFP (Home(6)).  For you to be able to use said dll on other machines though, you need to register it first using an admin account.

regsvr32 filer.dll

And here are the codes:

Grid Showing Fonts' Name and Appearance

Here is another one that again comes from reading a need of a member inside foxite forum which is to show the list of fonts on the current computer unit in any object possible with an added minor twist, i.e., that aside from the name Arial, the font name should be displayed as well on how the font looks.

ssClasses issue on cCleaner

A subscriber has been repeatedly requesting me for a major update on how ssClasses works just because one (or some) of his clients have cCleaner on their machines and said cCleaner is beating the crap out of ssClasses because most users are likewise ticking the temp folder to be among those it will clean.  And temp folder is where I decided to send images needed by ssClasses for two reasons:

1. It is "never" restricted to the current user
2. It is a place to store 'craps'.  You can think of the images of ssClasses as crap if you wish

But due to that constant cleaning done by users of cCleaner, then in some cases with the current design of the library, needed images for some of the classes like buttons, switches, etc.; might not appear properly on first run of your app.  Succeeding runs will have no problem.

Setting Focus to an Object via its TabIndex Value

MK has been repeatedly requesting from me if I can make ssOptSwitch totally loose focus and moves to the next control when user presses TAB and I said that unless someone showed me a way to do that via tabindex, then it can't be done.  No one showed me so it stays that way.

That default attitude of the class is not surprising considering ssOptSwitch actually is just a container comprised of several ssSwitch so it is just natural that when one switch looses focus via Enter or Tab keys, then the next switch based on tab index will receive it.  And I really cannot imagine yet how to do something like:

Thisform.Object(.tabindex).Setfocus

I was sitting in front of  my laptop Sunday afternoon as I am in the mood going through the minor bugs on Alpha 3.0 as mentioned by MK fixing those one by one until I came to his ssOptSwitch Tab request.  Suddenly I realized I have been saying all along the solution to that and that the above command can actually be translated into something like this: