Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

Sql User Defined Functions

edited July 2007 in DADE
Can Sql Server or Sybase User Defined Functions be used within the data
dictionary?

And what is the best way to implement?

Thanks
Bill Brittain

Comments

  • edited July 2007
    Hi Bill,

    I'm a bit unclear about what you would like to accomplish. Do you need to
    enable the use of UDF's in DADE?

    ReportBuilder does not natively support using UDF's or Stored Procedures
    with DADE. It is my understanding that UDF's are similar to Stored Procs in
    many ways so you would need to create a custom dataview to enable them to be
    properly used in DADE. Take a look at the example provide in the
    \RBuilder\Demos\4. EndUser Databases\SQL Server\2. ADO\StoredProc\...
    directory.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.