| Author |
Message |
fsilvabrasil
Groupie
Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
|
  
Topic: Difficulty in creating report for days
Posted: 15 Jan 2014 at 6:44am |
Good afternoon. dear friends
I am having a problem creating a report here on business for days following the example. how is supposed to be. Daily Motion division.
example:
|
|
|
|
DIAS
|
|
DIVISÃO
|
VINCULO
|
QTD.
|
1
|
2
|
3
|
4
|
5
|
11
|
30
|
|
DITEC
|
FUNCIONARIOS
|
8
|
0
|
2
|
1
|
0
|
3
|
2
|
0
|
|
|
EXTRAS
|
7
|
1
|
1
|
3
|
0
|
0
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
RH
|
FUNCIONARIOS
|
1
|
0
|
0
|
0
|
1
|
0
|
0
|
0
|
|
|
EXTRAS
|
5
|
1
|
0
|
0
|
0
|
0
|
4
|
0
|
period when the filter is an example of 01/02/2014 to 06/03/2014 show on day 1 and how many employees were extras were also 2 or 3. until the last day.
|
 IP Logged |
|
|
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
|
Posted: 15 Jan 2014 at 10:25am |
|
I am guessing that you want the days that are missing to appear on the report?
if so, the trick is to join your data to a data source that has all of the days...because Crystal will not 'create' the missing days, you need to include entries into the dataset for every day and then they will all show up.
I don't know of a simple way to do this. It is easier in a stored procedure as compared to just using the data in a table. If you are just using the table, you would need to join the table to a table like a calendar so that every day can be represented.
HTH
|
| IP Logged |
|
fsilvabrasil
Groupie
Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
|
Posted: 17 Jan 2014 at 5:53am |
|
Good afternoon.
Okay, not that he has to complete day be clearer an example will make an appointment at the day 01/01/2014 to 03/02/2014 report. and shows the days following the day starting January 1 until the last day February 3rd.
became more clear to you.
|
| IP Logged |
|
fsilvabrasil
Groupie
Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
|
Posted: 21 Jan 2014 at 1:17am |
|
Hello
Dear friends someone who can help with this doubt.
|
| IP Logged |
|
fsilvabrasil
Groupie
Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
|
Posted: 23 Jan 2014 at 12:26am |
good day
someone to help with this report in Crystal that day appear that way as the picture apareçar day.
![]()
|
| IP Logged |
|
|
|
