Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1440
  • Last Modified:

Group Sort Top N in Crystal Reports 2008 (12.2.0.290)

I am trying to use a parameter to set the N value in Top N formula in the group sort expert. I set the N value to 10 and then in the formula was trying to just have a numeric parameter but that wasn't changing the N from 10 so i just entered a simple formula (if 1=1 then 25 else 35) to test if i could get the Top 25, but i still get only the Top 10. What am i missing?
0
Joseph Strong
Asked:
Joseph Strong
  • 4
  • 3
1 Solution
 
mlmccCommented:
Are you refreshing the reports and choosing new parameters or is this with saved data?

mlmcc
0
 
Joseph StrongIT ManagerAuthor Commented:
i think i know my answer. I am creating the report using Crystal 2008, however the report is being run though a web app that is using Crystal 9 report engine, which i believe does not include the formula function for the group sort so it's not using it.
0
 
mlmccCommented:
CR9 is different and may be missing some features but I think that feature is there.

mlmcc
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
James0628Commented:
Where do you enter that Top N formula?  I've got CR 10 and I have a place to enter N, but I don't see anything about a formula.  I think that was added after CR 10.  I'm attaching a screenshot.

 James

top-N-window.JPG
0
 
mlmccCommented:
It was added with CR XI

mlmcc Group Sort Expert
0
 
Joseph StrongIT ManagerAuthor Commented:
i have the last screen shot in my Crystal Designer, but the report is actually run through a web app that is using crystal 9 for it run time and thats where i think the feature is being removed.
0
 
mlmccCommented:
Probably.

In that case, you probably can't do what you want.

I did a report where the value was passed in and I simply counted the records in a group and suppressed them after N was reached.

mlmcc
0
 
Joseph StrongIT ManagerAuthor Commented:
The way i have designed the report it was easier to have the script that calls the report select between 2 different Crystal reprots to push the data to, one with a Top 10 and the other that has all the records.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now