SSRS - Formatting report to print as USPS postcards, example.

  • 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.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • 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

    • set Orientation to Landscape
    • set Width to 11in
    • set Height to 8.5in
    • set Margins all to 0in

    In Body Properties

    • set Width to 11in
    • set Height to 17in

    Add a tablix to the report

    • Delete the header row
    • Delete one column leaving you with two columns
    • Add three more rows inside the group giving a total of four rows

    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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply