Attribute to check whether 0% complete, > 0 % Complete but not 100%complete, and 100%

A

anovak

Right now, I'm running a SQL Reporting Services Report that uses a
parameter. The following checks are done:

% Complete > -1 = All Projects
% Complete > 99 = Completed Projects
% Complete > 0 = In Progress Projects

HOWEVER, I noticed that > 0 is actually In Progress AND Completed.

Is there another status type attribute in the reporting database, etc.
that I can check using and "=" that would help narrow this down? As
it stands, I don't have the luxury of using a "between" clause in my
SQL.

I ask because sometimes there are numeric fields that are flagged with
different values based on the project state.

Any and all help would be greatly appreciated :)

Thanks,
Andy Novak
UNT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you query for projects that are completed or in progress inOLAP? 0
% Complete - Tasks and Activities 3
job failed to complete 4
Data Analysis Views and "Homemade" cubes 1
unable to set task as 100% complete 3
Which DRAFT DB data structure to pull forecast start,forecast finish,and percentcomplete? 1
Operational Project (here I go again, but with a decision on a finalapproach) 0
Tasks in Project Workspace - changing values in the Status field 1

Top