Good Reporting Tool for VB to SQL (Currently Use Crystal) or Crystal w/SQL Help Appreciated 
Author Message
 Good Reporting Tool for VB to SQL (Currently Use Crystal) or Crystal w/SQL Help Appreciated

SQL 6.5, VB 4.0 (32 Bit)

I am currently using Crystal Reports 4.x to report against SQL data.  ( I
took the Crystal Reports from VB5 and installed it with my VB4 - can't use
VB5 for other reasons on this app).

The reporting tool seems Ok for some of our solutions, but on others it
fails or just can't perform the task.  For example, with TEXT data types,
we are getting a result on the printout where the contents of one field are
displayed in another.

Also, when we have one parent table to two or more repeating children
tables we can not setup a report that will display the appropriate results.
 For example:

Table ORDER has one row
Table DETAIL has three rows
Table RATES has two rows

Now we want to create a report that includes information from all three
tables.  A SQL Query might look like this:

Select ORDER.NUM, DETAIL.QTY, RATES.EFFECTIVEDATE
From ORDER, DETAIL, RATES
Where ORDER.NUM *= DETAIL.NUM AND ORDER.FEESCHEDULE *= RATES.FEESCHEDULE

The result could be:

ORDER.NUM               DETAIL.QTY              RATES.EFFECTIVEDATE
0001                    1                       Jan 01, 1997
0001                    4                       Jan 02, 1997
0001                    1                       (Null)

The problem is that no Crystal has no way of reporting on the DETAIL.QTY
field in a repeating value setup and then go back and report on the
RATES.EFFECTIVEDATE (with a repeating value setup for that section as
well).  Crystal has some options that can do this with ACCESS, dBase,
etc... But not SQL.

The option I am faced with is to attach the SQL tables to a Jet Database
(mdb) file and report against that.  It is not a good solution because some
of the data is large and would take too long.

Any other suggestions about Crystal and SQL or another tool and SQL.

Any help would be appreciated.  Please feel free to email me directly at:

--
Thank You,
Gary Glickman
InterWave Computer Software, Inc.
http://www.***.com/



Sat, 08 Apr 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Question: Outer Joins in MS SQL-Server when using Sub-Reports of Crystal Reports

2. Using crystal Reports Web to report on SQL database requires password

3. Crystal Reports ANd VB 6.0 Printing reports using CRPEAUTO Object, specifying paper orientation problem

4. Printing report from Dynaset using Crystal Report and VB

5. Editing Crystal reports without Crystal Reports

6. Crystal Report 6 and Crystal Report 8

7. Announcement: Easily integrate Crystal Reports with Remedy with UFLTimeZone for Crystal Reports

8. Development of datawarehouse applications using Oracle, Visual Basic, Crystal reports, Java and various EIS tools

9. VB+SQL+CRYSTAL REPORT PROBLEM

10. Calling Crystal Report from VB, repo is based on Stored Procedure in Sql Server

11. SQL , VB, and Crystal Reports

12. Crystal Report Problem w/ VB & SQL


 
Powered by phpBB® Forum Software