To start off with you need to edit your report to take off any references to prompt on the GUID. This is in the SQL advanced doc on the link below on page 5:
That you hopefully set you up so you can design the report as you wish from here.
Many thanks that worked a treat .
I'm using CR 11 which had a slightly different way of removing the GUID.
once again many thanks