asked on

Optimal technique and recommendations producing Crystal Report in VB2012

We would like EE recommendations and maybe some techniques in producing viable reports in vb2012.

ASKER

FYI:

The database is in Microsoft SQL 2005.

Also to give you some inside on the tables we want report on:

Minimum Sizes in SQL:
Detail Tables: 7,000 rows
header Tables: 1,500 rows
Master Tables: 7,000 rows

Maximum Sizes in SQL:
Detail Tables: 480,000 rows
header Tables: 96,000 rows
Master Tables: 3,500 rows

Mike McCracken

Are you using the version that is for VB2012 or a standalone version of Crystal?

What are each of the table types used for?

Which tables link together?

mlmcc

jana

ASKER

Are you using the version that is for VB2012 or a standalone version of Crystal?

Yes, the one that comes in VB2012

What are each of the table types used for?

Detail Tables: Item sold
header Tables: Invoice Header and Footer info
Master Tables: Vendors, Products, Shipping/Billing Address, etc.

Which tables link together?

Details >> Header (Items >> Invoice Header)
Details >> Master (Items >> Products)
Header >> Master (Invoice Header >> Vendors)

SOLUTION

vasto

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jana

ASKER

Why use stored procedures? (Wouldn't it be he same if the query was in command in CR?)

Also, what do you mean by subreport for either to display customer/vendor for detail lines of the invoice?

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

vasto

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial