0

I use VS2012 to develop reports. I have a report that has 4 parameters. Each of those parameters has a dataset associated with it. When I run the report in VS2012 Preview it works fine. After I have uploaded it to the server using a web framework it leaves any parameter using a dataset off the report entirely. So my assumption is that something is missing on the .aspx side that recognizes those parameter datasets...if it is even possible. Any direction/assistance appreciated. Thanks

SSM
  • 1
  • How do you know its doing this? Does it not ask for parameter values when you run the report, or does it not apply the parameter values you select? The only way to know for sure is to profile the SQL and see if it is applying parameters or not. – Nick.Mc Nov 18 '16 at 03:08
  • When I open the URL, the object, in this case, a parameter dropdown associated with a dataset doesn't even display on the screen. Where as other non-dataset parameters do. I had forgotten to check profiler; I will need to verify. Thanks. – SSM Nov 18 '16 at 11:51
  • In the report viewer control in your aspx page. There is a property called ShowParameterPrompt. Set that to True. – SS_DBA Nov 18 '16 at 14:52
  • Apologies for getting back so late. I did run the SQL profiler and the dropdown associated with a dataset does not show in profiler. Regarding the ShowParameterPrompt would that be placed within a tag like below? – SSM Dec 12 '16 at 12:04

0 Answers0