Crystal 10 Blank Title 65264

Yahoo Archive
1
Stan, I am not sure what Package you received but if you received an installation disk from Epicor for 8.03.400, it has the Crystal XI for .NET 3.0 on it as one of the last menu items for installation listed. There is an additional hotfix you need to download from EpicWeb and install as well on top of it.
Thanks
RSN



[Non-text portions of this message have been removed]
2
Just beginning creating new reports in Crystal 10 from a 8.03.404 db.
I've done a couple of simple/basic reports successfully, but on two
separate attempts at different more complex reports (more than 2 tables
used) I got the errors below. The tables in use were first the JobHed,
Job prod and InvDtl, the second attempt used JobHed, JobOpr and
LbrDtl. Has anyone encountered this and know what it means? Or
better, have the solution?

Two errors returned on both attempts:
"Failed to open a rowset" and "Query Engine error: 'HY000:{DataDirect}
{ODBC Progress Open Edge WireProtocol Driver {OPENEDGE]Lock Table is
full. (7870)' "


Thanks
3
On your ODBC Advance tab is your Default Isolation Level "Read
Uncommitted". This should not do any locking.



Also a new CR run time was release last week.



Dale

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of stanchmura
Sent: Wednesday, May 28, 2008 10:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal 10



Just beginning creating new reports in Crystal 10 from a 8.03.404 db.
I've done a couple of simple/basic reports successfully, but on two
separate attempts at different more complex reports (more than 2 tables
used) I got the errors below. The tables in use were first the JobHed,
Job prod and InvDtl, the second attempt used JobHed, JobOpr and
LbrDtl. Has anyone encountered this and know what it means? Or
better, have the solution?

Two errors returned on both attempts:
"Failed to open a rowset" and "Query Engine error: 'HY000:{DataDirect}
{ODBC Progress Open Edge WireProtocol Driver {OPENEDGE]Lock Table is
full. (7870)' "

Thanks




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
4
I spoke with Epicor about this a few months ago without any luck. I
discovered that I had this problem only when linking more than 2 tables
where at least one left outer join existed. I modified an old .reg file
to look like this



Windows Registry Editor Version 5.00



[HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal
Reports\Database\QueryBuilder\JoinBuilder]



PlusEqual



"OracleJoinBuilder"="PGOE1022"



Fixed the problem for me.



Perhaps Epicor has a patch posted for 10.1B by now?



Dan Shallbetter

States Electric Mfg.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of stanchmura
Sent: Wednesday, May 28, 2008 10:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal 10



Just beginning creating new reports in Crystal 10 from a 8.03.404 db.
I've done a couple of simple/basic reports successfully, but on two
separate attempts at different more complex reports (more than 2 tables
used) I got the errors below. The tables in use were first the JobHed,
Job prod and InvDtl, the second attempt used JobHed, JobOpr and
LbrDtl. Has anyone encountered this and know what it means? Or
better, have the solution?

Two errors returned on both attempts:
"Failed to open a rowset" and "Query Engine error: 'HY000:{DataDirect}
{ODBC Progress Open Edge WireProtocol Driver {OPENEDGE]Lock Table is
full. (7870)' "

Thanks





[Non-text portions of this message have been removed]
5
Hi Everyone,

I have been working on this labor overtime report and the challenge I am
having is to subtotal a group formula based on a criteria type

My report is calculating Ot after the sum of payhours - 40 that is what
is making it difficult to subtotal I can do the formula for each
employee

I just cannot get it to sum correctly based on criteria.

I would like to sum this report by plant and department and have grand
totals for each company.

Thank you in advance for your help


Don









<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
Id=65265/stime=1211990478/nc1=4507179/nc2=5349273/nc3=5370602>



[Non-text portions of this message have been removed]
6
Don,

Have you tried using a Running Total for the field you are trying to sum and
then use a formula on when to Evaluate the value.

Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@...
P: 414-365-9732
F: 414-355-1931


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Don Kollmann
Sent: Wednesday, May 28, 2008 11:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report LaborOT Report

Hi Everyone,

I have been working on this labor overtime report and the challenge I am
having is to subtotal a group formula based on a criteria type

My report is calculating Ot after the sum of payhours - 40 that is what
is making it difficult to subtotal I can do the formula for each
employee

I just cannot get it to sum correctly based on criteria.

I would like to sum this report by plant and department and have grand
totals for each company.

Thank you in advance for your help


Don









<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
Id=65265/stime=1211990478/nc1=4507179/nc2=5349273/nc3=5370602>



[Non-text portions of this message have been removed]


------------------------------------

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/linksYahoo! Groups Links
7
We have a crystal report for OT by person. The report is run for one
week at a time.
The report groups and subtotals hours by each employee.
It is a multi-column report with the columns being: direct labor,
indirect labor, vacation. holiday, OT.
Each column subtotals by group, company, employee pay type (hrly or
salaried) with the exception of OT, that is a calculated field.
Here is the formula used for the field called @OT:

if {empbasic.shortchar02} = "HOURLY"
then
if Sum ({labordtl.laborhrs}, {labordtl.employeenum})-Sum ({@Vac},
{labordtl.employeenum}) > 40
then Sum ({labordtl.laborhrs}, {labordtl.employeenum})-Sum ({@Vac},
{labordtl.employeenum})-40
else 0
else 0

The report works great if run weekly. Note: we do not pay overtime for
vacation hours.

Pam
Metro

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Wednesday, May 28, 2008 1:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Report LaborOT Report



Don,

Have you tried using a Running Total for the field you are trying to sum
and
then use a formula on when to Evaluate the value.

Scott Litzau, MCP
Olympus Flag & Banner
Information Systems Manager
scott.litzau@... <mailto:scott.litzau%40olympus-flag.com>
P: 414-365-9732
F: 414-355-1931

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Don Kollmann
Sent: Wednesday, May 28, 2008 11:22 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Report LaborOT Report

Hi Everyone,

I have been working on this labor overtime report and the challenge I am
having is to subtotal a group formula based on a criteria type

My report is calculating Ot after the sum of payhours - 40 that is what
is making it difficult to subtotal I can do the formula for each
employee

I just cannot get it to sum correctly based on criteria.

I would like to sum this report by plant and department and have grand
totals for each company.

Thank you in advance for your help


Don

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
>
Id=65265/stime=1211990478/nc1=4507179/nc2=5349273/nc3=5370602>


[Non-text portions of this message have been removed]

------------------------------------

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/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links






[Non-text portions of this message have been removed]
8
Doesn't 8.03.4xx require Crystal XI?
9
Yes! Just found that out. The folks at Epicor did not include that in the
8.03.400 package I received.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Claudia Stone
Sent: Wednesday, May 28, 2008 7:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 10

Doesn't 8.03.4xx require Crystal XI?



[Non-text portions of this message have been removed]