Visual Studio Bug? Adding a dataset parameter doesn't add a report parameter in Visual Studio 2008 SSRS

Question

Hello,

I apologize if this isn't in the right forum, however when using Visual Studio BIDs 2008 to create SSRS reports, I keep running into an issue.  I'll go to a dataset, open up the query designer, add a new parameter, then refresh the fields, but the parameter won't be added as a report parameter.  If I go to the dataset properties under the list of parameters, the value in the dropdown will be blank.  However, sometimes this will automatically add. 


Is this a bug in Visual Studio?  How do I get around this? 

Answer 1

Hi mnav2015,

According to your description, when you add a new parameter in dataset query, the parameter doesn’t generate automatically in report parameters.

In Reporting Service, when we define a dataset query that contains a query variable, the query command is parsed. For each query variable, a corresponding dataset parameter and report parameter are created automatically. As we tested in Visual Studio 2008, the query designer contains the query, after refreshing the fields, the corresponding report parameter will display automatically.

So in your scenario, I would like to know how about your query with the parameter. If possible, please provide some screenshots of results before and after you add a new parameter in dataset query.

Reference:
How to: Associate a Query Parameter with a Report Parameter

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support

Answer 2

The parameters in datasets are based on what you define in the query. The SSRS creates the parameters automatically based on what you've defined and used in the query.

In case you need to add an additional parameter yourselves you've to add it manually and map it to relevant dataset field or in filter. But please keep in mind that if you refresh the dataset again then it will try to map parameters based on what is in the query definition. So your parameter will not get auto mapped. You have go ahead and do manual mapping yourself.

It also depends on the name of the parameter ie say your query has parameter name used as @Param1 and when you refreshed it created the report parameter as Param1. Now suppose if you go and rename the report parameter as Parameter1 and then go and refresh dataset it will lose the mapping and then you have to go and remap the parameter again as the name has now changed.

---

Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page