Accessing domain user name as a report parameter

In our legacy reports (ASP.NET/Crystal Reports) we use the logged in user account to filter the report.
Basically you are restricted to seeing your 'own' data when running the report based upon your user ID.
I am looking for suggestions as how to restrict report results based on something like domain user ID in Reporting Services.
There are many cases (like in the sales profession) where users of the same report do not want other users to access their information.
Thanks for any suggestions.use the global variable User!UserID
be aware that you may not create subscriptions for a report that contains user-defined parameter values.

Accessing an SSRS report from the web, being prompted for Guest signon screen

I have a sql server 2005 application that uses asp and some canned reports that I built using SSRS. All reports run from the server but not when to try accessing from another computer on the network. I get a prompt from windows that requests me to enter a password for the Gurest account. The Guest account is not selectable. Does anyone know how to supress the signon page? I am using sql 2005 workgroup edition. I would like the users to go directly to the ssrs report without any logon screen.

Thanks

Rich

Hi,

I guess you enabled Simple File Shring on the computer you want to have access to. Switch it off by using the Explorer Menu --> Options --> Advanced --< Disable "Simple File Sharing". The computer will now prompt you for credentials as you will be not authenticated as a guest user.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Jens,

I looked at my internet explorer optiions under in advanced settings, and do not see an oprion for "Simple File Sharing" to uncheck?

Thanks

|||

That in the service hosting machine, in the Options of the Explorer, not the internet explorer.

-jens.

|||

Jens,

What explorer are you talk about? Could you be more specific. Been looking all over for that option on my server machine.

Thanks

Rich

|||Are you running on an WinXP box? Are you using Windows authentication on your virtual directories? If so try forcing NTLM (see workaround section in http://support.microsoft.com/default.aspx?scid=kb;en-us;871179). If it works for you then we can be pretty certain that it is a kerberos issue. Either follow the "workaround" or the "resolution" in the KB article.|||

James,

I am running windows XP, and Windows Authentication on virtual Directories. The web application works fine reading and writing to sql server. It only prompts me for guest signon screen when I select a report that was published to reporting services report. The TreeNode code that runs the report s displayed below:

<asp:TreeNode NavigateUrl="http://promsvr/ReportServer/Pages/ReportViewer.aspx?%2fPromshop+Reports%2fSalesReceipt&rs:Command=Render" target="content" Text="Sales Receipt" Value="SalesRpt"></asp:TreeNode>

I ran the workaround from the article and got the following results that matched the article. The following text was returned:

NTAuthenticationProviders : (STRING) "NTLM"

I have the same problem when accessing the report from a client machine. I could not do the resolution from the article as I do not know how to get

IIS_computer's_NetBIOS_name DomainName\UserName
computer's_FQDN DomainName\UserName

My Virtual Web Settings are:

Virtual Web Server:

Anonymous access checked; User Name: IUSR_PROMSVR; Password: *********; Allow IIS to control password is selected; Integrated Windows authentication is selected

Virtual Reports

Only Integrated Windows authentication is checked

Virtual ReportServer

Only Integrated Windows authentication is checked

|||

Just want to confirm: did the workaround solve your problem? What are the OS on your client machine and RS server machine?

I don't know a definitive way of finding out NetBIOS and FQDN. For NetBIOS name, run "nbtstat -n". It is basically the shortname of your server. For FQDN, find out your DNS suffix by running "ipconfig /all", and prepend the NetBIOS name to DNS suffix. For example, you NetBIOS name may be "myserver", and FQDN may be "myserver.mycompany.com". The DomainName\UserName is the domain account that the RS app pool is running under.

You mentioned Virtual Web Server. What is this?

|||

I figured it out, I turned simple file sharing off in explorer.

Thanks everyone for all there help....

Accessing a DSN through a Sql job

I am trying to execute an SSIS package (which accesses a dbf file through an odbc connection) through a Sql job, but the package log reports an error of "Disk or netowrk error". When I execute the package in the IDE, the package executes fine. When I run the manifest on the DB server, I can execute the package with no errors. But, when I create the job, and try to execute the job, it fails. I thought at first that the user didn't have privileges to the directory that the file existed in, but that isn't the case.

Can anyone shed some light on how to accomplish what I am trying to accomplish? It seems like this would be a common use of SSIS, but I cannot seem to get it to work.

Thanks in advance for any assistance you can provide!

Craig

This seems to be security issue, as your package can execute fine within the IDE, but not through the SQL Agent. I'd check the SQL Agent user account, along with the proxy details on the job.

|||

Thank you for your reply, Deniz.

Do you know of any web sites that I can get more information on setting up the Sql Agent account permissions? I granted that user admin privileges, but still receive the same error.

Craig Browder

craigster1976@.msn.com

Accessing 2005 Reports from asp.net 1.1

Our web based Application is based on ASP.NET 1.1 and SQL Server 2005.
Can we use 2005 Reporting Services (ASP.NET 2.0) to create and publish
reports and use them in the 1.1 Application?
(We need to change the Data Source at run time, which is not easy or not
possible in 2000 Reporting Services).
Thanks in advance,
BenjaminIn order to display a report you need just an URL. What seems to be a
problem?
You can view any url in your 1.1 application, even from a different web
site.
Just redirect to it or grab an ouput and display it in your application.
If you have a way of changing datasource in runtime in RS 2005, just create
a 2.0 web page, which does it on load and redirect/transfer from it to the
the report of your choice.
"Benjamin" <benjamin@.servue.com> wrote in message
news:ORZ$mvz9GHA.4196@.TK2MSFTNGP03.phx.gbl...
> Our web based Application is based on ASP.NET 1.1 and SQL Server 2005.
> Can we use 2005 Reporting Services (ASP.NET 2.0) to create and publish
> reports and use them in the 1.1 Application?
> (We need to change the Data Source at run time, which is not easy or not
> possible in 2000 Reporting Services).
> Thanks in advance,
> Benjamin
>

Access to view reports problem.

I have created a few reports which I have published to
the reporting server.
There is a group created something/Admins for example,
that was assigned to some users. I have the entire folder
that contains the reports in the manager set to allow
browser previleges to view reports within.
The problem is that even though the users are assigned to
that same group as the group name we set up for the
folder to view the reports, they get denied access to
view them. Oddly enough, if we add a single users NT id
to a role to view the reports in the folder, it works
fine.
So why is it if we provide a role to view reports
assigned to a specific users NT id, that works, yet using
the group they are assigned to does not work?
Thanks for the help.You might try doing an IISRESET after adding or removing the Group. It helped me.
Koby
"Adam" wrote:
> I have created a few reports which I have published to
> the reporting server.
> There is a group created something/Admins for example,
> that was assigned to some users. I have the entire folder
> that contains the reports in the manager set to allow
> browser previleges to view reports within.
> The problem is that even though the users are assigned to
> that same group as the group name we set up for the
> folder to view the reports, they get denied access to
> view them. Oddly enough, if we add a single users NT id
> to a role to view the reports in the folder, it works
> fine.
> So why is it if we provide a role to view reports
> assigned to a specific users NT id, that works, yet using
> the group they are assigned to does not work?
> Thanks for the help.
>

Access to TableAdapter Object in WebPage Class.

Hi, I'm using Reporting Services on my website and for some reports, i get the timeout error after 30 secs.

I declared my object using the Reporting tools and I am using ObjectDataSource.

My report is declared in my aspx page:

<rsweb:reportviewer id="ReportViewer1" runat="server" font-names="Verdana" font-size="8pt" Width="100%" Height="600px">

My ObjectDataSource is declared in my aspx page under my report tag:

<asp:ObjectDataSource ID="ObjectDataSource" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="ReportsTableAdapters.ViewingTotalsTableAdapter">

My TableAdapter is declare in my Reports.xsd file:

<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ViewingTotalsTableAdapter" GeneratorDataComponentClassName="ViewingTotalsTableAdapter" Name="ViewingTotals" UserDataComponentName="ViewingTotalsTableAdapter">

I am trying to access the TableAdapter object from my WebPage Class on the Page_Load event , so I can modify the Command.CommandTimeout. Unfortunately, I cannot find a way to have access to the TableAdater object.

Anyone has any suggestion ?

Thanks,

Richard

Did you ever get a response to this? I am having the same problem.

Access to TableAdapter Object in WebPage Class.

Hi, I'm using Reporting Services on my website and for some reports, i get the timeout error after 30 secs.

I declared my object using the Reporting tools and I am using ObjectDataSource.

My report is declared in my aspx page:

<rsweb:reportviewer id="ReportViewer1" runat="server" font-names="Verdana" font-size="8pt" Width="100%" Height="600px">

My ObjectDataSource is declared in my aspx page under my report tag:

<asp:ObjectDataSource ID="ObjectDataSource" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="ReportsTableAdapters.ViewingTotalsTableAdapter">

My TableAdapter is declare in my Reports.xsd file:

<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ViewingTotalsTableAdapter" GeneratorDataComponentClassName="ViewingTotalsTableAdapter" Name="ViewingTotals" UserDataComponentName="ViewingTotalsTableAdapter">

I am trying to access the TableAdapter object from my WebPage Class on the Page_Load event , so I can modify the Command.CommandTimeout. Unfortunately, I cannot find a way to have access to the TableAdater object.

Anyone has any suggestion ?

Thanks,

Richard

Did you ever get a response to this? I am having the same problem.

Access to Reports

Sorry for the newbie question. I have a need to share reports with non-Crystal users. I'd like for recipients to be able to access reports and refresh the data. Is is possible via web or a reader if the recipients don't have access to the databases? Or, is there automation contained with CR that will generate a report and email it on a schedule?

I don't have development resources to custom build anything (i.e. web portal). Any solution would have to be an add-on to Crystal or off-the-shelf. Thank you for your suggestions.I have found that when using crystal to report off a sql database that users must be given at leat read write permission within the sql database, and in our case a viewer needed to be loaded on the client terminal to see the report.

Access standard .NET Framework classes

Hello,
My reports access the class File, a builtin class in the .NET Framework,
to check whether a file exists on a network drive somewhere. I use the File.Exists
method if that's ny help.
What I saw initally was that File.Exists returned false in every instance,
even if the file I was checked existed. I raised the trust level in the ReportServer
by editing the rssrvpolicy.config and setting the FirstMatchCodeGroup to
FullTrust. This made the code work when I access the report server locally
using Remote Desktop, however if I access the ReportServer remotely using
the machine name in the browser the call the File.Exists fails even with
the modifications to rssrvpolicy.config in place.
Does anyone have any idea as to what makes it work locally but not remotely?
--
Med venlig hilsen,
Søren Lund
www.publicvoid.dkI should mention that this is Reporting Services for SQL Server 2000 SP2
running on a Windows Server 2003 machine.

access rs reports through .aspx

I'm not sure of what i should do to come up with a web site that allows the
users to access the reports that are in my reportserver, I would like to
know a step by step instructions on how to access my reports using asp.net
web application.
Is my problem has anything to do with configuring consoles or xml log files?
Will I have to make a coding that will look for server/ virtualroot/
pathinfo prefixes.. and where and how will i make one?
I am really confused on which or what should i do to access my reports
through aspx application ..
Please guide me..
--
~SiMPLe~You need to decide if you are going to integrate using URL integration
(easiest and fullest featured) or web services (harder but complete
control). Is this an intranet or internet. If internet where you don't want
the user to have access to your server then you would have to use web
services. If URL integration then the best thing is to first understand the
URL that you need to create. Make sure you can create the URL (even just
typing it in from IE) and that you can pass parameters. Once you can do that
then you can control the other aspects of it. I tend to create the URL for
Jump to URL which is a little different (RS automatically fills in the
server name so I don't have to deal with it).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex" <alex@.interpac.com.ph(donotspam)> wrote in message
news:C9A32654-7806-402D-B709-9D7289DC9889@.microsoft.com...
> I'm not sure of what i should do to come up with a web site that allows
> the
> users to access the reports that are in my reportserver, I would like to
> know a step by step instructions on how to access my reports using asp.net
> web application.
> Is my problem has anything to do with configuring consoles or xml log
> files?
> Will I have to make a coding that will look for server/ virtualroot/
> pathinfo prefixes.. and where and how will i make one?
> I am really confused on which or what should i do to access my reports
> through aspx application ..
> Please guide me..
> --
> ~SiMPLe~|||so i need to know how to intergrate my reports using web services.. because i
don't want my clients to see my server.. Can you tell me in details how
should i start making one? and also in the URL integration, you mean the
prefixes right? (rs.. rc.. ) I guess i'll also use the URL integration
inside my web service?
--
~SiMPLe~
"Bruce L-C [MVP]" wrote:
> You need to decide if you are going to integrate using URL integration
> (easiest and fullest featured) or web services (harder but complete
> control). Is this an intranet or internet. If internet where you don't want
> the user to have access to your server then you would have to use web
> services. If URL integration then the best thing is to first understand the
> URL that you need to create. Make sure you can create the URL (even just
> typing it in from IE) and that you can pass parameters. Once you can do that
> then you can control the other aspects of it. I tend to create the URL for
> Jump to URL which is a little different (RS automatically fills in the
> server name so I don't have to deal with it).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Alex" <alex@.interpac.com.ph(donotspam)> wrote in message
> news:C9A32654-7806-402D-B709-9D7289DC9889@.microsoft.com...
> > I'm not sure of what i should do to come up with a web site that allows
> > the
> > users to access the reports that are in my reportserver, I would like to
> > know a step by step instructions on how to access my reports using asp.net
> > web application.
> > Is my problem has anything to do with configuring consoles or xml log
> > files?
> > Will I have to make a coding that will look for server/ virtualroot/
> > pathinfo prefixes.. and where and how will i make one?
> > I am really confused on which or what should i do to access my reports
> > through aspx application ..
> > Please guide me..
> >
> > --
> > ~SiMPLe~
>
>

access rights - dynamic reports

hi,
is it possible to make "dynamic reports" for users with different user
rights. depending on their rights one user sees all the columns and
another one with less rights sees just the first column?
thanksthere probably is ... but since i can't tell you i'll give you an
alternative solution - why don't you just create 2 reports
one for general users containing data that general people can see
one for 'special' users containing all of the 'secret' data. because
more than likely once the 'special' users see what they can get,
they're going to want more and it'd be easier to manage the reports on
a group basis rather than a more granular column by column basis.
those are my thoughts anyway ...
hth!

Access Reports via URL

Hi,
I figured, that I can call reports directly via URL and pass the
appropriate parameters in the URL when adding '&mypara=value'.
So far so good. But I could not figure out so far, how I can pass
parameters that allow "multiselections". Using the above notation
doesn't seem to work ... :(
--
Henning Eiben
busitec GmbH
Consultant
e-mail: eiben@.busitec.de
+49 (251) 13335-0 Tel
+49 (251) 13335-35 Fax
Rudolf-Diesel-Straße 59
48157 Münster
www.busitec.de
Sitz der Gesellschaft: Münster
HR B 55 75 - Amtsgericht Münster
USt-IdNr. DE 204607833 - St.Nr. 336/5704/1277
Geschäftsführer: Simon Böwer, Henning Eiben, Stefan Kühn, Martin Saalmann
--
... There are 10 kinds of people. Those who know binary code, and those
who don't.On Aug 24, 2:05 am, Henning Eiben <ei...@.busitec.de> wrote:
> Hi,
> I figured, that I can call reports directly via URL and pass the
> appropriate parameters in the URL when adding '&mypara=3Dvalue'.
> So far so good. But I could not figure out so far, how I can pass
> parameters that allow "multiselections". Using the above notation
> doesn't seem to work ... :(
> --
> Henning Eiben
> busitec GmbH
> Consultant
> e-mail: ei...@.busitec.de
> +49 (251) 13335-0 Tel
> +49 (251) 13335-35 Fax
> Rudolf-Diesel-Stra=DFe 59
> 48157 M=FCnsterwww.busitec.de
> Sitz der Gesellschaft: M=FCnster
> HR B 55 75 - Amtsgericht M=FCnster
> USt-IdNr. DE 204607833 - St.Nr. 336/5704/1277
> Gesch=E4ftsf=FChrer: Simon B=F6wer, Henning Eiben, Stefan K=FChn, Martin =Saalmann
> --
> ... There are 10 kinds of people. Those who know binary code, and those
> who don't.
This link might help.
http://www.esa-server.net/index.php?option=3Dcom_content&task=3Dview&id=3D1=
14&Itemid=3D103&lang=3Den
Regards,
Enrique Martinez
Sr. Software Consultant|||http://ServerName/reportserver?/FolderName/ReportName&Param1=value1&Param2=value2
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henning Eiben" <eiben@.busitec.de> wrote in message
news:%23VLf70h5HHA.1208@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I figured, that I can call reports directly via URL and pass the
> appropriate parameters in the URL when adding '&mypara=value'.
> So far so good. But I could not figure out so far, how I can pass
> parameters that allow "multiselections". Using the above notation
> doesn't seem to work ... :(
> --
> Henning Eiben
> busitec GmbH
> Consultant
> e-mail: eiben@.busitec.de
>
> +49 (251) 13335-0 Tel
> +49 (251) 13335-35 Fax
> Rudolf-Diesel-Straße 59
> 48157 Münster
> www.busitec.de
> Sitz der Gesellschaft: Münster
> HR B 55 75 - Amtsgericht Münster
> USt-IdNr. DE 204607833 - St.Nr. 336/5704/1277
> Geschäftsführer: Simon Böwer, Henning Eiben, Stefan Kühn, Martin Saalmann
>
> --
> ... There are 10 kinds of people. Those who know binary code, and those
> who don't.

Access Reports using IP Address

I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
Raj
In reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>
|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for
>

Access Reports using IP Address

I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
RajIn reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
> >I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web
I
> > get
> > nothing back. I can access Folders List and other properties of any
> > selected
> > report but not able to view the
> > reports from web. I am using a static ip address to access the website
for
> > now.
> >
> > I deployed the reports using the IP address. Any ideas on what could be
> > wrong here?
> >
> > by
> > Raj
> >
> >
>

Access Reports using IP Address

I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
RajIn reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for[vbcol=seagreen]
>

Access Reports using IP Address

I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
Raj
In reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>
|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for
>

Access Reports using IP Address

I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
RajIn reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
> >I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web
I
> > get
> > nothing back. I can access Folders List and other properties of any
> > selected
> > report but not able to view the
> > reports from web. I am using a static ip address to access the website
for
> > now.
> >
> > I deployed the reports using the IP address. Any ideas on what could be
> > wrong here?
> >
> > by
> > Raj
> >
> >
>

Access Reports using ASP.net application?

Hi,
I am currently exploring Reporting services. I have created a simple report and would like to give access to my reports inside my asp.net application.
Can someone help me on how to go about doing this.
Thanks.

Hi eeyore21

The easiest way to do this is to create an IFRAME obtject and point the souce to the reportserver URL.
You could check out posting 'Adding Parameters from .ASPX file'on this forum. I posted some simular info there
,L0n3i200n

|||You can also use the rendering methodology. Go to and look up Reporting Services Renderingwww.microsoft.com
and search for Reporting Services Rendering. They have examples thatwill allow you to use reports in your asp.net app. I actually havearound 14 reports that are a part of a web app that I created inASP.Net that use this method.

Access Report/Import Groupings

Hi Folks
Importing Access reports that have grouping are really quite a struggle.
All of the grouping sections are imported as controlled by report parameters.
Am I missing something, this is incredibly painfull with all of the build
errors in VS.NET?
RobI've reported this earlier, but the importation truely 'mangles' Access
Reports that are based on SQL Server sprocs that dynamically create record
sets (in my case dynamic creation of fields related to creating pivot tables
on the fly).
The issue is 'what does SSRS feel that it's important to do' in order to
retrieve a record set associated with a report.
The way to get ALL of this to work is a 3 step process:
1. Import the report from Access, which will give you a working sproc
dataset, but a mangle report import (that contains all kind of parameterized
stuff that SSRS couldn't figure out how to map).
2. Run the sproc standalone (in either Access or SQL Server) and create a
'working table' from the result set. Next, remap your Access query to this
'hard coded' table.
3. Finally, rerun the import on the remapped Access Report. The import is
almost correct (things like page breaks have to be redone and some other
little anomolies).
Delete the second dataset associated with 2nd import and delete the 1st
.rdl. This leaves you with a good dataset from the 1st import and a good
report from the 2nd import. Now just remap the dataset for the .rdl.
This is all because SSRS gets a little TOO carried away with trying to
interpret calls to sprocs (which use things like #tables and dynamically
define columns). This needs to be changed in the report creation and import
features of the product. This is TOO constraining to the point where the
product is making poor import decisions as well as being an absolute 'show
stopper' on new report creation where it uses a sproc.
Rob
"tutor" wrote:
> Hi Folks
> Importing Access reports that have grouping are really quite a struggle.
> All of the grouping sections are imported as controlled by report parameters.
> Am I missing something, this is incredibly painfull with all of the build
> errors in VS.NET?
> Rob

access report builder from custom code

I am writing a .NET app, I'd like the user to have access to the report
builder to make ad-hoc reports, how would I go about doing this from inside
my application? thanks!You can use "reportbuilder.exe" file but I have not tried running this exe,
where the RS environment is not there. Moreover this is a part of SSRS and
ofcourse Sql server so probabily licensing issues will be there because this
is a seperate tool, but will have to check whether it works out of the SS &
SSRS environment first.
Amarnath
"Smokey Grindle" wrote:
> I am writing a .NET app, I'd like the user to have access to the report
> builder to make ad-hoc reports, how would I go about doing this from inside
> my application? thanks!
>
>