Grouping by specified order question

[Former Member]

I have CRXI. I have a group by specified order setup discarding others. In the page header I want to count all data, including the items I have discarded that don't meet the group parameters without displaying them. How would I accomplish this.

Ralph

[Former Member · Accepted solution]

Try using SQL Expression like this

(select count(`Customer`.`Country`) from `Customer`)

Regards,

Raghavendra

[Former Member · Accepted solution]

That works great, however I forgot that I also need it to be able to select that date based on a date paremeter range. What commands would I use for a WHERE clause in the SQL expression statement to put that in. Thanks

[Former Member · Accepted solution]

You can statically add the where clause like this

(select count(`Customer`.`Country`) from `Customer` where `Customer`.`Country`='USA')

but unfortunately SQL Expressions doesn't support formula fields and parameter fields in it.

Regards,

Raghavendra

[former_member260594]

You could put the others together with the name others and then use Group Selection where group name <> "others". This would still allow you to summarize on all the data but only the specified groups would appear.