Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Using Substrings and Stored Procedurs

rbuserrbuser
edited December 2006 in End User
Hi,
Is there a way to use a stored procedure using ReportBuilder?

If not, is there a way to take in a parameter and search using SubString?

eg User enters in 2006 and I want to add a where clause where the
SubStr(Date,1,4) = '2006'(or whatever the user enters).

any help would be much appreciated.

regards,
Andrew Pondaag

Comments

  • nardmoseleynardmoseley
    edited December 2006

    The RB query tools do not currently support using stored procedures. You can
    create a custom dataview that supports stored procedures. An example is
    installed to RBuilder\Demos\4. EndUser Databases\SQL Server\2.
    ADO\StoredProc


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.