I'm using CR8 with SQL Server 7 and am trying to use a stored procedure with one parameter, an Analyst name.
Maybe I'm going about this the wrong way but I couldn't find much documentation on the use of sps with SQL Server.
Here's how I'm trying it:
I have an sp defined on sql server and, from ODBC, I add this in as my recordsource.
I add the fields I need to my report but when I run this report, I get the popup dialog box for parameters but it is blank, so I can't filter on the one parameter I want to pass to the sp.
I'd like to know how to add parameters to filter the recordset coming back from SQL Server; specifically, I'd like to add the list of Analysts to the drop down combobox so the user could pass this one value back to the sp, or retrieve the whole report.
I had one option from the Design menu, I think it was, Add Input Parameter, from the Database menu but it was grayed out.
I've seen some reports filter in both the top pane and then in the drop down combo box of the main dialog screen when running a report.
Can anyone help?
Thanks in advance.
Maybe I'm going about this the wrong way but I couldn't find much documentation on the use of sps with SQL Server.
Here's how I'm trying it:
I have an sp defined on sql server and, from ODBC, I add this in as my recordsource.
I add the fields I need to my report but when I run this report, I get the popup dialog box for parameters but it is blank, so I can't filter on the one parameter I want to pass to the sp.
I'd like to know how to add parameters to filter the recordset coming back from SQL Server; specifically, I'd like to add the list of Analysts to the drop down combobox so the user could pass this one value back to the sp, or retrieve the whole report.
I had one option from the Design menu, I think it was, Add Input Parameter, from the Database menu but it was grayed out.
I've seen some reports filter in both the top pane and then in the drop down combo box of the main dialog screen when running a report.
Can anyone help?
Thanks in advance.