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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 X-axis date problem

Author  Topic 

collie
Constraint 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/09
I 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?

Thanks

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.
   

- Advertisement -