Lose Security options in Report manager

I have installed RS on a machine and have deployed several reports. Now when
I go into Report Manager, there is no security settings on the properties tab
- This means I am not allowed to add/edit roles or any security functions at
all. Under the properties tab, i only see a general settings which lists
modified date, modified by, creation date, and created by information for the
report. The security functions used to be there - how do i get them back?
I used the RS.EXE tool to deploy my reports to the server - Could this have
caused my problem somehow? Any help would be appreciated!If you log on from the local machine as a local machine admin you should
always have permission to set security. It is hard to say why you lost your
security, perhaps somebody else came and removed them? Does you script
attempt to modify security?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"PCL" <PCL@.discussions.microsoft.com> wrote in message
news:BD224DBC-8998-45D9-A85A-4A73097C5D2C@.microsoft.com...
>I have installed RS on a machine and have deployed several reports. Now
>when
> I go into Report Manager, there is no security settings on the properties
> tab
> - This means I am not allowed to add/edit roles or any security functions
> at
> all. Under the properties tab, i only see a general settings which lists
> modified date, modified by, creation date, and created by information for
> the
> report. The security functions used to be there - how do i get them back?
> I used the RS.EXE tool to deploy my reports to the server - Could this
> have
> caused my problem somehow? Any help would be appreciated!|||Even when i loginto the local machine as Administrator, the security tabs are
missing. I dont think the RSS file does anything with security - It is a
modified version of the sample scripts that come with RS - we just used them
to deploy our reports.
"Daniel Reib [MSFT]" wrote:
> If you log on from the local machine as a local machine admin you should
> always have permission to set security. It is hard to say why you lost your
> security, perhaps somebody else came and removed them? Does you script
> attempt to modify security?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "PCL" <PCL@.discussions.microsoft.com> wrote in message
> news:BD224DBC-8998-45D9-A85A-4A73097C5D2C@.microsoft.com...
> >I have installed RS on a machine and have deployed several reports. Now
> >when
> > I go into Report Manager, there is no security settings on the properties
> > tab
> > - This means I am not allowed to add/edit roles or any security functions
> > at
> > all. Under the properties tab, i only see a general settings which lists
> > modified date, modified by, creation date, and created by information for
> > the
> > report. The security functions used to be there - how do i get them back?
> >
> > I used the RS.EXE tool to deploy my reports to the server - Could this
> > have
> > caused my problem somehow? Any help would be appreciated!
>
>|||Well if anyone is interested, I got all the security functionality back by
uninstalling and reinstalling reporting services. I tried rerunning my RSS
script and cannot get it to duplicate the problem i was having - Wierd, but i
guess it is fixed...
"PCL" wrote:
> I have installed RS on a machine and have deployed several reports. Now when
> I go into Report Manager, there is no security settings on the properties tab
> - This means I am not allowed to add/edit roles or any security functions at
> all. Under the properties tab, i only see a general settings which lists
> modified date, modified by, creation date, and created by information for the
> report. The security functions used to be there - how do i get them back?
> I used the RS.EXE tool to deploy my reports to the server - Could this have
> caused my problem somehow? Any help would be appreciated!|||Did you tweak the security on the IIS virtual server? If you use anonymous
authentication, you can't publish since it's not authenticating.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"PCL" <PCL@.discussions.microsoft.com> wrote in message
news:BD224DBC-8998-45D9-A85A-4A73097C5D2C@.microsoft.com...
>I have installed RS on a machine and have deployed several reports. Now
>when
> I go into Report Manager, there is no security settings on the properties
> tab
> - This means I am not allowed to add/edit roles or any security functions
> at
> all. Under the properties tab, i only see a general settings which lists
> modified date, modified by, creation date, and created by information for
> the
> report. The security functions used to be there - how do i get them back?
> I used the RS.EXE tool to deploy my reports to the server - Could this
> have
> caused my problem somehow? Any help would be appreciated!

Lookup value for a field?

Using VS2005 and creating reports. GUI has combo boxes with lookups. The
main table is storing the selected.value of the combo box, but the combo box
is displaying the "Name" column.
How do I display the "Name" column value on a report for a field instead of
the integer value of the row?
Thanks.If you look at the different options in the parameter creation window, it's
pretty straightforward.
1) While on the "Data" tab, go to "Report | Report Parameters" in the menu.
2) Click on "Add".
3) Give a meaningful name to your parameter (other than
"Report_Parameter_0")
4) Select a datatype (string, int, etc.). In your case, this would be int.
5) Type a prompt for your parameter (this will appear to the left of your
parameter combobox in the browser).
6) In the "Available Values" section, select "From Query"
7) Select the dataset you will use for your parameter values (typically a
separate dataset from the report's main dataset).
8) Put your key field (the integer value) in the "Value Field" drop down.
9) Preview, Rebuild or redeploy your report and voilà!
HTH,
Alain
"Brooke" <tbrooked@.hotmail.com> wrote in message
news:%23dSGgzfrHHA.5024@.TK2MSFTNGP04.phx.gbl...
> Using VS2005 and creating reports. GUI has combo boxes with lookups. The
> main table is storing the selected.value of the combo box, but the combo
> box is displaying the "Name" column.
> How do I display the "Name" column value on a report for a field instead
> of the integer value of the row?
> Thanks.
>

Looking to add MySQL as a datasource for reports.

I am upgrading my RS server to a windows 2003 server and want to use the
MySQL.dll for .NET.
I know that I am able to add custom data sources to the report designer but
have yet to figure it out.
Can someone point me in the right direction with some very good
documentation?
Thanks
KevinDocumentation on the config files:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_8iqq.asp
This should get you started:
* First, you have to make sure the MySQL data provider is installed
correctly, so that the report designer in VS.NET and report server inside
ASP.NET are able to load the dlls of the data provider at runtime. Note:
there could be file system permissions issues which prevent ASP.NET from
accessing the MySQL data provider dlls. You might want to try to copy the
dlls directly into the
report designer and report server installation directories.
* close all VS.NET sessions before modifying rsReportDesigner.config
* backup the existing rsReportDesigner.config and rsReportServer.config
* read the MySQL documentation to find out the type name for the Connection
object which implements IDbConnection. You will need this information when
changing the config files.
* Add these entries to rsReportDesigner.config in the Data section:
<Extension Name="MySQL" Type="***MySql Connection ClassTypeName***,
***AssemblyName***"/>
... and in the Designer section:
<Extension Name="MySQL"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
* Stop the ReportServer Windows service
* Add this entry to rsReportServer.config in the Data section:
<Extension Name="MySQL" Type="***MySql Connection ClassTypeName***,
***AssemblyName***"/>
* Restart ReportServer Windows service
* Reset IIS/ASP.NET by running iisreset from the command line
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin" <k@.r.com> wrote in message
news:OY1LjSz$EHA.2880@.TK2MSFTNGP14.phx.gbl...
> I am upgrading my RS server to a windows 2003 server and want to use the
> MySQL.dll for .NET.
> I know that I am able to add custom data sources to the report designer
but
> have yet to figure it out.
> Can someone point me in the right direction with some very good
> documentation?
> Thanks
> Kevin
>|||Thanks.
It works great.
I am running into a problem with my defined functions. I built a functions
library and have been using it until now so I know it is configured
correctly. I am attempting to convert my reports over but they all use
functions that I have built and I am getting errors returned from the Report
Designer. "Error in SQL Syntax."
Since the MySQL library does work through the report designer. Should the
functions ability also not work as it did with the ODBC driver? I am not
sure of any settings that I might need to check.
Thanks
Kevin
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23nvQTnz$EHA.2568@.TK2MSFTNGP11.phx.gbl...
> Documentation on the config files:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_8iqq.asp
>
> This should get you started:
> * First, you have to make sure the MySQL data provider is installed
> correctly, so that the report designer in VS.NET and report server inside
> ASP.NET are able to load the dlls of the data provider at runtime. Note:
> there could be file system permissions issues which prevent ASP.NET from
> accessing the MySQL data provider dlls. You might want to try to copy the
> dlls directly into the
> report designer and report server installation directories.
> * close all VS.NET sessions before modifying rsReportDesigner.config
> * backup the existing rsReportDesigner.config and rsReportServer.config
> * read the MySQL documentation to find out the type name for the
> Connection
> object which implements IDbConnection. You will need this information when
> changing the config files.
> * Add these entries to rsReportDesigner.config in the Data section:
> <Extension Name="MySQL" Type="***MySql Connection ClassTypeName***,
> ***AssemblyName***"/>
> ... and in the Designer section:
> <Extension Name="MySQL"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
> * Stop the ReportServer Windows service
> * Add this entry to rsReportServer.config in the Data section:
> <Extension Name="MySQL" Type="***MySql Connection ClassTypeName***,
> ***AssemblyName***"/>
> * Restart ReportServer Windows service
> * Reset IIS/ASP.NET by running iisreset from the command line
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Kevin" <k@.r.com> wrote in message
> news:OY1LjSz$EHA.2880@.TK2MSFTNGP14.phx.gbl...
>> I am upgrading my RS server to a windows 2003 server and want to use the
>> MySQL.dll for .NET.
>> I know that I am able to add custom data sources to the report designer
> but
>> have yet to figure it out.
>> Can someone point me in the right direction with some very good
>> documentation?
>> Thanks
>> Kevin
>>
>
>

Looking for tutorials/walkthroughts on Report parameters

Could someone please point me to a tutorial on how to implement complex
parameters in Reporting Services reports? I ask this because the online help
available seems to be extremely minimal.
What I will probably be doing is writing reports with multiple parameters
including single values, dropdown lists, and calendars. Also I probably will
need to hide/expose/change-value-of some parameters based on the selection of
others.
Any sort of info or even a recognizable starting point to research this
would be of help. Thanks!Sorry. False alarm. Please cancel.
(I should say I found the help for the Report Parameters editing screen
minimal. Finally Googled and found the Technet tutorial on cascading
parameters which is roughly what I was looking for.
However this is all academic because I've just been taken off the project.)
"B. Chernick" wrote:
> Could someone please point me to a tutorial on how to implement complex
> parameters in Reporting Services reports? I ask this because the online help
> available seems to be extremely minimal.
> What I will probably be doing is writing reports with multiple parameters
> including single values, dropdown lists, and calendars. Also I probably will
> need to hide/expose/change-value-of some parameters based on the selection of
> others.
> Any sort of info or even a recognizable starting point to research this
> would be of help. Thanks!