SQL Server Performance

Set Rectangle Size dynamically

Discussion in 'SQL Server Reporting Services' started by Tobias Boehler, Jan 20, 2006.

  1. Tobias Boehler New Member

    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
  2. mkmathi New Member

    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

  3. Tobias Boehler New Member

    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
  4. mkmathi New Member

    Hi Tobias,<br />Have you got the solution?.Please let me know the way<br />Manythanks<br />Mathi[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Thanks & Regards<br />Mathivanan K<br /> 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<br /><br />
  5. Tobias Boehler New Member

    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
  6. mkmathi New Member

    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

Share This Page