Can it be done? WinForm consumes report, then prints direct to printer

It seems like there must be a way to do this basic task. A winform app
calls a report, passes the parameters and then outputs that report directly
to the printer without user intervention, or browser sessions.
I really dont want to go back to Crystal to do this.
Thanks, MikeNot easily. To integrate with RS from a winform you have to use either web
services or url integration. You can either handle the printing yourself
(render to PDF, save the file to disk, print the PDF) or use the client side
printing but although the client side printing could be driven by URL
integration (which would require a browser control) it will pop up a
printing dialog box. There is no way I know of to prevent this. My
suggestion is to render to PDF, save to disk etc.
You could try beta 2 of VS 2005 which have a winform and webform control but
that is a beta.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael Morisoli" <michael@.removeme.vieon.net> wrote in message
news:OyKPcNVYFHA.3032@.TK2MSFTNGP10.phx.gbl...
> It seems like there must be a way to do this basic task. A winform app
> calls a report, passes the parameters and then outputs that report
> directly
> to the printer without user intervention, or browser sessions.
> I really dont want to go back to Crystal to do this.
> Thanks, Mike
>

Can I..........

Can I run "Maintenance Plan" directly (without wait its scheduling)? If can,
How to run it?You can run the job(s) associated with the plan directly by right-clicking
the job in EM and selecting Start Job.
HTH
Jerry
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:ezk7V%23bzFHA.3152@.TK2MSFTNGP10.phx.gbl...
> Can I run "Maintenance Plan" directly (without wait its scheduling)? If
> can,
> How to run it?
>|||In Enterprise Manager, go to Management / SQL Server Agent / Jobs,
right-click on the appropriate job for your maintenance plan and choose
Start Job.
Razvan|||Yes go to the jobs and the maintainance plan(s) should be listed there
DB backup for ...plan
Transaction log backup for ...plan
Integrity checks for ...plan
just right click and select start job
http://sqlservercode.blogspot.com/
"Bpk. Adi Wira Kusuma" wrote:

> Can I run "Maintenance Plan" directly (without wait its scheduling)? If ca
n,
> How to run it?
>
>

Can I send my report directly to a printer by url?

If so, how can I modify this to send to printer please:
http://localhost/ReportServer?%2fReport+PackingList1/Report1&rs:Command=Render&InvoiceNumber=931270
Thanks,
TrintThere is no current method to send directly to a printer. In SP2, there is
no print functionality. Check out the Beta Place for Reporting Services SP2.
--
| From: "trint" <trinity.smith@.gmail.com>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| Subject: Can I send my report directly to a printer by url?
| Date: 19 Jan 2005 12:28:34 -0800
| Organization: http://groups.google.com
| Lines: 6
| Message-ID: <1106166514.754985.225210@.c13g2000cwb.googlegroups.com>
| NNTP-Posting-Host: 65.244.90.165
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1106166519 10153 127.0.0.1 (19 Jan 2005
20:28:39 GMT)
| X-Complaints-To: groups-abuse@.google.com
| NNTP-Posting-Date: Wed, 19 Jan 2005 20:28:39 +0000 (UTC)
| User-Agent: G2/0.2
| Complaints-To: groups-abuse@.google.com
| Injection-Info: c13g2000cwb.googlegroups.com; posting-host=65.244.90.165;
| posting-account=Ih-yCA0AAADzXymSlPU6JhcQ_cZnGStd
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!postnews.google.com!c13g2000cwb.go
oglegroups.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:40281
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| If so, how can I modify this to send to printer please:
|
|
http://localhost/ReportServer?%2fReport+PackingList1/Report1&rs:Command=Rend
er&InvoiceNumber=931270
| Thanks,
| Trint
|
||||Brad,
Did you mean to say that SP2 will have printer functionality? I signed
up to use SP2.
Thanks,
Trint
"Brad Syputa - MS" wrote:
> There is no current method to send directly to a printer. In SP2,
there is
> no print functionality. Check out the Beta Place for Reporting
Services SP2.
> --
> | From: "trint" <trinity.smith@.gmail.com>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | Subject: Can I send my report directly to a printer by url?
> | Date: 19 Jan 2005 12:28:34 -0800
> | Organization: http://groups.google.com
> | Lines: 6
> | Message-ID: <1106166514.754985.225210@.c13g2000cwb.googlegroups.com>
> | NNTP-Posting-Host: 65.244.90.165
> | Mime-Version: 1.0
> | Content-Type: text/plain; charset="iso-8859-1"
> | X-Trace: posting.google.com 1106166519 10153 127.0.0.1 (19 Jan 2005
> 20:28:39 GMT)
> | X-Complaints-To: groups-abuse@.google.com
> | NNTP-Posting-Date: Wed, 19 Jan 2005 20:28:39 +0000 (UTC)
> | User-Agent: G2/0.2
> | Complaints-To: groups-abuse@.google.com
> | Injection-Info: c13g2000cwb.googlegroups.com;
posting-host=65.244.90.165;
> | posting-account=Ih-yCA0AAADzXymSlPU6JhcQ_cZnGStd
> | Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
>
ul.t-online.de!t-online.de!news.glorb.com!postnews.google.com!c13g2000cwb.go
> oglegroups.com!not-for-mail
> | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:40281
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | If so, how can I modify this to send to printer please:
> |
> |
>
http://localhost/ReportServer?%2fReport+PackingList1/Report1&rs:Command=Rend
> er&InvoiceNumber=931270
> | Thanks,
> | Trint
> |
> |

can I return a message from SQL Server to C# application?

I am using SQL server in my C# application and I was thinking if there is any way to return a message from the SQL Server directly to the MessageBox.Show

Right now I am using RETURN 999 and sending the value to C# then implementing and IF return_value = 999 the MessageBox.Show

You could use an OUTPUT parameter and return any varchar()/string message you desire.

I think that it would be difficult to return a message back directly from SQL Server to a messagebox control's show event. However, you could explore setting up a Delegate and a CallBack routine that could accomplish your desired results.

You may wish to post your issue on one of the WinForms forums, where you are more likely to get the help needed.

Can I pass ResultSet as parameter of Stored Proc directly ?

Hi, All
Is it possible for me that I pass a resultset as parameter of Stored Proc
directly instead of putting it to a table before calling a stored procedure
which manipulate data of the table?
Thanks a lot in advance for your answer.
http://www.sommarskog.se/share_data.html
http://www.aspfaq.com/
(Reverse address to reply.)
"Sally" <Sally@.discussions.microsoft.com> wrote in message
news:1FBF91FA-172B-41AC-8834-0C7AAE52310D@.microsoft.com...
> Hi, All
> Is it possible for me that I pass a resultset as parameter of Stored Proc
> directly instead of putting it to a table before calling a stored
procedure
> which manipulate data of the table?
> Thanks a lot in advance for your answer.

Can I pass ResultSet as parameter of Stored Proc directly ?

Hi, All
Is it possible for me that I pass a resultset as parameter of Stored Proc
directly instead of putting it to a table before calling a stored procedure
which manipulate data of the table?
Thanks a lot in advance for your answer.http://www.sommarskog.se/share_data.html
http://www.aspfaq.com/
(Reverse address to reply.)
"Sally" <Sally@.discussions.microsoft.com> wrote in message
news:1FBF91FA-172B-41AC-8834-0C7AAE52310D@.microsoft.com...
> Hi, All
> Is it possible for me that I pass a resultset as parameter of Stored Proc
> directly instead of putting it to a table before calling a stored
procedure
> which manipulate data of the table?
> Thanks a lot in advance for your answer.

Can I pass ResultSet as parameter of Stored Proc directly ?

Hi, All
Is it possible for me that I pass a resultset as parameter of Stored Proc
directly instead of putting it to a table before calling a stored procedure
which manipulate data of the table?
Thanks a lot in advance for your answer.http://www.sommarskog.se/share_data.html
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Sally" <Sally@.discussions.microsoft.com> wrote in message
news:1FBF91FA-172B-41AC-8834-0C7AAE52310D@.microsoft.com...
> Hi, All
> Is it possible for me that I pass a resultset as parameter of Stored Proc
> directly instead of putting it to a table before calling a stored
procedure
> which manipulate data of the table?
> Thanks a lot in advance for your answer.

Can i invoke remoting web service in store procedure directly?

i am using sqlserver 2000,if so how,thanks.Nope. But you'll be able to do it Yukon.

Rob|||Hi mmkk,

I saw a similar discussion about invoking Web Services in TSQL in the past:
here

Regards,