How Do I Hide Internet Explorer Menu and Tool Bar

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

If I am understanding what you are asking, that is not possible with SSRS.

|||I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.|||Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report?parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe|||

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE ?

|||I'm not following you. Are browsing to the reports from within Report Manager? Or are you calling the report from another web page?

Joe|||I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.|||

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application? If so, you will have quite a bit of control over the web page. What tool are you using? Or are you creating the web page from "scratch"?

How Do I Hide Internet Explorer Menu and Tool Bar

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

If I am understanding what you are asking, that is not possible with SSRS.

|||I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.|||Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report?parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe|||

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE ?

|||I'm not following you. Are browsing to the reports from within Report Manager? Or are you calling the report from another web page?

Joe|||I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.|||

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application? If so, you will have quite a bit of control over the web page. What tool are you using? Or are you creating the web page from "scratch"?

sql

How Do I Hide Internet Explorer Menu and Tool Bar

How can I hide the Internet Explorer Menu and Tool Bar in SQL Reporting.

If I am understanding what you are asking, that is not possible with SSRS.

|||I have a report generated by SQL Reporting service from another program, I just want the Internet Explorer Menu and tool to be hidden so that the user could not navigate to another site.|||Hi -

You should be able to do this using javascript in the calling page. Something like:

function popReport(parm)
{

window.open("path\to\report?parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px");

}

You can call it using the onclick event of an item in the calling page, like:

<a onclick="return popReport('<% =label.Text %> ')" href="#">....</a>

Here's a link to some more information
http://msdn2.microsoft.com/en-us/library/ms536651.aspx

HTH...

Joe|||

I tried that , but it did not work since the SQL Reporting Service launches the Internet Explorer.

Is there a way to configure the the Report to pass parameters to IE ?

|||I'm not following you. Are browsing to the reports from within Report Manager? Or are you calling the report from another web page?

Joe|||I am calling the report from another web page passing the report parameters. The problem is after the report is launched . I do not want the user to have access to the Internet Explorer Menu or any Web navigational tool, want the IE to display the report and the report tools but not the IE Menu and Tools or the Address Bar.|||

Then you would probably want to handle this with the web page. SSRS generates reports. It really has nothing to do with Internet Explorer other than it is displayed IN Internet Explorer.

Are you using Visual Studio 2005 to create a web application? If so, you will have quite a bit of control over the web page. What tool are you using? Or are you creating the web page from "scratch"?

How do I get my local data in the database on the Internet?

I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could use
FTP (possibly through a ASP component) to move your files to the location. If
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you will
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:
> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?|||Hi
May be look at replication?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replsec_5ad0.asp
John
"needin4mation@.gmail.com" wrote:
> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>

How do I get my local data in the database on the Internet?

I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.
Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could use
FTP (possibly through a ASP component) to move your files to the location. If
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you will
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:

> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>
|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?
|||Hi
May be look at replication?
http://msdn.microsoft.com/library/de...plsec_5ad0.asp
John
"needin4mation@.gmail.com" wrote:

> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>

How do I get my local data in the database on the Internet?

I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck. I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host. On my development machine I put
it in Access for testing my code. But now that I am done testing I
have to get the data to the real database online.
I don't know how to get the access/CSV data into Sql Server on the
Internet. I'm not sure where to start.
Thank you for any help.Hi,
it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don=B4t know if htp is supported in DTS)
Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Hi
One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could us
e
FTP (possibly through a ASP component) to move your files to the location. I
f
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you wil
l
need a method that will securely allow your database server to see this
directory without compromising the database server.
John
"needin4mation@.gmail.com" wrote:

> I am used to working in an Intranet where I have access to all the
> pieces, but now I am working with the Internet and am stuck. I receive
> various datafeeds in the form of a CSV file and need to get that data
> into a SQL Server database on my host. On my development machine I put
> it in Access for testing my code. But now that I am done testing I
> have to get the data to the real database online.
> I don't know how to get the access/CSV data into Sql Server on the
> Internet. I'm not sure where to start.
> Thank you for any help.
>|||Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?|||Hi
May be look at replication?
http://msdn.microsoft.com/library/d...
ad0.asp
John
"needin4mation@.gmail.com" wrote:

> Do you mean ftp the local .mdf and .ldf files from my development
> machine to my Internet server?
>

How do I get my Data into SqlServer?

I have a development machine that I have prototyped with access. I don't know how to get the access data into Sql Server on the Internet. Can you help me? I'm not sure where to start. Thank you for any help.

just_for_forums wrote:

I don't know how to get the access data into Sql Server on the Internet.

I am not sure what you are asking? Are you trying to build a web application which will interact with your SQL Server, adding data to a table? Or are you trying to import records from Access into SQL Server? or, something else altogether?|||

tmorton wrote:

just_for_forums wrote:

I don't know how to get the access data into Sql Server on the Internet.

I am not sure what you are asking? Are you trying to build a web application which will interact with your SQL Server, adding data to a table? Or are you trying to import records from Access into SQL Server? or, something else altogether?

I have my web application already. I have everything working. The data is in Microsoft Access on my development machine. I need it in SQL Server on the Internet. I just need to know how to get the data in the table rows to SQL Server. The web application will then be adjusted so that it points to the Internet where data is housed (and where my web pages are).

Thanks for help.

|||

just_for_forums wrote:

The data is in Microsoft Access on my development machine. I need it in SQL Server on the Internet. I just need to know how to get the data in the table rows to SQL Server.

OK then, so you need to do a one-time import of your data from Microsoft Access into your SQL Server.

Which version of Access are you using? And which version of SQL Server?

As far as I know, there are 2 different ways to go about this. You can use the Upsizing Wizard within Access to push the data into SQL Server. Or you can use Data Transformation Services (DTS) within SQL Server to pull your data from Access.|||Thanks. I will look into it. I just so used to an Intranet and having access to all the pieces. I just have access 97. sql server on the Internet is 2000.|||I found that if I right-clicked on my table and exported it, I could export it to an ODBC data source.

How do I get a RS report onto an Internet website?

I've written our first Reporting Services report, using SQL Server 2005. Since we've never used RS before, we may, or may not, have done some things correctly. One of the things is that we only have the Reporting Services, and Report Manager, on our SQL Server 2005 server, which is in our network behind our firewall.

We also have an ASP.NET 1.1 application which is used by external users (other businesses that do business with us). Because of the nature of our business, we don't want people from one agency to access data from another agency. Since calling the report in RS involved passing parameters to the report in the URL, I decided that I would hide those details by putting the web page returned by RS into an IFRAME in an aspx page. It works just fine in our network, but I discovered that it does not work at all outside of our network.

So, my question is how do I make the RS report available to users outside of our network, in such a way that they don't have access to the parameters that I pass to the report? Should I discard the whole IFRAME approach? I have been told that it will likely require doing something about passing credentials to the backend server from the ASP.NET app, but I don't know how to do that, nor do I know what would be involved.

The most straightforward approach is to use the VS reportviewer control & run your report in local mode, e.g., do not rely upon the report server. This approach eliminates the need to create a security extesion for report server. Cheers!|||

I'm sorry to be so obtuse, but what do you mean by, "run [my] report in local mode"?

|||

DoctorWho:

I'm sorry to be so obtuse, but what do you mean by, "run [my] report in local mode"?

Never mind, I've found it (local mode).

How do I get a RS report onto an Internet app?

I've written our first Reporting Services report, using SQL Server 2005. Since we've never used RS before, we may, or may not, have done some things correctly. One of the things is that we only have the Reporting Services, and Report Manager, on our SQL Server 2005 server, which is in our network behind our firewall.

We also have an ASP.NET 1.1 application which is used by external users (other businesses that do business with us). Because of the nature of our business, we don't want people from one agency to access data from another agency. Since calling the report in RS involved passing parameters to the report in the URL, I decided that I would hide those details by putting the web page returned by RS into an IFRAME in an aspx page. It works just fine in our network, but I discovered that it does not work at all outside of our network.

So, my question is how do I make the RS report available to users outside of our network, in such a way that they don't have access to the parameters that I pass to the report? Should I discard the whole IFRAME approach? I have been told that it will likely require doing something about passing credentials to the backend server from the ASP.NET app, but I don't know how to do that, nor do I know what would be involved.

Your report will be trying to access data from the SQL Server and your internet site will be passing through port 80 (Open to the world) and therefore the SQL Data side will be blocked, If you open the SQL Port on the firewall then you will see the report runs fine, but then you have a SQL Port open!! Thats a whole other issue, You can do an internal redirect which will give you the same result but slightly more secure.

Your choice on that one...

|||

Andy,

What do you mean by I "... can do an internal redirect...". What is that and how do I do that, please?

|||

Rod, possibly Teo's article will help you: "Harden MS Reporting Services Using Custom Extensions"