Hello
Crystal reports 8
SQl Server 2000
My database location points to a View which is used to bring in the data. This works.
I now created a stored procedure with a parameter.
I used Set LOcation to point from the View to the stored procedure with the parameter.
After "setting the location", I receive the error:
"Error Opening File. There are no fields in the "name_stored_procedure" "
To test this, I started out with a new report, saved with view and then reloaded and tried to point to stored procedure with a parameter using Set LOcation. Error Occurs.
Is there a way to replace the View with a Stored Procedure with a parameter or is there a easy work arround.
Thanks
Crystal reports 8
SQl Server 2000
My database location points to a View which is used to bring in the data. This works.
I now created a stored procedure with a parameter.
I used Set LOcation to point from the View to the stored procedure with the parameter.
After "setting the location", I receive the error:
"Error Opening File. There are no fields in the "name_stored_procedure" "
To test this, I started out with a new report, saved with view and then reloaded and tried to point to stored procedure with a parameter using Set LOcation. Error Occurs.
Is there a way to replace the View with a Stored Procedure with a parameter or is there a easy work arround.
Thanks