Crystal Reports 9 report off Exchange Server 2003 Task items

Hello!

I am attempting to create a Crystal Report off a Public Folder containing Task items on an Exchange 2003 server from my desktop.  All seems to go well until I try to find the "% Complete" field that I sort on in the Public Folder usually.  It does not show in the field list in Crystal Reports.  I suspect this is due to the "%" sign.  Or, am I mistaken?  Besides that, the report runs accurately, but I want to exlcude any task items that are 100% complete...
hydraziAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
I agree that is what is shown but sometimes the interface shown to users uses more meaningful names than the ones used for the fields in the database.

I don't have an Exchange install I can work against.

How about adding a task and seeting the completion tosome odd numbers like 43% then create a report that just uses the table and see if you can find the column that has the 43% in it

mlmcc
0
 
mlmccCommented:
Are you sure the field is called % complete?
What you see may be just a field header.  It is also possible, it is a calculated field.

mlmcc
0
 
hydraziAuthor Commented:
Hmmm... yes, that is possible, I suppose.  It is definitely listed as % Complete on the views in  Outlook and you can choose from a drop down list to populate it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.