I am very new at this so.....
I am trying to fix this report that works in Cognos for Oracle but not Visual Studio.Net for SQL Server.
the report looks like i need to do a runningvalue in a runningvalue. I know it can not be done but is there a way around this. Here is my expression...
KerrieS
Member
25 Points
5 Posts
runningvalue in a runningvalue
Jul 11, 2005 02:04 PM|LINK
I am trying to fix this report that works in Cognos for Oracle but not Visual Studio.Net for SQL Server.
the report looks like i need to do a runningvalue in a runningvalue. I know it can not be done but is there a way around this. Here is my expression...
runningvalue(((((Fields!PART_QTY_ON_HAND.Value
- runningvalue(Fields!REQUIREMENT.Value), sum, "tbl1grp3")
* Fields!Temp_Part_Cost.Value ) + .005)
* Fields!ANNUAL_CARRYING_RATE.Value / 1200), sum, "tbl1grp3")
I really need some help.
Thanks