Grouping with the same field more than once - not working - help please!

Question

Grouping with the same field more than once - not working - help please!

shiv179

SSC Rookie

Points: 32
More actions
December 18, 2008 at 4:19 am

#204205

I have an excess field in my report. I use a table.
I want to group it like this:
excess < 3%
============
===========
===========
excess >= 3%
============
=============
=============
So basically I would need 2 groups.
Created first group, grouped on Fields!Excess.Value, then filtered by the expression Fields!Excess.Value < CDec(3).
That worked just fine.
Now if I repeat but changing the expression, nothing shows.
I have tried everything I can!
I have googled, I haven't come across any article about grouping with the same field more than once.
Any help is greatly appreciated!!
Thanks!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

shiv179 SSC Rookie Points: 32 More actions · Answer 1

oraculum (12/18/2008)
When you say group - you mean in the tab called 'Data' under the section 'Category Groups' ?
If so then really these groups are in a hierarchy - so as you said the 1st one works but 2nd doesn't - this is because when you add the 2nd there is no data to filter as its has already been filtered in the first section as <3.
You perhaps need to perform this type of filter in the sql query so that you resultant dataset then contains the value for 3 in seperate value which can then be placed into the same chart or graph.

Thanks for the reply.

I right click on the table, and choose Insert Group.

Under the General tab I group on Fields!Excess.Value.

Then under the Filters tab I have the expression Fields!Excess.Value < CDec(3).

I am filtering the group only, not the entire data!

What happens to the data that passes thru the filter and how do I retrieve it??

There must be a way!!

I already have a higher level grouping, by Supplier.

So:

supplier

======

excess < 3%

=========

========

excess >= 3%

========

I hope you understand what I am trying to say.

Thanks a lot!!

laubenth Mr or Mrs. 500 Points: 588 More actions · Answer 2

shiv179 (12/18/2008)
I have an excess field in my report. I use a table.
I want to group it like this:
excess < 3%
============
===========
===========
excess >= 3%
============
=============
=============
So basically I would need 2 groups.
Created first group, grouped on Fields!Excess.Value, then filtered by the expression Fields!Excess.Value < CDec(3).
That worked just fine.
Now if I repeat but changing the expression, nothing shows.
I have tried everything I can!
I have googled, I haven't come across any article about grouping with the same field more than once.
Any help is greatly appreciated!!
Thanks!!

I think what you want is something I do in crystal all the time and I think I did it once in RS.

I have a list but I don't put something in the filter tab, I put something in the Sorting tab. I create an expression based on the value you want to group on, so something like this. "=iif(Fields!Excess.Value < CDec(3), 1, 2)" This would give you 2 groups one with less then 3 and then the rest where the less the 3 comes first (1 before 2) You could nest more iif to get you more groups. You might have to put in another group/list/table to sort the data inside of the group. So basically you are grouping on an expression which is based on the value.

Hope this helps.

shiv179 SSC Rookie Points: 32 More actions · Answer 3

Thanks Grasshopper,

I actually already found the solution.

What I did is pretty much the same as what you have outlined.

I created a group, and grouped on the following expression:

=iif(Fields!Excess.Value < CDec(3),0,1)

Thanks anyway 😎