Crystal Reports Filter

Yahoo Archive
1
I would venture to say that it's the ODBC driver that is the culprit. The Merant drivers seem more robust for joins, etc.

Troy Funte

----- Original Message -----
From: Wendy Bowen (Pursche)
To: vantage@yahoogroups.com
Sent: Friday, April 26, 2002 11:08 AM
Subject: Re: [Vantage] Crystal Reports Filter


Troy,

We're using Vantage 5.1, Crystal 8.5, & ODBC for Progress 9.1C (v3.60). I heard rumors that Crystal 8 is more stable than 8.5. Is that true?

I think I will attempt to recreate the report. Yeah, I agree it is a pain, but if it helps the problem....

Thanks!
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Friday, April 26, 2002 10:33 AM
Subject: Re: [Vantage] Crystal Reports Filter


Wendy,
Sometimes restarting the report from scratch will help solve 'mystery lockups'. It's a pain, but it often-times has worked for me.

Once again, what version of Vantage, Crystal, and ODBC are you using?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Wendy Bowen (Pursche)
To: vantage@yahoogroups.com
Sent: Friday, April 26, 2002 8:11 AM
Subject: Re: [Vantage] Crystal Reports Filter


Troy,

That is a good solution. But, for some reason everytime I use a dual filter for the Employee ID and/or EmployeeBasic.firstname the report locks up. I'm clueless as to why this is happening.

Any ideas?
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Thursday, April 25, 2002 10:36 PM
Subject: Re: [Vantage] Crystal Reports Filter


Wendy,
If your EmplID's all BEGIN with an Alpha character, you could do something like this in your select statement:

(EmplID = "53" or EmplID >= 'a')

This could work since alpha characters get sorted after numbers, but only if the first character is an alpha character.

Troy Funte
Liberty Electronics

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


Yahoo! Groups Sponsor
ADVERTISEMENT




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]
2
Hey everyone!
How do I create a filter in Crystal that will include only employee # 52 and any employee with an alpha numeric character? We use to set all of our unattended time under employee #52 but now we're tracking all unattended time by the machine name. So, I need both filtering options to work for current jobs and old jobs.

Anyone?

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

[Non-text portions of this message have been removed]
3
What I do for unattended is set the 'last name' field to 'unattended' for
every entry, and the first name to the machine. So, when I need to filter
on the unattended equipment, I just filter on last name = 'unattended'
regardless of the id# used.




[Non-text portions of this message have been removed]
4
Actually that is a good idea! But, when I go to filter on Empbasic.Firstname the report locks up. I don't know why. So it seems as if I need to figure out how to filter it with the Labordtl.empid.
----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Thursday, April 25, 2002 1:28 PM
Subject: RE: [Vantage] Crystal Reports Filter


What I do for unattended is set the 'last name' field to 'unattended' for
every entry, and the first name to the machine. So, when I need to filter
on the unattended equipment, I just filter on last name = 'unattended'
regardless of the id# used.

[Non-text portions of this message have been removed]
5
Wendy,
If your EmplID's all BEGIN with an Alpha character, you could do something like this in your select statement:

(EmplID = "53" or EmplID >= 'a')

This could work since alpha characters get sorted after numbers, but only if the first character is an alpha character.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Wendy Bowen (Pursche)
To: vantage@yahoogroups.com
Sent: Thursday, April 25, 2002 1:15 PM
Subject: [Vantage] Crystal Reports Filter


Hey everyone!
How do I create a filter in Crystal that will include only employee # 52 and any employee with an alpha numeric character? We use to set all of our unattended time under employee #52 but now we're tracking all unattended time by the machine name. So, I need both filtering options to work for current jobs and old jobs.

Anyone?

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

[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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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

That is a good solution. But, for some reason everytime I use a dual filter for the Employee ID and/or EmployeeBasic.firstname the report locks up. I'm clueless as to why this is happening.

Any ideas?
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Thursday, April 25, 2002 10:36 PM
Subject: Re: [Vantage] Crystal Reports Filter


Wendy,
If your EmplID's all BEGIN with an Alpha character, you could do something like this in your select statement:

(EmplID = "53" or EmplID >= 'a')

This could work since alpha characters get sorted after numbers, but only if the first character is an alpha character.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Wendy Bowen (Pursche)
To: vantage@yahoogroups.com
Sent: Thursday, April 25, 2002 1:15 PM
Subject: [Vantage] Crystal Reports Filter


Hey everyone!
How do I create a filter in Crystal that will include only employee # 52 and any employee with an alpha numeric character? We use to set all of our unattended time under employee #52 but now we're tracking all unattended time by the machine name. So, I need both filtering options to work for current jobs and old jobs.

Anyone?

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

[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/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
ADVERTISEMENT




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]
7
Wendy,
Sometimes restarting the report from scratch will help solve 'mystery lockups'. It's a pain, but it often-times has worked for me.

Once again, what version of Vantage, Crystal, and ODBC are you using?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Wendy Bowen (Pursche)
To: vantage@yahoogroups.com
Sent: Friday, April 26, 2002 8:11 AM
Subject: Re: [Vantage] Crystal Reports Filter


Troy,

That is a good solution. But, for some reason everytime I use a dual filter for the Employee ID and/or EmployeeBasic.firstname the report locks up. I'm clueless as to why this is happening.

Any ideas?
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Thursday, April 25, 2002 10:36 PM
Subject: Re: [Vantage] Crystal Reports Filter


Wendy,
If your EmplID's all BEGIN with an Alpha character, you could do something like this in your select statement:

(EmplID = "53" or EmplID >= 'a')

This could work since alpha characters get sorted after numbers, but only if the first character is an alpha character.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Wendy Bowen (Pursche)
To: vantage@yahoogroups.com
Sent: Thursday, April 25, 2002 1:15 PM
Subject: [Vantage] Crystal Reports Filter


Hey everyone!
How do I create a filter in Crystal that will include only employee # 52 and any employee with an alpha numeric character? We use to set all of our unattended time under employee #52 but now we're tracking all unattended time by the machine name. So, I need both filtering options to work for current jobs and old jobs.

Anyone?

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan

[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/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
ADVERTISEMENT




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]


Yahoo! Groups Sponsor
ADVERTISEMENT




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]
8
Troy,

We're using Vantage 5.1, Crystal 8.5, & ODBC for Progress 9.1C (v3.60). I heard rumors that Crystal 8 is more stable than 8.5. Is that true?

I think I will attempt to recreate the report. Yeah, I agree it is a pain, but if it helps the problem....

Thanks!
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Friday, April 26, 2002 10:33 AM
Subject: Re: [Vantage] Crystal Reports Filter


Wendy,
Sometimes restarting the report from scratch will help solve 'mystery lockups'. It's a pain, but it often-times has worked for me.

Once again, what version of Vantage, Crystal, and ODBC are you using?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Wendy Bowen (Pursche)
To: vantage@yahoogroups.com
Sent: Friday, April 26, 2002 8:11 AM
Subject: Re: [Vantage] Crystal Reports Filter


Troy,

That is a good solution. But, for some reason everytime I use a dual filter for the Employee ID and/or EmployeeBasic.firstname the report locks up. I'm clueless as to why this is happening.

Any ideas?
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Thursday, April 25, 2002 10:36 PM
Subject: Re: [Vantage] Crystal Reports Filter


Wendy,
If your EmplID's all BEGIN with an Alpha character, you could do something like this in your select statement:

(EmplID = "53" or EmplID >= 'a')

This could work since alpha characters get sorted after numbers, but only if the first character is an alpha character.

Troy Funte
Liberty Electronics

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