• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 444
  • Last Modified:

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

1 Solution
I don't think ypu can do it in Crystal.  

You may be able to write a stored procedure to get that data.

evendAuthor Commented:
Yeh, I thought that might be the case.  I saw a posting on creating a manual crosstab.
I may try something like that, Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now