Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

duplex printing Expand / Collapse
Author
Message
Posted Saturday, March 15, 2008 3:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 10, 2012 7:38 AM
Points: 3, Visits: 105
Here is what I have to do:

I need to make a report that prints on both sides of the paper. The front will be the table, image, footer, headers, etc. The back of the paper will be a company disclaimer sort of thing. It is just simple text. The back will be the same for all printouts.

I tried to make a report and use the PDF files to print this. The front works OK but I couldn't make the back differently than the front.

So if in the PDF files,
page 1: front,
page 2: back, (disclaimer)
page 3: data, front
page 4: back (disclaimer) same as page 2,
...
...

Then all I need to do is to set the printer to print on both sides.

Yet, I couldn't find a way to do this in reporting service 2005.

This seems to be a very common business requirement. So unless I am missing something, please let me kow if there is native support for this in SSRS 2005. If there is no native SQL support for this, then what options do I have?

Thanks,
Post #469906
Posted Saturday, March 15, 2008 5:11 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:44 AM
Points: 1,073, Visits: 6,334
One way to do that is create an additional RDL file for the disclaimer and insert that as a subreport after your 1st and 3rd page, using appropriate pagebreaks; might have to place the subreport in a rectangle.

Then in the header use an expression to determine if it should be displayed. For example if the header has a single textbox set the visibility property of the textbox like this.
=iif(Globals!PageNumber mod 2 = 0 ,true,false)

Post #469911
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse