Solved

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

Posted on 2009-04-04
2
418 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 100

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.

735 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