Skip to Content
Former Member
May 09, 2008 at 04:57 PM

Question regarding sp_name in Crystal Reports


Post Author: jweber

CA Forum: General


First off, I am new to Crystal Reports so please forgive the weird question.

I am trying to replace our proprietary report writing software with Crystal Reports however, the one problem that keeps coming up is how do I use a report function called sp_name or sp_name_first_last or sp_first_party within Crystal.

For example, in my proprietary report writing software manual it states: "Any field that includes ID can be computed to display the full name. For example, party.party_id will return only a number. However, if you compute the name by using the database function sp_name(party.party_id_location), the field will return the party name. So of course I type in sp_name(party.party_id, party.party_id_location) and I run my report and I get the actual party name instead of a bunch of numbers.

Now in Crystal I can't seem to find anything that will allow me to convert those two fields. I've looked all through the formula, sql expression, parameter field entries but I don't see anything that relates to sp_name.

Can anyone help me out on this one?