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.
This discussion has been closed.
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 = @p1and, in the next step of the wizard, declare the query parameters @p1 (or pass a ready-made DataTable via report.RegisterData from C#).