Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Month range Post Reply Post New Topic
Author Message
mahe416
Newbie
Newbie


Joined: 11 May 2010
Online Status: Offline
Posts: 3
Quote mahe416 Replybullet Topic: Month range
     Posted: 08 Jul 2010 at 9:34pm
Hi All,
 
I have a query... In crystal reports.
ie; I have created a cross tab using Month name in row wise and employeename in column wise.
 
the report is running perfectly but
 
If i create a parameter for month range iam getting the order of month in Alphabetic order.\\\
 
for ex: If i give range from April to december. its showing only April, August and December.
 
 
plz give me some idea...
 
plz give the seps how to create areport.
 
 
with regards,
 
Mahesh
 
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 09 Jul 2010 at 10:08pm
work-around...
 
create a formula (xMonth):
if month({tbl.datefield})<10 then
     "0"+totext(month({tbl.datefield}),0) + " "+monthname(month({tbl.datefield}))
else
   totext(month({tbl.datefield}),0) + " "+monthname(month({tbl.datefield}))
 
and put this formula as row in your crosstab.
so it will print as "01 January", "02 February", ..., "12 December".
 
 
 
hope it help.
 


Edited by Emir_W - 09 Jul 2010 at 10:09pm
Emir W
IP IP Logged
mahe416
Newbie
Newbie


Joined: 11 May 2010
Online Status: Offline
Posts: 3
Quote mahe416 Replybullet Posted: 11 Jul 2010 at 6:46pm
Hi Sir,
 
Thanks for ur reply,
Sir I am not having the date field in our tables...
 
We r having only Month NAme, MOnth, Quater, Year.
 
so is there anyother idea...
 
with regards,
Mahesh
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 11 Jul 2010 at 7:43pm
in this case change the formula that I gave as:
if your_Month<10 then
     "0"+totext(your_Month,0) + " "+your_MonthName
else
   totext(your_Month,0) + " "+your_MonthName
 
and put this formula as row in your crosstab.
so it will print as "01 January", "02 February", ..., "12 December".
 
 
hope it help.
 
Emir W
IP IP Logged
Alexander
Newbie
Newbie


Joined: 10 Jan 2012
Online Status: Offline
Posts: 12
Quote Alexander Replybullet Posted: 10 Jan 2012 at 7:27pm

Sir,

I have monthwise report when m giving date Range from Oct-2011 to till date so it is taking full month for oct, nov, dec & 10 days for jan as today is 10th of jan. s what i want is it should come 1 to 10th of each month not the full month.
 
Regards
Kalim
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.