rbh123456789
Technical User
CR 11.5 and SQL Server 2005
I have a Stored Procedure located on our database.
I created a new report, and through the Database Expert, added a 'Command' as:
EXEC [DBO].[GetAvailabity]
@Start_Date = N'2012-09-06',
@End_Date = N'2012-09-07',
@Period = N'AM',
@Name = N'ALL'
The report will indeed bring back data to the report, which is not the issue.
The problem i am having is the fact that i cannot seem to add parameters to the 'Parameter List'.
While i am in the 'Modify Command' mode, and click 'Create', I can enter all the param information.
However, once i click OK, and go back to the Command, the parameter i just created is gone.
Am i missing something? Thanks.
I have a Stored Procedure located on our database.
I created a new report, and through the Database Expert, added a 'Command' as:
EXEC [DBO].[GetAvailabity]
@Start_Date = N'2012-09-06',
@End_Date = N'2012-09-07',
@Period = N'AM',
@Name = N'ALL'
The report will indeed bring back data to the report, which is not the issue.
The problem i am having is the fact that i cannot seem to add parameters to the 'Parameter List'.
While i am in the 'Modify Command' mode, and click 'Create', I can enter all the param information.
However, once i click OK, and go back to the Command, the parameter i just created is gone.
Am i missing something? Thanks.