Going crazy trying to figure out how to get a simple mysql permit into CR.

I need to have just a count of how many times a field is equal to "whatever".

So in my report it has a text box: How Many Instances and then a field that has the qurey behind it and shows XXX whatever the number is.

Like: Select count from database.customer where state = california

Can someone help me out here?

Thanks for your help lockwelle, I appreciate it.

This got me a little further, and I realize that I need this done a little differently.

To try to make my question a little better look at it like this:

My Table:

Server / User / DateTime / Action

Row 1: miami1 / carlosj / 05-04-2010 11:23:31 / Exported source
Row 2: miami1 / davidc / 05-04-2010 11:24:41 / Ran DB import
Row 3: denver7/ carlosj / 05-04-2010 11:27:29 / Exported source

I need to have all of the servers grouped in my report.

Under each grouping I need several totals for exampe: total count of action where action = Exported source

But I don't want to write a separate query for each total for each server.

Can CR know that I am on the group miami and pull the count for action where = exported source?

Thanks again for your expert help

WOW, that's probably too deep for me to understand, I will try though.

So, my server data should be grouped, I don't think it is interleaved, very simple table with what I thought would be a simple report.

So I should just reset this variable for each group.

Any more tips?

to reset a variable, it's something like: