Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Third Party Products

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
33%
Installation Wizard into new VRC
39%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 49

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 16th July 2004, 13:02
baan_fun baan_fun is offline
Junior Member
 
Join Date: Jun 2003
Posts: 29
baan_fun is on a distinguished road
Baan: Baan 4b2, 4c2,4c3,4c4,5c - DB: Oracle - OS: Unix, NT
Question Crystal Reports based on Views on Baan Tables

Hi,

Please let me know from your experience what is better : to create Crystal Reports based on Baan Tables or on views on these tables. We run Baan 5c with SQL Server; Crystal 9.0. I need to report on table tdsls451 (sales order lines history) and I'm afraid of a bad performance in Crystal for such a big table.

Is it possible to create the view on tdsls451 directly in Crystal (maybe using Crystal Query as Database) or do I have to create the view directly on SQL Server ?

Thanks a lot and regards.
Reply With Quote
  #2  
Old 16th July 2004, 15:12
gguymer's Avatar
gguymer gguymer is offline
Unconfirmed User
 
Join Date: Aug 2001
Location: Lufkin, Texas
Posts: 194
gguymer is on a distinguished road
Baan: Baan IVc4 SP12 - DB: Oracle 8i, 9i - OS: AIX 4.3, 5.3
On occations we use direct access to our native database (Oracle) for quicker response in reports against big tables.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.
Reply With Quote
  #3  
Old 28th July 2004, 06:01
jack786 jack786 is offline
Senior Member
 
Join Date: Apr 2004
Posts: 111
jack786 is on a distinguished road
Baan: BaanIVC - DB: SqlServer2000 - OS: Windows2000 server
How can we use direct access to our native database ??
Baan doesnt maintain any referential checks and primary keys at DBside?
I feel this takes long time then thru baan??
what do u say??
pls give me explantation
rgds,
jack
Reply With Quote
  #4  
Old 28th July 2004, 15:14
gguymer's Avatar
gguymer gguymer is offline
Unconfirmed User
 
Join Date: Aug 2001
Location: Lufkin, Texas
Posts: 194
gguymer is on a distinguished road
Baan: Baan IVc4 SP12 - DB: Oracle 8i, 9i - OS: AIX 4.3, 5.3
You need to create an ODBC connection for your SQL Server DB using the provided driver. With that ODBC connection you can then connect and access tables in your database with Crystal. The database may not have primary keys, but index 1 of each table is always created as a unique index. It is just as good as a primary key. All the referencial integrity is controlled on the Baan side, but that just requires that you do a little work in contructing some of that. The table definitions contain a lot of those references that you'll need to go by. I don't have any magic formulas to address this, other than just taking the time to try and understand each relationship.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.
Reply With Quote
  #5  
Old 28th July 2004, 15:32
jack786 jack786 is offline
Senior Member
 
Join Date: Apr 2004
Posts: 111
jack786 is on a distinguished road
Baan: BaanIVC - DB: SqlServer2000 - OS: Windows2000 server
Can u give me the answer for a post in tools development (The subject is
Execution path??)

rgds,
jack
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASCII file records into Baan tables srilal Tools Development 12 5th September 2003 15:48
Crystal Enterprise Solution Kit For BaaN 50c mangaliso Third Party Products 3 16th April 2003 22:37
crystal reports not working evertsen Third Party Products 5 21st February 2003 22:48
Baanboard.com Community Bulletin 01/10/2001 patvdv About Baanboard.com 0 1st October 2001 18:30
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44


All times are GMT +2. The time now is 16:19.


©2001-2018 - Baanboard.com - Baanforums.com