Johnathon got a Credit and a Grading Award

One of my hobbies is Taekwondo – a martial art that originated in Korea but is now one of the most widely practiced martial arts in the world. I myself have been training long enough that I’m approaching my 2nd degree (black belt) grading later this year.

My son, Johnathon, does a form of Taekwondo designed specifically for young kids aged 4 – 7. He had a grading last week, to get his Little PUMA brown belt. Turns out he did well enough to get a Credit! Later the same day, I spoke to his instructor and she told me how surprised she was. The previous week, she had told Johnathon she wasn’t going to let him grade because he’d been so naughty in recent lessons! However, she let him grade, and he did a great job – in fact, he did such a great job, he also got the Grading Award as well as the Credit!

As I’ve only ever had one credit pass in my coloured belt gradings and I’ve never received a grading award, I was really, really proud of Johnathon for doing so well! His instructor told me how amazed she was at his performance at the grading, especially as she’d threatened to stop him from grading!

Well done, Johnathon!


Custom SQL in Crystal Reports XI

I’ve been ‘lucky’ enough to spend some time generating reports using Crystal Reports XI. One of the things I wanted to do was customise the SQL used to generate the report. Initially, it wasn’t obvious how to do this and Google couldn’t find any hints.

Happily, I found out how to customise the SQL used in Crystal Reports!

Open your report and open the Database Expert.

  1. Select “Current Connection”
  2. Click “Add Command”
  3. This will open a dialog – paste an SQL command into the left pane of the dialog.
  4. Click OK on the ‘command’ dialog.
  5. The source table for the report will now be the command, and the fields for the report will be based on the select query of the command.

It also appears that any parameters added to a report with an SQL command can be passed to the command – this can be done from the same dialog that the SQL command was added. However, I didn’t try this – I was happy enough to find out about the custom SQL! (Trust me, when you’re working on Crystal Reports, little victories are really important!) I’d recommend making sure that you’re query is right before you paste it into your report – debugging an SQL query is much easier than debugging a Crystal Report!