I was very enthousiastic when I saw your query, yesterday I had a problem that could have been prevented, but it does not work.
Create a table and a stored procedure:
CREATE TABLE [dbo].[Demo](
[Street] [varchar](50) NULL
) ON [PRIMARY]
CREATE PROCEDURE [dbo].[ProcDemo]
@Street VARCHAR(50)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO [Demo] (
[Street]
) VALUES (
/* Street - varchar(50) */ @Street )
END
Now rename the column Street in the table and try your report, no error at all...........