how to add two different values on gantt(range bar) chart in SSRS

0
votes

I would like to report like this: I want to show orders for every line and order has setup(yellow) and productıon(green) phase. Setup and Phase widths depends on actual_start_time and actual_end_time.

enter image description here

My query result is like this:

enter image description here

I tried to create report stacked bar, you can see this link: How to design bar chart on SSRS

but if I create like this my report running very slowly.

that's why I try to create report use range (Gantt) chart. report design:

enter image description here

and report preview:

enter image description here

I want to show productıon and setup phase side by side for every order but I couldn't show. Do you give me any suggestıon about this issue?

Thanks.

1
sql-serverreporting-serviceschartsrangegantt-chart
When you say depends do you mean a Functional Dependency or a Conditional Functional Dependency? – Lajos Arpad
I mean Set_Phase's interval should be between SET_ACT_START and SET_ACT_END time. in range bar I used in series properties top_value:SET_ACT_START , bottom_value: SET_ACT_END, category_field:[SP_LINE] – Aylin

1 Answers

0
votes

Try using the Chart Series "CustomAttributes" set to "DrawSideBySide=False".

Click on any of the bars in your chart in design mode and under "General" there is "CustomAttributes". Set the value to "False".