Problems Reporting Shipments-Crystal

Yahoo Archive
1
I figured out the problem. Somewhere between 5.0 and 6.0 Vantage
modified the DB structure which caused my problem. I had to link the
ShipHead Table and ShipDtl Table by CustNum and the report runs
fine. I also ran across a similar situation in the OrderHead and
OrderDtl tables. I had to add a link there by CustNum on another
problem report. This wasn't necessary in 5.0, in fact I don't think
the CustNum field existed in the Detail Tables, feel free to correct
me if I wrong on that.


Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
wrote:
> We're on Vantage 6.0. Ever since the upgrade I've had problems
with
> a handful of Crystal Reports. After much investigating I think
I've
> narrowed it down to these circumstances.
>
> The reports have 3 tables. The Customer Table, ShipHead, and
> ShipDtl. I have problems with Crystal (Not Responding) if I filter
> on Customer ID and use a date range on the Ship Date like Greater
> than or Equal to. If I use Equal to the reports work. I
> particularly had problems running these on my IIS server, but today
I
> tried something different. Under report options I took away the
> check box for Using Indexes or Server for Speed. The reports take
a
> long time, but now they run. Does this make sense to anybody?
Would
> anyone care to try and duplicate it and let me know if they
> experience the same problems? Monday I will give a call to
support,
> but I thought I post the question here first.
>
> Happy Easter Everyone.
>
> Brian Stenglein
2
We're on Vantage 6.0. Ever since the upgrade I've had problems with
a handful of Crystal Reports. After much investigating I think I've
narrowed it down to these circumstances.

The reports have 3 tables. The Customer Table, ShipHead, and
ShipDtl. I have problems with Crystal (Not Responding) if I filter
on Customer ID and use a date range on the Ship Date like Greater
than or Equal to. If I use Equal to the reports work. I
particularly had problems running these on my IIS server, but today I
tried something different. Under report options I took away the
check box for Using Indexes or Server for Speed. The reports take a
long time, but now they run. Does this make sense to anybody? Would
anyone care to try and duplicate it and let me know if they
experience the same problems? Monday I will give a call to support,
but I thought I post the question here first.

Happy Easter Everyone.

Brian Stenglein
3
Maybe the problem is because the customer table has so many indexes. MS Access can't read the customer table for this reason. Epicor has instructions on creating a view for the customer table. You might try that, linking the report to the view instead of the table itself. I would think that it would also speed up your reports. Another thought is to create a view in Progress that you includes all the tables in your report. Let the view take care of the joins and then filter the view results. I think that would speed things up allot. This method has proven very usefull to us in the past.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Brian Stenglein [mailto:bstenglein@...]
Sent: Friday, April 09, 2004 4:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Problems Reporting Shipments-Crystal


We're on Vantage 6.0. Ever since the upgrade I've had problems with
a handful of Crystal Reports. After much investigating I think I've
narrowed it down to these circumstances.

The reports have 3 tables. The Customer Table, ShipHead, and
ShipDtl. I have problems with Crystal (Not Responding) if I filter
on Customer ID and use a date range on the Ship Date like Greater
than or Equal to. If I use Equal to the reports work. I
particularly had problems running these on my IIS server, but today I
tried something different. Under report options I took away the
check box for Using Indexes or Server for Speed. The reports take a
long time, but now they run. Does this make sense to anybody? Would
anyone care to try and duplicate it and let me know if they
experience the same problems? Monday I will give a call to support,
but I thought I post the question here first.

Happy Easter Everyone.

Brian Stenglein



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links