*BUMP* I get the same issue. Without a parameter I get the fields returned in the report designer. When I add th e? in the query for the parameter then assign the parameter in the right place in the dataset the fields disappear.
Why no one answer this serious problem for a long time? I got the same problem and I posted several times here but no answer until now. I am awaiting a key someone to solve our problems. If there are some bugs, let me know, please!
Hello everyone !!
As you guys, I've faced this issu many times ! When you add a parameter in a query in a dataset, all the data fields disappear.
For information, if you add manually the retreived fields, it works !! but it's very annoying when you have lots of fields...
So here the trick : you need to avoid the SQL query evaluation/test with the parameter. Indeed, when the report engine try to test the SQL query, it failed and that's why it can't retreive the data fields.
To do that :
- In the DataSet > Query - click on the "Fx" button to open the Expression Editor dialogue box.
- In this box, modify and add the parameter (?)
- Validate the change by clicking "OK" button
- Validate adgain by clicking Accept (DO NOT click on the Check button !!!!)
With this method the retreive data field should not disappear !!!
That's all !!