SQL Reporting: Display All Recurring Appointments

41 posts, 2 answers
  1. Plamen
    Admin
    Plamen avatar
    2729 posts

    Posted 20 Jan Link to this post

    Hi,

    The solution should work correctly as long as the CLR integration is possible in the environment. Yet I would rather recommend you to refer to some more specific Azure related forum regarding this possibility in your case.

    Regards,
    Plamen
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  2. Denis Buchwald
    Denis Buchwald avatar
    28 posts
    Member since:
    Apr 2010

    Posted 22 Feb in reply to Plamen Link to this post

    Hello Plamen,

     

    I have also found what I believe is a bug in the SQL UDF. When I try to parse daily events that have an interval value they return an event for everyday instead of using the interval value.

     

    For example:

    SELECT * FROM ExpandRecurrence('DTSTART:20151021T080000Z' + Char(10) + 'DTEND:20151021T090000Z' + Char(10) + 'RRULE:FREQ=DAILY;INTERVAL=2', '12/01/2015', '12/10/2015')

     

    This will return an event for every day from Dec 1 to Dec 9. Is this a bug and how can I resolve it?

     

    Thank you,

  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Plamen
    Admin
    Plamen avatar
    2729 posts

    Posted 25 Feb Link to this post

    Hello,

    The Telerik.Web.UI.RecurrenceEngine.dll that is used in the Code Library is using quite an old version of our controls so you may try to build it from the source code with a newer version in case the issue is already fixed. If you still reproduce it with some recurrence rule in RadScheduler with the latest version of the controls  please let us know so we could inspect the issue and be more helpful.

    Regards,
    Plamen
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  5. Denis Buchwald
    Denis Buchwald avatar
    28 posts
    Member since:
    Apr 2010

    Posted 25 Feb in reply to Plamen Link to this post

    Hello,

    Is it possible you could post an updated copy of the DLL? I'm just working on it from the SQL side so I could swap out the DLL used in the function.

  6. Plamen
    Admin
    Plamen avatar
    2729 posts

    Posted 26 Feb Link to this post

    Hi,

    I have created a newer version of the Telerik.Web.UI.RecurrenceEngine.dll and am attaching it here. 

    Please let me know if you still observe the issue.

    Regards,
    Plamen
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  7. Denis Buchwald
    Denis Buchwald avatar
    28 posts
    Member since:
    Apr 2010

    Posted 26 Feb in reply to Plamen Link to this post

    Thank you! Unfortunately I'm unable to bring that into my SQL server installation. It is giving an error that the dll is not valid. I think it might have been compiled using .net 4.5 where SQL 2012 CLR typically stops at 4.0.

    Sorry to be a pain but would it be possible to recompile the DLL for me for SQL 2012/.net 4.0?

    Thank you again!

  8. Plamen
    Admin
    Plamen avatar
    2729 posts

    Posted 29 Feb Link to this post

    Hi,

    I am attaching the 4.0 version.

    Regards,
    Plamen
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  9. Denis Buchwald
    Denis Buchwald avatar
    28 posts
    Member since:
    Apr 2010

    Posted 29 Feb in reply to Plamen Link to this post

    Good day!

    Again thank you for your prompt service and assistance! I hate to be a pain but I'm still getting an error and I believe it's on the recurrence engine DLL side. I get the following:

     

    A .NET Framework error occurred during execution of user-defined routine or aggregate "ExpandRecurrence":
    System.TypeLoadException: Inheritance security rules violated while overriding member: 'Telerik.Web.UI.RecurrenceRule.GetObjectData(System.Runtime.Serialization.SerializationInfo, System.Runtime.Serialization.StreamingContext)'. Security accessibility of the overriding method must match the security accessibility of the method being overriden.
    System.TypeLoadException:
       at UserDefinedFunctions.ExpandRecurrence(String recurrenceRule, SqlDateTime rangeStart, SqlDateTime rangeEnd)
    .

    I believe this is related to the GetObjectData override in the dll not having correct security permissions? A quick google search offered some quick solutions but I'm no expert.

     

    Any suggestions?

    Thank you,

  10. Plamen
    Admin
    Plamen avatar
    2729 posts

    Posted 03 Mar Link to this post

    Hi,

    Please excuse me for this inconvenience. I have inspected the issue once again and have attached here the update dll.

    As for the issue it seems to be caused by the fact that when using such recurrence rule with daily frequency and interval 2 the rule that is generated and used by RadScheduler is a bit different:
     
    SELECT * FROM ExpandRecurrence('DTSTART:20151021T080000Z' + Char(10) + 'DTEND:20151021T090000Z' + Char(10) + 'RRULE:FREQ=DAILY;INTERVAL=2;BYDAY=MO,TU,WE,TH,FR,SA,SU', '12/01/2015', '12/10/2015')

    Hope this will explain the issue. 

    Regards,
    Plamen
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  11. Chinedu Opara
    Chinedu Opara avatar
    1 posts
    Member since:
    Feb 2005

    Posted 12 Sep in reply to Plamen Link to this post

    Hi,

    My client is working on all SQL Server 2008 R2, which as you know is locked to .Net Framework 2.0. Would it be possible to post a version of this ExpandRecurrence DLL compiled under Framework 2.0? Please? It would be a massive lifesaver for us. Thank you so much.

  12. Plamen
    Admin
    Plamen avatar
    2729 posts

    Posted 15 Sep Link to this post

    Hello,

    I am attaching a .net 2 dll that worked correctly at my side. Unfortunately it does not support timezones because they are depending on some .NET 3.5 only dlls.

    Hope this will be helpful.

    Regards,
    Plamen
    Telerik by Progress
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017