This is for any Crystal Reports guru’s out there.
I’m creating a report based off of a sql query. If I use the report expert, select my stored procedure, when I select fields, they are all there, however, I want to group by a certain field named “CRName” but it’s not a choice for a field to group by and I can’t figure out why since it’s just a string field.
For a little more background, I already have a report based off this sql query, but we wanted to test a slightly different report so we created a new sql query in a test database that adds a location parameter. The old query works fine, but as soon as I set location to the new stored procedure, it no longer lets me group by that field. Actually, when I set location it tells me that CRName is an unmapped field and wants me to map it to something, but there aren’t any valid choices on the right hand side (even if I remove type match). Again, the queries are the same except the second one adds a location parameter.
Anyone have any idea’s because I’ve looked everywhere I can think of for an answer and just can’t figure out what it’s doing.