Well, it could be two things - one of which was a limit of how many 'specific' parts could be listed in a "One of..." statement. When I tried a report where I was picking out 250 specific part numbers, Merant had a problem until a line was added to the ODBC startup parameter. But that doesn't sound like the case with yours if your just saying "give me all the jobs".
My assumption is that the 10 table joins are the problem. And the only way I know of to find out is to start from scratch and add one table at a time until the problem happens and then analyze it. Incidently, I had a report with a few complex joins in Vantage 3.0, Merant 3.5 that didn't work and Ben at Epicor offerred to look at it for me once we moved to 5.0 (since that's what he had loaded on his machine). But that particular problem went away in 5.0 with the Merant 3.5 driver. But it was the same as your situation. If I picked 5 to 10 jobs, the report worked. If I picked ALL jobs, the report just stopped.
Another error checking method that we used on the above problem was to turn the SQL log on in the ODBC administrator. I don't know if SQL 3.6 has such a thing since I'm still happily using Merant 3.5. If you wanted to send me the report, I could try it on our database with Merant 3.5 and see if there is any difference. It may take me a few days to get to it, but I'd be willing to look.
Troy Funte
Liberty Electronics
My assumption is that the 10 table joins are the problem. And the only way I know of to find out is to start from scratch and add one table at a time until the problem happens and then analyze it. Incidently, I had a report with a few complex joins in Vantage 3.0, Merant 3.5 that didn't work and Ben at Epicor offerred to look at it for me once we moved to 5.0 (since that's what he had loaded on his machine). But that particular problem went away in 5.0 with the Merant 3.5 driver. But it was the same as your situation. If I picked 5 to 10 jobs, the report worked. If I picked ALL jobs, the report just stopped.
Another error checking method that we used on the above problem was to turn the SQL log on in the ODBC administrator. I don't know if SQL 3.6 has such a thing since I'm still happily using Merant 3.5. If you wanted to send me the report, I could try it on our database with Merant 3.5 and see if there is any difference. It may take me a few days to get to it, but I'd be willing to look.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Dan Shallbetter
To: 'vantage@yahoogroups.com'
Sent: Tuesday, August 21, 2001 8:15 AM
Subject: RE: [Vantage] Crystal Reports not responding
Troy I am listing information for each job in a group footer section only. I
have my report running properly with a filter like "JobHead.Jobnumber starts
with "031", but as soon as I change it to any job the report stops
responding with no error messages displayed. What is the issue with the
Merant driver?
Thanks
Dan Shallbetter
States Electric Mfg.
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, August 20, 2001 4:55 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports not responding
Dan,
Are you specifically selecting a LARGE number of jobs (ie. listing them
individually)? If so, there can be an issue with the Merant Driver - which
can be resolved.
Is there an error message, or does it just hang there infinitely?
Also, Crystal and Progress don't mix very well with many table joins. To
test this, you should start with two tables with fields from each table.
Then refresh the report. Then add another table, and refresh again. That
way you can track which table is causing the trouble.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Dan Shallbetter
To: vantage@yahoogroups.com
Sent: Monday, August 20, 2001 2:19 PM
Subject: [Vantage] Crystal Reports not responding
I have written an ODBC report using the 3.6 SQL092 driver. The report
hash
10 tables Joined. I created a small subset of data by filtering on a range
of Job numbers for report development purposes. When I expand the filter
the
report stops responding. I have tested this on 2 different clients one
with
Crystal 8.0 and another running Crystal 8.5 both clients have the Crystal
database patch version. 8.5.20.107. Is there a maximum number of records
Crystal will read? Or is this another ODBC issue? Any help would be
greatly
appreciated.
Thanks
Dan Shallbetter
States Electric Mfg.
Yahoo! Groups Sponsor
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
998343701>
<http://us.adserver.yahoo.com/l?M=210949.1523302.3121208.1269402/D=egroupmai
l/S=1705007183:HM/A=763786/rand=980797896>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]