Question regarding sp_name in Crystal Reports

[Former Member]

Post Author: jweber

CA Forum: General

Hello,

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?

[Former Member]

Post Author: sharonmtowler

CA Forum: General

is that what you are asking? how to display the data in the report?

you want to use a stored procedure for your dataset correct?

the fields should be in the sp. you need to connect to the dataset and if there is a field called in the sp you should be able to insert that into the report.

you should reference a user guide to start the report creation. or use the wizard it will take you through the steps.