Running Periods

[arinancia]

I need to display the running Periods in a Crosstab using a relational package, e.g., Individuals apply for funding for a project. the application can either be approved or Pending depending on period selected. If I select(Value Prompt based on date applied) 1 Jan 2010 - 30 Mar 2010 for project X then I want to display:

Pro x - Jan - Pending
Feb - Pending
Mar - Approved
This is more of a running period concept and can be easily archieved using dimensional data. Please help. the status is a calculated data item and will dynamically change based on date selection.

 

[blom0344]

Report Studio crosstabs need an aggregated measure in the body to work. We have gotten this to work by fetching a code for the measure, build the crosstab and then use a report expression over the measure to translate the codes to expressions.

In your case use , say 0 for pending and 1 for approved.

I disagree with you on the running period concept here, your dataset needs to explicitly state which code is valid for a month for each project in order for this to work (in a crosstab)

Ties Blom