Skip to Content
0
Former Member
Oct 29, 2012 at 01:32 PM

SQL Stored Procedure Column does not appear in Crystal Field Explorer

262 Views

Greetings...

I have a Crystal Report that is fed by a SQL Stored Procedure. I want to group and sort this Report by Company Name (CompName is a column in my SQL output). However, this column does not show up in the Group, Sort, for Field Explorer lists. If I put a textbox on the report using the Company Name, it prints just fine, so clearly the report knows this is a valid field, but I cant group or sort with it since it does not appear in either list.

Ive tried re-jiggering the output with no success - in fact, seems anything I do to the Stored Procedure itself works fine - that is, the report gets re-verified and knows the SQL Stored Procedure has changed, but I still cannot get to the Company Name I want.

When I use the "Find Field' box in the Report Designer and type in "CompName", the result is "huh? what?" as though Crystal has never heard of the field, but again, if I put the field on the report, it sees it, it outputs the data correctly, in fact, everything seems to look just fine - but I just cant get that field into the lists I need to group and order my report.

Is there a way anyone can suggest that I might fix this glitch?

Thanks!