Link to home
Start Free TrialLog in
Avatar of evend
evend

asked on

Crystal Crosstab Carry Over Previous Column Value If Current is Null?

I have crosstab that shows columns based on period ending dates where the values come from a table. I used the maximum option to pull the last record for a given period end date.  Which is usually the last day of the week.  However, some weeks that are no records for a given customer so I want the crosstab to carry over the value from the previous end date.
This is used for monitoring ending inventory values from week to week and some weeks a customer may not have an inventory record so we need to carry over the previous weeks value.
Record selection:
{named_periods.name} = "Weeks" and
{Vend_Visits.visit_DateTime} = {?Date} and
{points_of_sale.pos_active} = "Y" and
{Vend_Visits.financial_status} <> "V"
 
group formula:
{Vend_Visits.visit_DateTime}=maximum({Vend_Visits.visit_DateTime}, {periods.name})

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of evend
evend

ASKER

Yeh, I thought that might be the case.  I saw a posting on creating a manual crosstab.
I may try something like that, Thanks!