custom parameter control
Hi all, Is it possible to create a custom parameter control for reporting services 2008? I already found that you can extend reporting services with Custom Report Items (CRI), as you can see in the next link: http://msdn.microsoft.com/en-us/library/ms345231.aspx But I believe that this is only for report items, that is items in the body. I would like to create a parameter control. Is it possible? Kind regards, Stefan
April 7th, 2010 3:03am

You can create your own custom page using ASP.net and then use the reportviewer class to pass the parameters and display the reportCheers, Jason My Blog P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2010 4:58am

Hi Jason, thank you for your response. And how can you deploy this? Can you just upload the .aspx page to the ReportServer website and call that page as you would call a normal report? Regards, Stefan
April 7th, 2010 5:04am

Yeah, it would be just like the normal aspx pages you develop. Also, the report should be deployed because you are just calling the report from your aspx page.Cheers, Jason My Blog P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2010 6:14am

Ah wait, there might be a misunderstanding. You see I normally don't develop any aspx pages at all, I don't even have a web site project. I only have a report server project; which is a business intelligence project. This project contains only .RDL reports that can be uploaded to reporting services. So when you said to create a web page I assumed that this would be a new web site project containing only that page, and that that page has to be uploaded and integrated to the other reporting services files. I mean such as you normally do with data sources, reports and report models by using the reportservice2005.asmx web service or by using BIDS when still developing. Are we talking about the same thing here?
April 7th, 2010 6:32am

If you are just working with BIDS and don't have any option to use Visual Studio, then I guess you are stuck with the default parameter controls that BIDS gives :(Cheers, Jason My Blog P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2010 7:01am

I do have Visual Studio on a different machine, that's not a problem. It's just that I'm not hosting the reports in my own web application, but in the default reporting services web site. (which is http://localhost/Reports/Pages/Folder.aspx by default) It's just that classic web pages work with virtual directories in IIS and reporting services doesn't. So if I create a new virtual directory and put my custom web page there, reporting services won't know about those files and won't show them in the menu. At least I think so. So if I want to deploy my custom web page, how do I add it to the reporting services web page? Do I just upload it with the reportservice2005.asmx web service? Thanks for helping.
April 7th, 2010 7:25am

I have the same kind of need...we need some MSFT help here.Doyle
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2010 5:15pm

Hi Stefan, The solution is creating your own web site as Jason mentioned (using custom web site to integrate reportserver not using report manager to integrate custom web site). Report Manager is a website to retrieval the report from the reportserver and then display report in Report Manager. But you cannot modify this website to create your own parameter pane. You can simply deploy the report to the report server, use reportviewer to access report from the server, and then display the report in your custom web site with your own parameter pane. In other words, your web site only contain a parameter pane and a reportviewer, pass the parameter to the reportviewer and use reportviewer to retrieval report from the server: http://msdn.microsoft.com/en-us/library/ms252075(v=VS.80).aspx Otherwise, as I know, you can only change some front or the color of the report manager like this: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/e51d7a1b-83e4-4c8c-99c7-0607d3a02917 Or create your own parameter pane in your report like this: http://sperm.codeplex.com/ http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/add02ccb-701f-4fbe-bf55-73a75a971e18 Hope this helps, Raymond
April 13th, 2010 5:58am

Ok, thanks a lot for clearing that up. Although I have to admit I don't like the idea of having to create an entire new web application just to host reports with slightly enhanced parameter controls. This will introduce a whole new set of questions. Such as, can I still use SSRS security or will I have to code that myself too? Can I combine the reporting services web page with my own web page? For our customers need to create their own reports using report models as well. Can I still use subscriptions? etc. etc. etc. I will have to investigate this further. But at least my previous question has been answered! Kind regards, Stefan
Free Windows Admin Tool Kit Click here and download it now
April 13th, 2010 7:19am

Hi Stefan, Did you ever find a solution to customizing the parameter block?
September 7th, 2012 3:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics