Solved

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

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

706 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now