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.aspxsqlCustomer Profitability
Hi How can I use MS SQL server 2005 analysis services for measuring the Customer Profitability Index
Pl suggest if you have any Data model and any special algorithm that can be used to measure the Customer Profitability
Thanks In Advance
Rajesh Ladda
Analysis Services is a product that serves as a platform for your analytical applications. Using Analysis Services you are able to model complex business rules of your organization.
Your question is a bit vague. If you are looking for examples of how to build multidimensional model and then use it to analyze your data, I suggest you first start from going through tutorial that comes with Analysis Services installation. Then take a look at the sample project: AdventureWorks and see how it implements calculations.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Hello. I have a version of SQL Express with Advanced services. I created a report and all seems well in Report Manager on my computer. 
Now it's time to deploy my report to some customers.
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.
Is there anything equivalent for SQL Server?
I also posted this here, but got no response so thought I'd check in the security forum.
I'm not sure that there is a property which is exactly suited for passing custom user data, but there is a property which you might modify without affecting pretty much anything else.
The property is "Application Name" (SSPROP_INIT_APPNAME).
|||I see where you're going with that, but is there a SQL function to detect the application name from the connection string of the currently connected person?
|||Hi,
What you can do to get the application name provided in the property is to run a statement like this:
select program_name from master..sysprocesses where spid=@.@.spid
HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Is there anything equivalent for SQL Server?
I also posted this here, but got no response so thought I'd check in the security forum.
I'm not sure that there is a property which is exactly suited for passing custom user data, but there is a property which you might modify without affecting pretty much anything else.
The property is "Application Name" (SSPROP_INIT_APPNAME).
|||I see where you're going with that, but is there a SQL function to detect the application name from the connection string of the currently connected person?
|||Hi,
What you can do to get the application name provided in the property is to run a statement like this:
select program_name from master..sysprocesses where spid=@.@.spid
HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.
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 wonder if someone may be able to help. I have had a request to output a report from Reporting Services 2005 as a Pipe delimited file. I know it is possible to create custom renderers but I'm not sure how this is done. I've read http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/ but I don't have much experience of VB.Net.
Any help would be much appreciated
Thanks
Adam
Hello, you can use the existing CSV renderer to export a pipe delimited file. You can use the FieldDelimiter DeviceInfo parameter to change the delimiter character:
http://msdn2.microsoft.com/en-us/library/ms155365.aspx
-Chris
