Problemdescription: In the data the Product "Soundcard" should not be in the category "PC", it should be the category "Hardware". Prefered Solution: Change the Category for the Productname = 'Soundcard" to the Category = 'Hardware' and not PC. This should be done within the skript.
I have attached an .qvw file, please use it for the solutions.
Thanks for both solutions from Hugues and Sparur, the one from Hugues with the export into a .qvd file works fine for me and is also fast.
The other from Sparur, works also, but only in my example application, because in my real application I have to change the catagory after the first load, there are some Joins between before I get to the Category field.
But thanks for both solutions and helping me so quick.