Showing a row with no data in Cross tab report

[cinbh]

I have an enduser that wants to see a date row even if no data is available. It's a challenge in that we only show shipments as a Monday date. Currently my x-tab rows are by BaseProduct,MondayDate and the columns are the ProductType. We have many products that ship only certain times of the year, so the potential is that MondayDates can be missing within the BaseProduct groups. I export this into Excel so she's really looking for me to create it from the output section. Any suggestions using the Crystal x-tab expert? Crystal 8.5 on VFP 8.0
Thanks, Cindy

 

[synapsevampire]

The way that I suggest doing this is to create a Period table which houses every day for every year, and then do a left outer join to your data. This is similar to many data warehouse designs.

I have a FAQ here which discusses the topic and addresses other concerns that this method addresses.

faq767-4532

-k

 

[cinbh]

Thanks, but I'm not permitted to create tables in our version of VFP and the way they currently create their MondayDate info is with an Function(?), so I'm outta luck. Unless I'm missing the point of your FAQ I think I will have to create a seperate report that has a formula on the date field to show my enduser what doesn't have a value. Should be nice and time consuming for me. Appreciate the responses!
Cin

 

[IdoMillet]

The only semi-reasonable alternative to SV's suggestion is to use a UNION query/view as the data source for the report. You would need to add at least one record (with zero or Null information) for each "MondayDate" with one of the BaseProduct groups.

If I were you, I would do what I can to get the necessary permission to pursue the solution sugeted above by SV...

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com