FastReports .Net Designer - Data Wizard Stored Procedure Failing to Load

When using the FastReport .Net Designer on the desktop and connecting to a SQL Server data source using the MS SQL connection type, all the tables are loaded fine in the data wizard, however, a very small group of stored procedures load in the Procedures window. It seems to only show functions and the stored procedures with the starting letter 'A' (eg. dbo.a_procedure and not dbo.b_procedure).

Is this a limitation of using trial versions, should I be using one of the other connection types for this SQL Server connection? There doesn't seem to be a lot of documentation on this.

Would appreciate any help.

Comments

  • Hello!

    To resolve the issue when using a stored procedure without waiting for it to appear in the list:

    At the table selection step, click ‘Add SQL query...’ (to add your own SQL query).

    Enter the procedure call manually:

    EXEC dbo.b_procedure @Param1 = @p1

    and, in the next step of the wizard, declare the query parameters @p1 (or pass a ready-made DataTable via report.RegisterData from C#).

This discussion has been closed.