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 |
|
MilosDad
Starting Member
1 Post |
 Posted - 2012-05-16 : 12:10:54
|
| I know this may seem strange, but let me explain. I'm trying to produce a pseudo-gantt chart using a horizontal stacked bar chart. Normally I'd use a range chart for a Gantt, but we need to have multiple bars on the same "row" (which I can't seem to do with the range).So here's a simplified explanation. My query simply returns the following:Project name,Stage Gate Name,Start Date,DurationOrderIndex (1-?)The idea is that each stage gate has a different color in the same overall bar. The length of each of these segments (series) is determined by their duration. There are no gaps or overlaps between stages.So far this works great - the bars look exactly as they should, however I can't seem to figure out how to get Report Builder to format the horizontal (value) axis labels to show the date. Since the durations are in months and I know the start of the range (parameter) I should be able to say that the value axis value of 1, for example, is dateadd(mm, 1, @range_start). But I can't figure out how to make the label a date representation of the number of months from the parameter value.Any ideas?Thanks,--Robert |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Format Value Axis Number as Date