Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help in syntax error in Report Studio

Status
Not open for further replies.

udaykamble

Programmer
Feb 10, 2009
36
0
0
US
round( (
case when ([Database View].[ResourceAssignment].[Remaining Start Date]>_add_days([Database View].[Project].[Data Date],43)) THEN (0)
when ([Database View].[ResourceAssignment].[Remaining Finish Date]<_add_days([Database View].[Project].[Data Date],43))
then ([Database View].[ResourceAssignment].[Remaining Units] )
else
([Database View].[ResourceAssignment].[Remaining Units] * (43 - _days_between([Database View].[ResourceAssignment].[Remaining Start Date],[Database View].[Project].[Data Date]))/_days_between([Database View].[ResourceAssignment].[Remaining Finish Date],[Database View].[ResourceAssignment].[Remaining Start Date]) )
end)/7/40, 2)

I am getting following error : I am not sure why as it is working in another report.

QE-DEF-0030 Expression parsing error.
QE-DEF-0359 The query contains a reference to at least one object '[Database View].[ResourceAssignment].[Remaining Start Date]' that does not exist.


 
The column referenced,
'[Database View].[ResourceAssignment].[Remaining Start Date]'
is not found in the defined data store.

Double check the data object items.

SLN
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top