First, I would guess that plenty use stored procs. I only use stored procs, and have since the day I learned Crystal back in Crystal 7.
As to your second question, I don't know what Lawson's dashboard is, but the basic question is if you change a stored procs name how do you modify the report to respond to this.
I haven't tried it, but this is the path that I would explore. In Database/St Datasource Location, I would go the database that has your stored proc, drill down to the new stored proc, highlight it (on the bottom half), highlight the report stored proc in the top half and hit 'Update'.
Hopefully this will work, as rewriting a report tends to be a pain. I usually have to do something similar when I change recordset layout as I use XML to set the datasource in my reports.
I hope this helps, and you are not alone using stored procs...it really is the most flexible way to go IMHO.
IP Logged
