Hello,
I'm doing Crosstab report in report studio against relational database
Rows. Date , SubSystem
Columns: Department, Year, Desc
Measure :Actual
Prompt : Year, Month, Department.
business logic for report is to find activity for actual $$ in selectedYear/selected month/dates and also Prior months activity Balance Forward for selected departments.
I could write calculation to find total, total( [actual] for [desc],[year],[system],[date]) as Dept total
now how do i write condition or cal for getting running-total of [Depttotal].
here's calc for running-total i written..
running-total([depttotal] for [desc],[year],[department])
so how do I write a calc to get the running total even if system is having two records for single day?
I figured my self. all columns are defined as varchar or char data types on crosstab columns, so i have to change datatypes and redefine the grouping in new query subject in fm apply the determinants, i guess it start.
thanks