Print newly created report later

Hi all,

I am creating reports using crystal report in VB.NET. The reports are created successfully and can be converted to PDF and Word.

After the creation i send generated documents as email. And also have to print them.

I don't want to use Adobe/Word for the printing. I want to create .prn files for printing in the generation process.

Is there any other option which can be used to print the created report.

I can print the reports directly from crystal reports but i want to split the process in two phases
1, Generation
2, Dispatching

Looking for ideaCant you make use of Print button avaliable in the Report?|||Thanks for your reply.

But the scenario is entierly different in my case. I am using Crystal Reports as window service and the process is splited in two phases

1, Generation
2, Dispatching

One process will generate a document and then save it
the other process will print that generated document

I can generate and print in one process with out storing the file on disk. But i want to do it in two steps.

Regards|||What is the difficulty in doing this in two steps?|||The difficulty is,
I have to create a report in Step one and have to save it to the disk. Right in which format i would store it so i can again open it through crystal report and send its print?

Or is there any other format to store the generated report? SO i can print it again through crystal report.

I don't want to use MS Word or Adobe automation for printing.

Regards|||If you show the report in your application, enable print button so that you can print it from CR|||Madhi
Thanks for the reply but i think you are not getting the issue which i am facing.
My application runs as Windows Service it has no GUI.
Also first i have to create a report , save it to the disk. The other process will print that saved report file.

I can save the report in pdf, word and other suported formats but to print pdf i have to use Adobe or to print word i need MS Word. Which i don't want.

I directly want to print the saved file.

Regards|||Well. Which front end application are you using?|||There is no such Front End.

The request is submitted to the data base and the application checks the data base for any new request.

On the new request it generates the report and stor/export in specific format also updates the data base.

The other application picks the stored documents/files and prints then, email or fax them then again update the database.

Email and Faxing is working well but the print is creating problem as i described in my previous reply.|||See if you are able find solution here
http://support.businessobjects.com/

Print Multiple Documents with VS2005 Local Report

Hello all.
I have a document (that could be for example an invoice) that was done with
VS2005 Local Report. This document is exported to PDF in the application
(with response.OutputStream.Write).
Now I want to be able to print multiple documents (for example invoices), by
generating a PDF with all the documents selected by the user.
I can generate as many local reports as i want to with the desired data. But
how can i export them to a single PDF file?
I will appreciate any comments.I am trying to do this also -- except printing, does anyone have any
suggestions? I can call the report over and over again, but then I get a
print dialog for each iteration of the report.
Thanks!
"Orlando" wrote:
> Hello all.
> I have a document (that could be for example an invoice) that was done with
> VS2005 Local Report. This document is exported to PDF in the application
> (with response.OutputStream.Write).
> Now I want to be able to print multiple documents (for example invoices), by
> generating a PDF with all the documents selected by the user.
> I can generate as many local reports as i want to with the desired data. But
> how can i export them to a single PDF file?
> I will appreciate any comments.|||Just to say that I solved this problem by redesigning my local reports to
support multiple documents.
I couldn't find another way to do this.
"Joel" wrote:
> I am trying to do this also -- except printing, does anyone have any
> suggestions? I can call the report over and over again, but then I get a
> print dialog for each iteration of the report.
> Thanks!
> "Orlando" wrote:
> > Hello all.
> >
> > I have a document (that could be for example an invoice) that was done with
> > VS2005 Local Report. This document is exported to PDF in the application
> > (with response.OutputStream.Write).
> >
> > Now I want to be able to print multiple documents (for example invoices), by
> > generating a PDF with all the documents selected by the user.
> >
> > I can generate as many local reports as i want to with the desired data. But
> > how can i export them to a single PDF file?
> >
> > I will appreciate any comments.

Print directly frm PDF format

hi,
is there any ways to print the reports directly frm the web application by
rendering the reports to pdf format?
regards
AngelaThe user will have to export the report to PDF first and then print. There
is no way for Report Manager to automate this.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angela" <Angela@.discussions.microsoft.com> wrote in message
news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
> hi,
> is there any ways to print the reports directly frm the web application by
> rendering the reports to pdf format?
> regards
> Angela|||hi,
in that case, there is no other way whereby i can call to print the report
directly from my application? because i have tried rendering my report to
html format and the print result is different from reporting services print.
because the page number is different.And i cant use the method
"&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" because it will
promt the user the option to select printer whereby my user will print multi
reports at a click. so this will result the active x to prompt multi print
dialog.
regards
Angela
"Daniel Reib [MSFT]" wrote:
> The user will have to export the report to PDF first and then print. There
> is no way for Report Manager to automate this.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Angela" <Angela@.discussions.microsoft.com> wrote in message
> news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
> > hi,
> > is there any ways to print the reports directly frm the web application by
> > rendering the reports to pdf format?
> >
> > regards
> > Angela
>
>|||That is correct. You would need to solve this in your application. Your
app could display EMF rather then HTML and then just print the EMF and the
user would be viewing what they would print, however you would loose
interactivity.
The problem with using HTML is it does not print nicely. This is why we
created the ActiveX control to print reports. The activeX control uses EMF
to print reports. Because this is a different format (different from HTML)
the pages don't always line up. RS does not expose any mechanism for
printing the current HTML page.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angela" <Angela@.discussions.microsoft.com> wrote in message
news:9E2C9F73-67EF-4D54-B294-61ADBA4A2FA1@.microsoft.com...
> hi,
> in that case, there is no other way whereby i can call to print the report
> directly from my application? because i have tried rendering my report to
> html format and the print result is different from reporting services
> print.
> because the page number is different.And i cant use the method
> "&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" because it
> will
> promt the user the option to select printer whereby my user will print
> multi
> reports at a click. so this will result the active x to prompt multi print
> dialog.
> regards
> Angela
>
> "Daniel Reib [MSFT]" wrote:
>> The user will have to export the report to PDF first and then print.
>> There
>> is no way for Report Manager to automate this.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Angela" <Angela@.discussions.microsoft.com> wrote in message
>> news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
>> > hi,
>> > is there any ways to print the reports directly frm the web application
>> > by
>> > rendering the reports to pdf format?
>> >
>> > regards
>> > Angela
>>|||hi,
so in that case can i say i jux format my reports to EMF rather den html to
get the issue solve?
or is there an example or smaple for this calling format?
regrads
Angela
"Daniel Reib [MSFT]" wrote:
> That is correct. You would need to solve this in your application. Your
> app could display EMF rather then HTML and then just print the EMF and the
> user would be viewing what they would print, however you would loose
> interactivity.
> The problem with using HTML is it does not print nicely. This is why we
> created the ActiveX control to print reports. The activeX control uses EMF
> to print reports. Because this is a different format (different from HTML)
> the pages don't always line up. RS does not expose any mechanism for
> printing the current HTML page.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Angela" <Angela@.discussions.microsoft.com> wrote in message
> news:9E2C9F73-67EF-4D54-B294-61ADBA4A2FA1@.microsoft.com...
> > hi,
> > in that case, there is no other way whereby i can call to print the report
> > directly from my application? because i have tried rendering my report to
> > html format and the print result is different from reporting services
> > print.
> > because the page number is different.And i cant use the method
> > "&rs:Command=Get&rc:GetImage=8.00.1038.00RSClientPrint.html" because it
> > will
> > promt the user the option to select printer whereby my user will print
> > multi
> > reports at a click. so this will result the active x to prompt multi print
> > dialog.
> >
> > regards
> > Angela
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> The user will have to export the report to PDF first and then print.
> >> There
> >> is no way for Report Manager to automate this.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Angela" <Angela@.discussions.microsoft.com> wrote in message
> >> news:36443488-ED64-4175-87E0-B01DDAD07DF6@.microsoft.com...
> >> > hi,
> >> > is there any ways to print the reports directly frm the web application
> >> > by
> >> > rendering the reports to pdf format?
> >> >
> >> > regards
> >> > Angela
> >>
> >>
> >>
>
>

print blank page

i export my report to pdf and its leaving one blank page with every alternative page

is there any setting?

thanks

Make sure your layout, pagesize and margins all agree. Also, search this forum. This topic has been addressed several times in the past.|||Look at the report body width. If, for example, you set your margins to .5" on a portrait report, in this situation your body may be 7.500001". I have found this from time to time. The amount is so slight that looking at it won't do you any good. Click on the body and look at the width, then try to find the object that is causing the width to exceed your margins. I would first check your table width.|||

I'm using landscape and in my body property

width=11in

height = 4.125in

what does it mean, i have to reduce the width or height?

thanks a lot

|||

i fixed myself

i have to reduce the width size

|||

The trick to landscape vs portrait reports is by default portrait is set to 8.5 x 11 in the report properties. All you have to do is flip these two values around.

Jon

print / export SSRS report from t-sql

Greetings,

I have a report that I would like to execute (export to PDF) from t-sql. I can view it interactively from the SSRS website; I can view it from my asp.net application; I can also create the PDF programmatically from the asp.net front-end, but I need to run a batch type query from a stored proc with a report(PDF) as the output...

For example, I want to create and send out a PDF based on a trigger....

How do I do this from t-sql?

Any ideas?

Thanks.

Dan

Web Service calls are only hard to implement in TSQL, close to say that this is not possible. Would could be done is to write an application and execute this application on a trigger base with passing the needed parameters to it..BUT..Keep in mind that triggers behave synchronously, which means that the execution and the lock will be hold until the processing of the trigger is finished. So you have to be careful if you really want to do this on a trigger base rather than starting a job e.g. every minute.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Thanks Jens -- I think I'll just fall back to using the front end application to initiate it. Maybe MS will help out in the future....

Thanks again.

preview and print pdf reports

I have few reports which i need to distribute to a lot of clients and I
have following requirements on the clients:
- preview reports
- print reports
- count the number of printed pages (if the report is printed), this is
absolutely necessary functionality because clients are charged by the
number of printed pages
Currently I'm transferring dataset to the clients, and printing reports
using PrinterDocument...
I found that pretty clumsy, specially when adding new report: I had to
upgrade server, clients, create new printing functionality...
I was thinking about some other options and the most interesting so far
is to use SQL Server Reporting Services for creating reports on the
server. Clients will then download/open reports.
Adding new reports will be as simple as generating new report on the RS.
The missing part is a component for preview/print/count pages on the
client. I need options to view html or pdf reports on the client.
So I'm looking for the component which could preview/print/count pages
of the html or pdf document.
Any experience with such a component.
Any other ides for the the solution of the problem are welcome too.
Thanks,
Igor.It looks like you may have to do some serious programming to pull this off.
You could use the web service to render the PDF to a file on the server,
then count the pages by inspecting the PDF.
I'm not sure that you can programmatically count the number of HTML pages.
From what I've read, it's pretty arbitrary how they're broken out.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"ianic" <ianic@.inet.hr> wrote in message
news:uSSOwvKzEHA.3512@.TK2MSFTNGP10.phx.gbl...
>I have few reports which i need to distribute to a lot of clients and I
>have following requirements on the clients:
> - preview reports
> - print reports
> - count the number of printed pages (if the report is printed), this is
> absolutely necessary functionality because clients are charged by the
> number of printed pages
> Currently I'm transferring dataset to the clients, and printing reports
> using PrinterDocument...
> I found that pretty clumsy, specially when adding new report: I had to
> upgrade server, clients, create new printing functionality...
> I was thinking about some other options and the most interesting so far is
> to use SQL Server Reporting Services for creating reports on the server.
> Clients will then download/open reports.
> Adding new reports will be as simple as generating new report on the RS.
> The missing part is a component for preview/print/count pages on the
> client. I need options to view html or pdf reports on the client.
>
> So I'm looking for the component which could preview/print/count pages of
> the html or pdf document.
> Any experience with such a component.
> Any other ides for the the solution of the problem are welcome too.
> Thanks,
> Igor.
>
>