• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

BusinessView Layer or SQL Views?

Hello experts -

If anybody has experience with using BOE BusinessViews over just using the SQL views, I would like to hear your thoughts on performance, ease of use, etc.  I am leaning toward an integrated approach, using BusinessViews for reports that require dynamic parameters and then just reporting off SQL views for reports that only require static lists or date parameters.  All our report writers have a SQL background so it seems to be more work than it's worth to build complicated Business Views.  All the reports will be accessed through Crystal Server with either the report viewer or InfoView.

Thank you for any insight!

Lisa
0
lcallah93
Asked:
lcallah93
  • 2
1 Solution
 
mlmccCommented:
What version of Crystal do you have?

You might look at this discussion of the issue
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_26766843.html

mlmcc
0
 
mlmccCommented:
0
 
lcallah93Author Commented:
Thank you for the posts - the first one was actually me but the second one did help.  I guess I am really searching for validation of my implementation plan which is to use Business Views only when necessary (for dynamic cascasing parameters) and then to continue to build reports directly off the SQL database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now