Crystal Reports Warning regarding server-side group-by 3

[dwolff51]

I use Crystal Reports 10, and I'm creating all my reports using SQL Stored Procedures (SP). In some cases, I'm joining multiple SPs. When I do this, I get a warning:

"More than one . . stored procedure has been used. . . Make sure that no SQL Expression is added and no server-side group-by is performed".

In some cases, my SP DOES have a group-by in the SQL query. I do this to generate "max" dates for particular events for a LeadID. I then join this SP to another that pulls all my lead information.

The report seems to be working just fine; but I'm concerned by the warning. Does anyone have any assurances or warnings in this regard?

Thanks!

 

[lbass]

Since no one else has responded, I'll say that while I'm not sure, I think you are okay if you do not check "Perform grouping on server" in file->report options and if you do not add a SQL expression to the main report after the dataset is returned.

-LB

 

[Turkbear]

Hi,
From what I recall, LB is correct ( as usual) -
If your report ONLY uses the SPs for the data no issue should arise..If, however, you have another table linked and are also grouping on some field from that table it could degrade performance .

As others on this board have often stated:

"A test is worth a thousand theories"

Try it and see...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[dwolff51]

Thanks to lbass and turkbear. As I indicated, the report seems to be working fine; I've checked the data and I find no errors. Nevertheless, warnings make me uneasy.

To Turkbear . . while I'm NOT linking any tables directly in the report (I'm only linking SPs), I do (on occasion) have multiple SPs joined that use a group-by statement. Then, when I join the main SP to these group-by SPs, I just left-join the main to the subs. Seems to work just fine.

 

[crystalkiwibruce]

What you are doing is fine. What you are restricting is the ability to use the "Grouping on Server" option which can do some major performance improvements on reports that are designed that way.

But as you are already using a Stored Proc as your data source, you can build the efficiencies of Grouping by Server into the stored proc itselft.

There are so many conditions required to use the Grouping by Server, that I've found it not that useful in the past. Crystal is just trying to warn you that you can't use a feauture you probably don't want to use anyway.

 

[dwolff51]

Thanks, Bruce. While I wouldn't say I was losing sleep over it, I'm comforted by the knowledge that I won't have to re-create a bunch of reports.