Skip to Content
author's profile photo Former Member
Former Member

Setting Datasource Location

Hello,

I have a complex report and I am trying to avoid having to re-create it.

The report's driving table (the left-outermost table) stores data for each employee by period. So say you have 3 periods, Jan09, Feb09, and Mar09, you will have 3 records for 1 employee. Basically it is a historical data warehouse table.

The left outermost table is this very data warehouse table. What I want to be able to do is bring back only those records for the period in which we are in. If I use a select expert to filter on the period, it appears as though the reports still scans all the records in the table first and then filters when it already gets into Crystal. A very poor performance resoluion.

I tried creating SQL Command that says

select *
from table
where period='{?Enter End Period}'

Then use this as the main driving table and left outer join it to the previous driving table. But it still appears as though it parses through all the records.

I don't want to recreate the report so how can I do the filtering on the database level before it gets into Crystal?

Thanks in advance,

Zack H.

Edited by: Zack H on Sep 4, 2009 11:23 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 06, 2009 at 01:45 AM

    This is showing as answered, but I don't see any responses, so I'll go ahead.

    In Crystal, go to the File menu and select "Report Options". Make sure that "Use Indexes or Server for Speed" and "Perform Grouping on Server" are both checked. You can also set these values to be your defaults by going to the File menu, selecting "Options" and going to the Database tab.

    However, some things will affect whether the sorting and grouping actually happen on the server. For example, if you're using a Crystal function on a field in your selection criteria or as a group, it may cause Crystal to bring down all of the data and process it locally.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.