Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Problem with grouping on date field Post Reply Post New Topic
Author Message
vipulbhatia29
Newbie
Newbie


Joined: 08 May 2009
Location: India
Online Status: Offline
Posts: 10
Quote vipulbhatia29 Replybullet Topic: Problem with grouping on date field
     Posted: 15 Jun 2009 at 1:50am

Hi I have to group the data in my report on the basis of months in a particular year. Foreg. My groups should be like JANUARY 1999 , FEB 99, Mar 99 ------- DEC 99,--------- JAN 2009-----------DEC 2009. My Geroup is based on some Entry_dt column in the database. I'm grouping the report on the basis of entry_dt and in the group expert I have set  it on a monthly basis so the group looks good in the report. But there is one problem now, according to the client he wants the groups on those months also for which the data is not present and so he wants it as a group but under that group no data should be displayed
For instance if the database contains data such as 03/15/2009, 04/16/09 and so on etc. and there is no data present for the month of January and February there should be a group like

January 2009
Entry_dt Name AMOUNT

February 2009
Entry_dt Name AMOUNT

March 2009
Entry_dt   Name          AMOUNT
03/15/2009 Thomaes Scott $ 500

And so on

Now my report displays only the groups for which the dates are present in the ENTRY_DT column.
For Example


March 2009
Entry_dt      Name          AMOUNT
03/15/2009 Thomaes Scott $ 500

And January and February do not show up.

Please help me on this and Also the client wants the first group to start from the January corresponding to the Year(date) which is the earliest in the database. till the date which is the latest.



Edited by vipulbhatia29 - 15 Jun 2009 at 1:52am
IP IP Logged
vipulbhatia29
Newbie
Newbie


Joined: 08 May 2009
Location: India
Online Status: Offline
Posts: 10
Quote vipulbhatia29 Replybullet Posted: 15 Jun 2009 at 1:57am

To solve this problem I created a view which contains all the dates starting from year of the earliest date to the ending of the year of the latest date and then outer joined it with the table. This satisfies my purpose. But the client wants an approach which does not fiddle with the database.

Please help me on this if it is possible to do it without creating a view in the oracle database that is if it is possible to handle the groupings in the crystal itself. Personally I can think of no approach.
 
Please alos reply if it is not possible to handle this thing only in crystal.
 
Thanks in advance
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