July 29, 2018 at 10:38 am
In a new ssrs 2012 report, I need to write a report that is written like mailing labels. Basically I need to generate activity cards for a large school district.
I would like to know how to get unique information for each of the 10 students on the 10 different activity cards. The activity cards are to be able to fit in
a student's wallet.
The requirements are the following requirements:
1. Print 10 activity cards per 8 1/2 by 11 sheet of paper.
2. There will be 2 columns and 5 rows per sheet of paper.
3. Just for your information, the activity cards will list the following:
a. student name and number,
b. student address,
c.. school name and address,
d. grade level.
Thus can you tell me how to generate unique information for 10 students that are generated like mailing labels?
July 29, 2018 at 11:16 am
Brian Larson walks through a scenario like this in his SSRS 2012 book.
After some Googling...
http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/creating-mailing-labels-in-sql/
July 29, 2018 at 9:21 pm
Thank you for your answer so far!
However I have the following additional questions to ask
1. I need to print some static information on each card before unique information for each student is to be displayed.
2. I also need to print some information on the back side of the activity cards.
Can you tell me how to accomplish this goal?
August 4, 2018 at 2:52 pm
For static information, just drop in a textbox... (Haven't you used SSRS for the past 2 years or so now?)
For the back side... might be a little trickier... You need odd/even pages and then print evens first, flip the labels over, print on the other side.
If a textbox doesn't work, drop a List on there and then add a textbox to that.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply