[dba-Tech] Question about SAP Crystal Reports

[Stuart McLachlan]

Agreed - use the BE to do as much of the work as possible.

If you want the server to do the sorting too , you need to use a stored procedure as-well-as or 
in-lieu-of a view. Unless you resort to a real nasty hack -  you can't reliably  create a sorted 
view.

-- 
Stuart
   

On 14 Aug 2017 at 21:34, Bobby Heid wrote:

> 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
> 
> 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>