Opening a Report from a VB Application

Hi All,
I have a VB Application that lists all the reports on my report server in a
treeview control. Now all i need to do is open a report when it is clicked
on in my app.. What is the VB code to do this?
Thanks
SanjeevUse a browser control on your VB form. You can add this from the file
c:\windows\system32\shdocvw.dll. Read the report path from the treeview
control when a user selects an item to view, then use URL access to display
the report in the browser control as follows:
AxWebBrowser1.Navigate("http://MyReportServer/ReportServer?" & reportPath)
AxWebBrowser1 is the default name of the browser control when you place it
on the form.
There are lots of examples in Books Online. Look up the topic "Using URL
Acces from a Windows application".
HTH
Charles Kangai, MCT, MCDBA
"Sanjeev" wrote:
> Hi All,
> I have a VB Application that lists all the reports on my report server in a
> treeview control. Now all i need to do is open a report when it is clicked
> on in my app.. What is the VB code to do this?
> Thanks
> Sanjeev
>
>|||I am not entirely sure on how to add the browser control.
What i did was add shdocvw.dll as a reference to my to my windows
application.
Then I added "Imports SHDocVw" to the code.
But the Browser Control didnt appear in my ToolBox.
I suppose that this was the wrong way to go about it.
Sorry to trouble you again but what is the riht way to go about this.
Thanks in advance
Sanjeev
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:C42CA3EB-A91F-4F5A-A0A6-1BE59DE35999@.microsoft.com...
> Use a browser control on your VB form. You can add this from the file
> c:\windows\system32\shdocvw.dll. Read the report path from the treeview
> control when a user selects an item to view, then use URL access to
> display
> the report in the browser control as follows:
> AxWebBrowser1.Navigate("http://MyReportServer/ReportServer?" & reportPath)
> AxWebBrowser1 is the default name of the browser control when you place it
> on the form.
> There are lots of examples in Books Online. Look up the topic "Using URL
> Acces from a Windows application".
> HTH
> Charles Kangai, MCT, MCDBA
> "Sanjeev" wrote:
>> Hi All,
>> I have a VB Application that lists all the reports on my report server in
>> a
>> treeview control. Now all i need to do is open a report when it is
>> clicked
>> on in my app.. What is the VB code to do this?
>> Thanks
>> Sanjeev
>>|||In Visual Studio go to Tools, Add/Remove Toolbox Items.. Click on COM
Components tab, then find Microsoft Web Browser. Check the checkbox then OK.
HTH
Charles Kangai, MCT, MCDBA
"Sanjeev" wrote:
> I am not entirely sure on how to add the browser control.
> What i did was add shdocvw.dll as a reference to my to my windows
> application.
> Then I added "Imports SHDocVw" to the code.
> But the Browser Control didnt appear in my ToolBox.
> I suppose that this was the wrong way to go about it.
> Sorry to trouble you again but what is the riht way to go about this.
> Thanks in advance
> Sanjeev
>
>
> "Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
> news:C42CA3EB-A91F-4F5A-A0A6-1BE59DE35999@.microsoft.com...
> > Use a browser control on your VB form. You can add this from the file
> > c:\windows\system32\shdocvw.dll. Read the report path from the treeview
> > control when a user selects an item to view, then use URL access to
> > display
> > the report in the browser control as follows:
> >
> > AxWebBrowser1.Navigate("http://MyReportServer/ReportServer?" & reportPath)
> >
> > AxWebBrowser1 is the default name of the browser control when you place it
> > on the form.
> >
> > There are lots of examples in Books Online. Look up the topic "Using URL
> > Acces from a Windows application".
> >
> > HTH
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "Sanjeev" wrote:
> >
> >> Hi All,
> >>
> >> I have a VB Application that lists all the reports on my report server in
> >> a
> >> treeview control. Now all i need to do is open a report when it is
> >> clicked
> >> on in my app.. What is the VB code to do this?
> >>
> >> Thanks
> >> Sanjeev
> >>
> >>
> >>
>
>|||Yip . that sure did the trick.
Appreciate all your help.
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:6138AE51-7E0C-487F-96B7-6A5A849EFF4D@.microsoft.com...
> In Visual Studio go to Tools, Add/Remove Toolbox Items.. Click on COM
> Components tab, then find Microsoft Web Browser. Check the checkbox then
> OK.
> HTH
> Charles Kangai, MCT, MCDBA
> "Sanjeev" wrote:
>> I am not entirely sure on how to add the browser control.
>> What i did was add shdocvw.dll as a reference to my to my windows
>> application.
>> Then I added "Imports SHDocVw" to the code.
>> But the Browser Control didnt appear in my ToolBox.
>> I suppose that this was the wrong way to go about it.
>> Sorry to trouble you again but what is the riht way to go about this.
>> Thanks in advance
>> Sanjeev
>>
>>
>> "Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in
>> message
>> news:C42CA3EB-A91F-4F5A-A0A6-1BE59DE35999@.microsoft.com...
>> > Use a browser control on your VB form. You can add this from the file
>> > c:\windows\system32\shdocvw.dll. Read the report path from the treeview
>> > control when a user selects an item to view, then use URL access to
>> > display
>> > the report in the browser control as follows:
>> >
>> > AxWebBrowser1.Navigate("http://MyReportServer/ReportServer?" &
>> > reportPath)
>> >
>> > AxWebBrowser1 is the default name of the browser control when you place
>> > it
>> > on the form.
>> >
>> > There are lots of examples in Books Online. Look up the topic "Using
>> > URL
>> > Acces from a Windows application".
>> >
>> > HTH
>> >
>> > Charles Kangai, MCT, MCDBA
>> >
>> > "Sanjeev" wrote:
>> >
>> >> Hi All,
>> >>
>> >> I have a VB Application that lists all the reports on my report server
>> >> in
>> >> a
>> >> treeview control. Now all i need to do is open a report when it is
>> >> clicked
>> >> on in my app.. What is the VB code to do this?
>> >>
>> >> Thanks
>> >> Sanjeev
>> >>
>> >>
>> >>
>>

Open up SQL Server for central server application...

I have an application which runs in many different stores. Stores
that are within a chain want to be able to share their client lists.
I want to implement a sync process where each application would ping a
central server every 5-10 mins to check for changes made by any other
store to the client list, if any changes are made it would download
the new or modified clients then upload any clients that were modified
localy. I want the stores to ping for changes, I don't want to try to
implement some kind of real time system where there changes would
always be stored directly on the server as they make them.
My application uses MSDE so I was thinking about just throwing MSDE on
a central server that all the other computers could access over an
internet connection and keeping a master client list in this database.
The applications in each store would connect directy to MSDE to send
and get the data needed. My question is, how secure would it be to
open up my sql server port to the internet so each store could connect
to it? Is it enough to set a user account for the database and set a
SA password? If not, what else do I need to do? Also, I know it is
possible to set the SA password to blank with a simple query, so
doesn't this mean that SQL Server would not be secure at all even if I
set a password for user SA?
How can I do this and keep it secure? Or is there a better overall
approach to doing this?
Thanks.Ray Lavelle (bostonpartykid@.yahoo.com) writes:
> The applications in each store would connect directy to MSDE to send
> and get the data needed. My question is, how secure would it be to
> open up my sql server port to the internet so each store could connect
> to it? Is it enough to set a user account for the database and set a
> SA password? If not, what else do I need to do? Also, I know it is
> possible to set the SA password to blank with a simple query, so
> doesn't this mean that SQL Server would not be secure at all even if I
> set a password for user SA?
> How can I do this and keep it secure? Or is there a better overall
> approach to doing this?

Putting a database on the Internet is not a walk in the park. Not the least
if you have mixed-mode authentication. Someday someone will find that
server, and try sa passwords until he gets in. There is no way to tell
SQL Server to close the doors if there have been too many failed login
attempts.

Security issues are not my best subject, but I would guess that the best
is that you set up VPN connections between the stores. Then all that
is exposed to the Internet is the VPN login, and this is least safe against
brute force attacks. This also permits the stores to be in the same
domain, so that you can use Windows authentication, and turn of SQL
authentication.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Open Report Builder and Link to Report Directly?

Hi,

I've created a simple webpart that lists all the reports that a user has created using the Report Builder and next to each line item is an "Edit" link. What I would like to do is open up the Report Builder application and pass a parameter of the report path or something like that so that report builder opens up the report automatically.

Is this possible?

Thanks

Tristian

http://blogs.msdn.com/bobmeyers/archive/2006/01/24/517083.aspx|||THanks, this worked great!