Crystal Reports Grayed out boxes

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Grayed out boxes

Author	Message
mcelwainj Newbie Joined: 18 Oct 2010 Location: United States Online Status: Offline Posts: 21	Topic: Grayed out boxes Posted: 30 Nov 2010 at 6:17am
	Any thoughts on why "Grouping on Server" and "select distinct records" are grayed out from the database dropdown? This is making my report hundreds of times bigger than it should be...works fine on other reports...
	-Jeremy
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 30 Nov 2010 at 6:34am
	are you using a different source data type? OLAP does not allow for it. Is the Use Indexes or Server for speed set to TRUE? This has to be set that way for the others to work.
	IP Logged

mcelwainj Newbie Joined: 18 Oct 2010 Location: United States Online Status: Offline Posts: 21	Posted: 30 Nov 2010 at 6:38am
	No, not an OLAP db. Use indexes or server is checked. Not sure what is going on...I have no luck lol
	-Jeremy
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 30 Nov 2010 at 6:56am
	Stored Proc source?
	IP Logged

mcelwainj Newbie Joined: 18 Oct 2010 Location: United States Online Status: Offline Posts: 21	Posted: 30 Nov 2010 at 6:58am
	No - its 100% ODBC. And if I start a new report they are not grayed out.
	-Jeremy
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 30 Nov 2010 at 7:03am
	from Online Help (vXI):Keep in mind that in order to perform the grouping on the server, your report must conform to the following conditions: The Perform Grouping on Server option (in the Options dialog box) is enabled. For more information, see Enabling Server-side processing. The report uses some form of grouping. The report is at least partially hidden (at the very least, the Details section must be hidden). Since the server will process those sections that are hidden, the greater the portion of the report that is visible, the greater the amount of processing that must take place on the client side. If the Details section is shown, server-side processing will not be possible. In some cases, formula fields must be processed on the client side. If grouping is based on a formula field, or if a formula is used in a summary field, then all the records must be transferred to the client side before the formula can be evaluated. This will increase the amount of time required to run the report. Therefore, you may want to use SQL expressions as an alternative to formulas. Note: Formulas used for record selection are an exception and can be pushed down to the server. For a report to be processed on the server, any running totals appearing in the report must be based on summary fields (since the data needed for the running totals will be pulled over to the client side). For a report to be processed on the server, the report must contain only summary fields of these types: Sum, Maximum, Minimum, Count. The report does not contain specified value grouping. Edited by DBlank - 30 Nov 2010 at 7:05am
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.