[dba-Tech] Question about SAP Crystal Reports

[Arthur Fuller]

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