Showing posts with label public. Show all posts
Showing posts with label public. Show all posts

Friday, March 9, 2012

ReportParameter.ValidValues

lfarr...@.setfocus.com Jan 12, 8:28 pm show options

Newsgroups: microsoft.public.sqlserver.reportingsvcs
From: lfarr...@.setfocus.com - Find messages by this author
Date: 12 Jan 2005 20:28:28 -0800
Local: Wed, Jan 12 2005 8:28 pm
Subject: ReportParameter.ValidValues
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

I have been assigned to create a new report subscription form. I have
done everything but prompt the user for values. So there are a bunch
of reports with varied parameters. Some of these parameters are
hard-coded lists and others are DataSetReference. How do I provide the
subscriber with an accurate list of valid values?

I was thinking something like:
ReportParameters[0].reportParameter.ValidValues
but that comes back null.

I tried reportService.GetReportParameters(report, historyID,
forRendering, values, credentials)
Values comes back null.

Please help!

Thank you!

--Larry--Thanks to Daniel Dieb, I fixed my problem. He commented on a similar
post:

If ForRendering has a value of false, the parameter meta data returned
represents the parameter data that is currently associated with the
specified report. If any parameters values are based on a query and you
are
interested in returning the query-based parameters valid values list,
you
need to set ForRendering to true, In addition, for query based
parameters,
you need to ensure that you have passed in all of the credential
information
required to return the query parameters.
I set this parm to true and got my values!!

Wednesday, March 7, 2012

ReportingServices - global access problem.

Hi, experts.
I have a strange problem with accessing Analysis Services from
Reporting
Services.
Our client needs to public reports in the web site and to make them
accessible for everybody. In order to achieve it, I did the following:
1. In IIS I put the anonymous access for the virtual directory
ReportServer. (the user IWAM_hostname)
2. I granted the explorer right to the user IWAM_hostname from the web
application that permits the reports to be managed.
3. In the same application I changed the credentials for the dataset
that pointed to analysis services. I chose the "stored credentials"
(the user I specified had access rights in the corresponding cube).
Once the configuration was established, I tried to access our reports
via web. I could see reporting services interface but it was not
possible to view the data from analysis services. There was an error:
"dimension not known."
Seeing this, I decided to give analysis services rights for the
IWAM_hostname user, but it brought the same result.
When I changed the configuration of Report Server virtual directory
(instead of anonymous access, I put the windows authorization again),
everything worked fine.
I have an impression that credentials specified in the web application
are ignored.
The question is, which user is used to access the Analysis Services
from the Reporting Services when the anonymous user is set in the IIS
ReportServer directory.
All relevant information will be appreciated.
One more thing: Reporting Services has the servicepack 1 installed.
Thanks in advance
Maciej KiewraHi Maciej,
I have the exact same problem as you. I was told to try and add entry to
the RSWebApplication.config file. It is
<ReportServerExternalUrl>http://yourwebservername/ReportServer</ReportServerExternalUrl>
add this right after the <ReportServerUrl> entry. This didn't work for me
but I am interested in if it works for you. Let me know.
Thanks,
JJ
"Maciej Kiewra" wrote:
> Hi, experts.
>
> I have a strange problem with accessing Analysis Services from
> Reporting
> Services.
> Our client needs to public reports in the web site and to make them
> accessible for everybody. In order to achieve it, I did the following:
> 1. In IIS I put the anonymous access for the virtual directory
> ReportServer. (the user IWAM_hostname)
> 2. I granted the explorer right to the user IWAM_hostname from the web
> application that permits the reports to be managed.
> 3. In the same application I changed the credentials for the dataset
> that pointed to analysis services. I chose the "stored credentials"
> (the user I specified had access rights in the corresponding cube).
> Once the configuration was established, I tried to access our reports
> via web. I could see reporting services interface but it was not
> possible to view the data from analysis services. There was an error:
> "dimension not known."
> Seeing this, I decided to give analysis services rights for the
> IWAM_hostname user, but it brought the same result.
> When I changed the configuration of Report Server virtual directory
> (instead of anonymous access, I put the windows authorization again),
> everything worked fine.
> I have an impression that credentials specified in the web application
> are ignored.
> The question is, which user is used to access the Analysis Services
> from the Reporting Services when the anonymous user is set in the IIS
> ReportServer directory.
> All relevant information will be appreciated.
> One more thing: Reporting Services has the servicepack 1 installed.
>
> Thanks in advance
> Maciej Kiewra
>

Monday, February 20, 2012

reporting services works over internet ?

Is it possible to access reports from internet, using a public address like
http://www.mydomain.com/reports instead of http://myserver/reports ? How can
I do it ?
Thanks
MorenoChange the <ReportServerUrl> entry in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
-Steve
"Moreno" <movendra@.yahoo.com> wrote in message
news:%23$u5fFQXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Is it possible to access reports from internet, using a public address
like
> http://www.mydomain.com/reports instead of http://myserver/reports ? How
can
> I do it ?
> Thanks
> Moreno
>|||I did that, restarted Reporting services as well. But doesnt work.
It says "Directory Listing Denied"
"Stephen Walch" wrote:
> Change the <ReportServerUrl> entry in C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
> -Steve
> "Moreno" <movendra@.yahoo.com> wrote in message
> news:%23$u5fFQXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > Is it possible to access reports from internet, using a public address
> like
> > http://www.mydomain.com/reports instead of http://myserver/reports ? How
> can
> > I do it ?
> >
> > Thanks
> > Moreno
> >
> >
>
>|||Hello,
Have you tried the url http://www.mydomain.com/reportserver ?
you will be independant of web application parameters ReportManager.
Have you set Directory Security of your Web Application under IIS ?
Is your client authenticated against your application ?
HTH
Jerome Berthaud (MCSD)
http://www.winsight.fr
"AbiBaby" <AbiBaby@.discussions.microsoft.com> wrote in message
news:05359046-2E28-4402-BED3-8F3F3FC70B1A@.microsoft.com...
> I did that, restarted Reporting services as well. But doesnt work.
> It says "Directory Listing Denied"
> "Stephen Walch" wrote:
> > Change the <ReportServerUrl> entry in C:\Program Files\Microsoft SQL
> > Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
> >
> > -Steve
> >
> > "Moreno" <movendra@.yahoo.com> wrote in message
> > news:%23$u5fFQXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > > Is it possible to access reports from internet, using a public address
> > like
> > > http://www.mydomain.com/reports instead of http://myserver/reports ?
How
> > can
> > > I do it ?
> > >
> > > Thanks
> > > Moreno
> > >
> > >
> >
> >
> >|||Jerome,
I have the same problem in earlier post of 10/15 that received no replies.
I've had 5 folks email me with the same problem.
I have Server2003/SQL2000/IIS6 and have just installed Reporting services. I
have two websites on the server. Access to reports is fine using the
http://servername/reportServer, and using IUSR_servername, but even when
adding the following:
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl
<ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExternalURL>
</UI>
and
I've added virtual directories under above domain for reportManager and
reportServer giving appropriate read/execute permissions and security under
IIS to IUSR account only - no clear no windows authentication.
I continue to get: HTTP Error 403.8 - Forbidden
I've reset permission on website with ISUR account, flushed dns on
webserver, and flushed dns on domain controller.
Multiple websites continue to work fine, but same error whenever I try to
use a domain instead of server name.
Thanks,
Janet
"Jerome BERTHAUD" wrote:
> Hello,
> Have you tried the url http://www.mydomain.com/reportserver ?
> you will be independant of web application parameters ReportManager.
> Have you set Directory Security of your Web Application under IIS ?
> Is your client authenticated against your application ?
> HTH
> Jerome Berthaud (MCSD)
> http://www.winsight.fr
> "AbiBaby" <AbiBaby@.discussions.microsoft.com> wrote in message
> news:05359046-2E28-4402-BED3-8F3F3FC70B1A@.microsoft.com...
> > I did that, restarted Reporting services as well. But doesnt work.
> > It says "Directory Listing Denied"
> >
> > "Stephen Walch" wrote:
> >
> > > Change the <ReportServerUrl> entry in C:\Program Files\Microsoft SQL
> > > Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config
> > >
> > > -Steve
> > >
> > > "Moreno" <movendra@.yahoo.com> wrote in message
> > > news:%23$u5fFQXEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > > > Is it possible to access reports from internet, using a public address
> > > like
> > > > http://www.mydomain.com/reports instead of http://myserver/reports ?
> How
> > > can
> > > > I do it ?
> > > >
> > > > Thanks
> > > > Moreno
> > > >
> > > >
> > >
> > >
> > >
>
>