SQL Server Performance Forum – Threads Archive

Set Rectangle Size dynamically

Hello there. T he oringin problem is, there is no Gantt chart in ReportingServices. Now I try to solve that with a subreport. I want to send 2 coordinates (Location.Left and Size.Width). Is it possible to solve that problem using this or another alternative? If yes, how? Thanks in advance, Tobias Boehler

Hi, Have you tried custom code(function) to increase Rectangle L & B Thanks & Regards
Mathivanan K
Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

Hello mkmathi, the only way i tried to solve this, was to set parameter or datafield in the property-panel of the rectangle in different ways. At the moment I don’t know the exact syntax I wrote, but it sounded like that: Location
Left = Fields!Left.Value
Top = X I tried it in some other variatons and always got the error message "wrong unit. must be ‘1pt’ or ‘.0in’" or something like that. What do you mean with function? Like in VB?
Could you give me a sample?
Thanks for answering, Tobias

Hi Tobias, Have you got the solution?.Please let me know the way Manythanks Mathi[<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] Thanks & Regards Mathivanan K Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

Hello mkmathi, in anotohter forum i got this answer: "There is no <easy> dynamic positioning of ReportItems in RDL, they are all at fixed locations. If you are using Reporting Services 2005 then you might be able to create a custom control – but if using Reporting Services 2000 then you may be able to sole the Gantt chart by creating a Reporting Services Custom Extension that you pass your data to, and let it draw the data onto a .NET Graphics control and send back a binary stream of the rendered Graphics control – and consume it within a Reporting Services Image control." This solution is for our requirements to time-consuming so I solved the Gantt chart by abusing a stacked bar chart. I now have a fix date-range of 5 days (thats okay for us). In my StoredProcedure i calculated the minutes to the start time and the duration in minutes. The first stacked bar represents the time to startdate and has the same color like the background (for this you have to install RS.ServicePack1). The second stackted bar is the duration.
So thats it. HTH. Best whishes, Tobi

Tobias Thank you very much for posting [^] Thanks & Regards
Mathivanan K
Great work may have to pass through these stages – ridicule, opposition, and then acceptance. Each man who thinks ahead of his time will probably be greatly misunderstood.- vivekananda

]]>