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 |  
                                    | collieConstraint Violating Yak Guru
 
 
                                        400 Posts | 
                                            
                                            |  Posted - 2009-03-16 : 11:41:51 
 |  
                                            | Hi,I have a category group (x-axis) in my report. The x-axis shows dates from the database. User enters 2 dates (date from and date to) and it should show him the data between the 2 dates.However, sometimes the dates shown on the axis jump for example 01/01/09 21/01/09 02/02/09 04/02/09I assume it only shows the dates from the database that have Subjects reported for them.However, the jump from 01/01/09 to 21/09/09 is too big and I want to show dates between them even if they don't have any subjects reported on these dates.How can i customise the dates?ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |  |  
                                |  |  |  |