Solved

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

Posted on 2009-04-04
2
426 Views
Last Modified: 2013-11-15
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

0
Comment
Question by:evend
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24069841
I don't think ypu can do it in Crystal.  

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

mlmcc
0
 

Author Comment

by:evend
ID: 24071142
Yeh, I thought that might be the case.  I saw a posting on creating a manual crosstab.
I may try something like that, Thanks!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question