Has anyone customized the parameters area to pretty it up and make it more configurable like control number of columns etc?
Or can anyone direct me to a third party component?
Thanks.
I'm attempting to do this as well. I have a lot of params for a storedProc call and want to format it so the area isn't so large. Anyone figure this out yet?|||Here's another post which may be able to help you.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=409942&SiteID=1
Jarret
sqlHas anyone customized the parameters area to pretty it up and make it more configurable like control number of columns etc?
Or can anyone direct me to a third party component?
Thanks.
I'm attempting to do this as well. I have a lot of params for a storedProc call and want to format it so the area isn't so large. Anyone figure this out yet?|||Here's another post which may be able to help you.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=409942&SiteID=1
Jarret
Hi,
I am creating a report using matrix. The reporting services subtotal, sums up the data on all rows. The data in rows contains numeric & percentage values. I need the total for numeric value as sum and for percentage values as weighted average. Does anyone know how to do this or is this limitation of RS. Thanks.
You mean you want to have different calculation done in the subtotal as oppose to the one used in detail cells? If so, you can use the InScope function to do it. http://msdn2.microsoft.com/en-us/library/ms156490.aspxsqlHello. I have a version of SQL Express with Advanced services. I created a report and all seems well in Report Manager on my computer. 
1. Can I create an application in Visual Studios Express to view my report? I've read things online that seem contradictory to me and I'm hoping you can clarify this.
2. On a customer machine, if they have a .net application that can render my report, will they have to install reporting services on their computer or can the .rdl file run independently of reporting services if plugged into a .net viewer component? If it was called from a .net application, then Report Server and Report Manager aren't really needed are they? I have a situation where we don't want to use IIS on customer computers if we don't need to. Since the reports will not be adhoc, we're hoping to avoid needing to install Reporting Services on customer computers.
Thanks!
Debbie Erickson
Not sure on #1.
On #2, you should be able to render the report through the ReportViewer control, which removes the need for the Report Server and Report Manager (and IIS), as it handles the report rendering.
Hi,
I'm having a lot of trouble trying to set up a custom security extension with Reporting Services 2005. Following the VB example from McGraw Hill Osborne (http://www.mhprofessional.com/product.php?cat=112&isbn=0072262397&cat=112), I've compiled the .dll for the extension and made the changes to the ReportManager and ReportServer .config files. After I reset IIS and return to the RS website, it displays "The report server has encountered a configuration error..." and I get a message in my System Event log:
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user MYMACHINE\ASPNET SID (S-1-5-21-1708537768-839522115-1343024091-1005). This security permission can be modified using the Component Services administrative tool.
Wondering if anyone else has had similar trouble and how did they get around it?
Have you modified the RSSrvPolicy.config ?
Here is a guide I followed to successfully implement custom authentication in RS.
http://msdn2.microsoft.com/en-us/library/ms160724.aspx
Look at the section "To modify the RSSrvPolicy.config file"
Regards Andreas|||
Here are the changes I made to .config files before running Reporting Services and getting these errors:
Under the ReportManager directory:
rsmgrpolicy.config - MyComputer code group permission from Execution to FullTrust
rsWebApplication.config - modified <UI> entry, added redirection to login page + URL
Web.config - identify impersonate -> "false"
Under the ReportServer dierctory:
RSReportServer.config - Added <Extension> elements with Name ="Forms" inside both <Security> and <Authentication>
rssvrpolicy.config - added new <CodeGroup> block just under CodeGroup with "$CodeGen$" string
web.config - identify impersonate -> "false"
sqlI've created a Reporting Service security extension based on the sample. It works great on my development 2003 servers but when moved into integration environment I am getting the following error in Report Manager when clicking a report:
Could not load file or assembly 'Microsoft.ReportingServices.ProcessingObjectModel, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.
Navigating folders and creating folders all seems to work in Report Manager. We only get this error when selecting a report. If I uninstall the custom security extension then everything works.
This seems like a difference in security settings between the two server but I'm not sure how to troubleshoot it.
Thanks
William
William
I had a similar problem and it was due to the fact that the user account of the SQL Server Reporting Services (MSSQLSERVER) service did not have access to the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files directory. It needs Modify access. Once I changed that, it worked fine.
Good luck
|||Thanks.
I had to add modify permissions on C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files to the Execution Account I specified in Reporting Services Configuration Manager. This is because I ran a report with a local datasource (with dynamic connectionstring) with setting "Credentials are not required".
Pierre
I've created a Reporting Service security extension based on the sample. It works great on my development 2003 servers but when moved into integration environment I am getting the following error in Report Manager when clicking a report:
Could not load file or assembly 'Microsoft.ReportingServices.ProcessingObjectModel, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.
Navigating folders and creating folders all seems to work in Report Manager. We only get this error when selecting a report. If I uninstall the custom security extension then everything works.
This seems like a difference in security settings between the two server but I'm not sure how to troubleshoot it.
Thanks
William
William
I had a similar problem and it was due to the fact that the user account of the SQL Server Reporting Services (MSSQLSERVER) service did not have access to the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files directory. It needs Modify access. Once I changed that, it worked fine.
Good luck
|||Thanks.
I had to add modify permissions on C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files to the Execution Account I specified in Reporting Services Configuration Manager. This is because I ran a report with a local datasource (with dynamic connectionstring) with setting "Credentials are not required".
Pierre
I've created a Reporting Service security extension based on the sample. It works great on my development 2003 servers but when moved into integration environment I am getting the following error in Report Manager when clicking a report:
Could not load file or assembly 'Microsoft.ReportingServices.ProcessingObjectModel, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.
Navigating folders and creating folders all seems to work in Report Manager. We only get this error when selecting a report. If I uninstall the custom security extension then everything works.
This seems like a difference in security settings between the two server but I'm not sure how to troubleshoot it.
Thanks
William
William
I had a similar problem and it was due to the fact that the user account of the SQL Server Reporting Services (MSSQLSERVER) service did not have access to the C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files directory. It needs Modify access. Once I changed that, it worked fine.
Good luck
|||Thanks.
I had to add modify permissions on C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files to the Execution Account I specified in Reporting Services Configuration Manager. This is because I ran a report with a local datasource (with dynamic connectionstring) with setting "Credentials are not required".
Pierre
