Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
A Bhima Reddy
Starting Member
2 Posts |
 Posted - 2008-06-04 : 06:10:40
|
| the specific report which iam designing looks like this..i have two fields Start time and end time . iam grouping by month using start date.my problem starts ..for eg. it happens that few records have start time on 28/may/2008 and end time on 3/june/2008.now i want this particular record to be displayed both in May and June Group. can any one help.... |
|
|
Johnho008
Starting Member
24 Posts |
Posted - 2008-06-04 : 06:35:53
|
| What the critria for these few records? ie if record start time = last day of the month ? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 07:01:51
|
| Can you illustrate you requirement with your sample data? WHy do you want to double count the records? |
|
|
|
A Bhima Reddy
Starting Member
2 Posts |
Posted - 2008-06-04 : 09:08:10
|
| i am working with Preactor its a scheduling software .iam designing a report for getting "Machine Load" month wise. an order on a machine will be starting in this month and ends in next month.for example a order is starting on 29/5/08 and ending on 5/6/08 . since iam designing month wise load chart..i want to see this record in both May and June . further i will be calculating actual load based on number days in the particular month. |
|
|
|
|
|
|
Having a one redord in two groups in reports