I created a command for my report:
select resindstaffinfo.last_name + ', ' + resindstaffinfo.first_name from phsprod.dbo.resindstaffinfo
where resindstaffinfo.is_pract=1
I did not link this command in the Database expert and I am not referencing it in my main report but when I try to run a report it comes back blank when I enter the surgeons name from this command.
My parameter set up looks like this:
Name: Practitioner
Type: String (greyed out)
List of Values: Dynamic
Prompt Group Text: (blank)
Choose a Data Source: Existing (Expr1000 - Prompt Group)
Value: Expr1000 Description: (None) Parameters: ?Practitioner
Value Options - Level 1 (Expr1000)
Prompt Text: Enter Practitioner (Last Name, First)
Sort Order: Ascending by Value
Prompt with Description Only: False
Allow multiple values: True
Allow discrete values: True
Allow range values: False
What did I do wrong or how do I fix it so that my report populates?
Thank you,
Gary
select resindstaffinfo.last_name + ', ' + resindstaffinfo.first_name from phsprod.dbo.resindstaffinfo
where resindstaffinfo.is_pract=1
I did not link this command in the Database expert and I am not referencing it in my main report but when I try to run a report it comes back blank when I enter the surgeons name from this command.
My parameter set up looks like this:
Name: Practitioner
Type: String (greyed out)
List of Values: Dynamic
Prompt Group Text: (blank)
Choose a Data Source: Existing (Expr1000 - Prompt Group)
Value: Expr1000 Description: (None) Parameters: ?Practitioner
Value Options - Level 1 (Expr1000)
Prompt Text: Enter Practitioner (Last Name, First)
Sort Order: Ascending by Value
Prompt with Description Only: False
Allow multiple values: True
Allow discrete values: True
Allow range values: False
What did I do wrong or how do I fix it so that my report populates?
Thank you,
Gary