Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Possible to do Month Param? Post Reply Post New Topic
Author Message
hugo69
Groupie
Groupie


Joined: 15 Feb 2010
Online Status: Offline
Posts: 53
Quote hugo69 Replybullet Topic: Possible to do Month Param?
    Posted: 01 Mar 2010 at 1:16pm

I have this report that DBlank helped me on that has a date param to count the inmates in Jail. Now that I have set up this report with the date param it gives me that date of counts. Is there any way to setup the report to do a Month Param and give me all the counts per day in a table, from the report already setup or somethingelse?

Something like?
 
Month = March 2010
 
Day     Total       Male    Female     EMP
1           65           60         5             3
2           64           59         5             3
and so on....
 
I already can pull the information per the date param report already made. 


Edited by hugo69 - 01 Mar 2010 at 1:17pm
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 02 Mar 2010 at 11:47am
I would think so. You would want to enter the month, and then, I don't know how DBlank did it, but you would want to filter out records where the MONTH() and YEAR() of the datefield that don't match.  The rest of the report would be pretty much the same as what you already have, I suspect, you would probably add a group based on the date or DAY() of the datefield.
 
It's just a guess.  I'm sure the DBlank can give a more complete answer, but that is my quess as to how you would proceed.
 
HTH
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.