topCount

[JPCogAdmin]

Hi,

I was wondering if any of you know how to do a top 5 listing. I just can't seem to get it. I retrieved 3 fields from the Go Sales and put in a calculation to use the topCount function and it won't work.

Does someone on this list know the steps to get a top 5 records from a subject query using Report Studio 8 ?

-J

 

[JPCogAdmin]

Ok,

Just figured it out.

-J

 

[UcfMike]

What was your solution?

 

[JPCogAdmin]

Hi UcfMike,

I almost read your name as UFCMIKE.
;-)
All I needed to do was add the expression topCount(expresion). You do that in the properties of the query item, in the expression field. Try it, it should work like it did on mine.

-J