srodgers45
asked on
Query in Designer
I am trying to change a number to reference the name that it represents in ssrs query designer, i usually use crystal and am not as familiar with the ssrs queries.
1 = "Sponsored"
2 = "discretionary"
3 = " misc"
etc.........
the field is educationrequest.education
1 = "Sponsored"
2 = "discretionary"
3 = " misc"
etc.........
the field is educationrequest.education
ASKER
the "approved by" field shows a number, i would like the number to represent a name instead
1 = "Joe Smtih" and so on.......
1 = "Joe Smtih" and so on.......
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you saying that for instance, instead of showing ApprovedBy, you would like to show Approved By.
I just used Approved By as an example but is that what you mean?