Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can I use the option "Perform grouping on server" on web 1
- Thread starter chioma
- Start date
-
1
- #2
When using "perform grouping on server" keep the following in mind:
* Must use a SQL/ODBC database, cannot be performed on a native connection or on a query.
* The details section should be suppressed, no drill down. The whole reason for server-side processing is to enhance performance. Reducing communication between the client and the server is one way to do this. If you show the details section, while the grouping will still take place on the server, you will gain nothing from it.
* Do not put any database fields in the Page, report or group headers/footers. Use group name fields or summary operations only. Any use of database fields defeats your purpose as stated in the previous point.
As far as I know you should have no problems with this on web enabled reports. Software Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
* Must use a SQL/ODBC database, cannot be performed on a native connection or on a query.
* The details section should be suppressed, no drill down. The whole reason for server-side processing is to enhance performance. Reducing communication between the client and the server is one way to do this. If you show the details section, while the grouping will still take place on the server, you will gain nothing from it.
* Do not put any database fields in the Page, report or group headers/footers. Use group name fields or summary operations only. Any use of database fields defeats your purpose as stated in the previous point.
As far as I know you should have no problems with this on web enabled reports. Software Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com
- Thread starter
- #3
Thank you very much for your response, now it's clear my problem:
when I run a report I need to filter the data.
I call the report in a asp page but before it I set the selectionformula's propriety with the filter (of course every time I run the report the filter is different).
In this way "perform grouping on server" doesn't function.
Is there another way to filter the data and perform grouping on server ?( without this option the performance decrease dramatically )
when I run a report I need to filter the data.
I call the report in a asp page but before it I set the selectionformula's propriety with the filter (of course every time I run the report the filter is different).
In this way "perform grouping on server" doesn't function.
Is there another way to filter the data and perform grouping on server ?( without this option the performance decrease dramatically )
What is your filter expression? I would think that you could still filter and use this feature as long as your filter can be converted to SQL. Not all formulas in CR can be converted. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
- Thread starter
- #5
Thank you for your response, I have found the mistake.
I always put at the end of the "filter expression" (where condition) the expression " and 0=0".
Without this stupid condition the option "Perform grouping on server" it's o.k.
I always put at the end of the "filter expression" (where condition) the expression " and 0=0".
Without this stupid condition the option "Perform grouping on server" it's o.k.
- Status
Similar threads
- Question
- Question
- Locked
- Question
- Locked
- Question