December 6, 2019 at 7:35 pm
Hello all,
I have to create an SSRS Report that will print as a USPS postcard, on both sides of a sheet of paper
The rectangular postcard must follow the dimensions below:
4-1/4 inches high x 5-1/2 inches long
The dimensions of the paper they will print on are:
8-1/2 inches high x 11 inches long
Four postcards can be printed on each 8-1/2 x 11 sheet of paper.
I have not prior experience in designing a report of this kind, just one sided, standard report.
I tried to search for examples online, but I get too many postcards printing companies, and stuff not SSRS related, or other reporting software. I thought I should ask in this forum, perhaps find someone with experience working non a report like this one. Hopefully willing to share an example or an explanation on how to set it up.
At any rate, I appreciate any help on this, in advance.
Thank you.
December 7, 2019 at 8:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 27, 2019 at 4:33 pm
There might be a better way to do this as this is a proof a concept. I'm not sure what you are trying to print on the postcards so this example assumes one textbox on the front and one textbox on the back of the postcard. My RDL file is attached.
Here is some sample data with text to print on front and back.
select
PageNum,
max([1]) as Q1Front,
max([2]) as Q2Front,
max([3]) as Q3Front,
max([4]) as Q4Front,
max([5]) as Q1Back,
max([6]) as Q2Back,
max([7]) as Q3Back,
max([8]) as Q4Back
from (
select
(Id / 4) + 1 as PageNum,
(Id % 4) + 1 as QuadrantFront,
(Id % 4) + 5 as QuadrantBack,
Front,
Back
from
(
select Id, Front, Back
from (values (0,'0F','0B'), (1,'1F','1B'), (2,'2F','2B'), (3,'3F','3B')) p(Id, Front, Back)
) as x
) as src
pivot ( max(Front) for QuadrantFront in ([1],[2],[3],[4]) ) as f
pivot ( max(Back) for QuadrantBack in ([5],[6],[7],[8]) ) as b
group by PageNum
In Report Properties
In Body Properties
Add a tablix to the report
Assign the data as follows
[Q1Front] [Q2Front]
[Q3Front] [Q4Front]
[Q2Back] [Q1Back]
[Q4Back] [Q3Back]
When printing to a printer, print on two sides, flip on short edge.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply