Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Creating missing values Post Reply Post New Topic
Author Message
Elviajero
Newbie
Newbie


Joined: 18 Apr 2008
Online Status: Offline
Posts: 1
Quote Elviajero Replybullet Topic: Creating missing values
     Posted: 18 Apr 2008 at 1:43am
Hi

I have to build report based on date range i is very simple report but there is one requirment to always show all month even when date range is in 1 or 2 or 3 month. Can any one has idea how to do it?
I have one table to work on it so i can not do outer join to other table.
I think that i have to build formula or function or something to populate month list.

Best regards
IP IP Logged
fusion
Groupie
Groupie


Joined: 12 Nov 2007
Location: United States
Online Status: Offline
Posts: 93
Quote fusion Replybullet Posted: 18 Apr 2008 at 11:36am

You might have to use a SQL Case statement. Someone might be able to help you on that.

IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum