Crystal Xcelsius – Filtered Rows From A Filter Component

This is really obvious with hindsight but it took me ages before “the penny dropped”.
Most of the time I find myself using the “Filtered Rows” option on my selectors.
The main selector that I want to use is the “Filter”, but strangely this does not have the option of filtered rows.
What I have resorted to doing in the past is to use multiple selectors:
A date drop down list box filters the rows from “Raw Data” sheet to the “Monthly” sheet.
A product drop down list box filters the rows from the “Monthly” sheet to the “MonthlyProducts” sheet.
A customer drop down list box filters the rows from the “MonthlyProducts” sheet to the “MonthlyProductsCustomers” sheet which now lists all of the sales made for that combination.
The filter component could do that, but this component assumes that there will only be a single row in the output. As soon as you have multiple rows in your result set then you can’t use the filter component.
Ahhh, but you can with a little lateral thinking; that’s what Xcelsius is all about.
Continue reading

Pedigree Dogs Exposed


I caught the middle of a program last week on BBC1 : Pedigree Dogs Exposed.
This program was highlighting the in-breeding and lack of genetic screening that is in place in the Kennel Club.
I did not get to see the whole program, I am downloading it using the BBC iPlayer to watch it in full.
Continue reading

Now THAT is a competition prize !

I saw this poster at work today.

Copy1 of DSCN0185

Just a glance at it and I started sniggering.

There was something about the prizes that tickled my fancy.

Copy2 of DSCN0185

Continue reading

Last updated by at .