[dba-Tech] Question about SAP Crystal Reports

[Bobby Heid]

I agree with you.  I would have written a stored procedure or view as the
source.  Much easier to update the source than the report.  Possibly the
original author was not allowed to create objects on the source database.
Other than grouping or subtotals, I like the server to do the heavy lifting.

Thanks,
Bobby


-----Original Message-----
From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of
Arthur Fuller
Sent: Monday, August 14, 2017 8:26 PM
To: Discussion of Hardware and Software issues
<dba-tech at databaseadvisors.com>
Subject: Re: [dba-Tech] Question about SAP Crystal Reports

Thanks, Bobby,

I'll give it a look in the morning. As I recall, the first item on the
Database menu was Database Wizard, where I actually expected to find it, but
all I could see there was a list of the tables in the database. I'll also
try searching the Help for Set Location; that might work.

Since you have experience with CR, I want to run an opinion past you and
obtain some feedback. The report of immediate concern seems to perform the
required JOINs and GROUP BYs, and also calculated columns, within the report
definition. This goes against pretty much everything I've learned about
databases; my aphorism is, Anything the database *can *do, the database
*should *do. Had I built this report from scratch, I would have first
defined a View that joins the tables at the database level, and then based
the report on said View.

What say you?

Arthur

On Mon, Aug 14, 2017 at 5:38 PM, Bobby Heid <bheid at sc.rr.com> wrote:

> Hi Arthur,
>
> Just doing this from memory from version 8.x...
>
> Under database, there was something like Set Location.  It may have 
> been called something else, but it was maybe the first or second thing 
> under Database.
>
> Thanks,
> Bobby
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com