SSRS report for printing labels using a BradyPrinter i7100

Kinetic ERP
, ,
1

Hi everyone,

I’m working on creating an SSRS report for printing labels using a BradyPrinter i7100, and I’m running into issues with getting the correct layout and sizing.

Requirement:

I need to print labels with the following dimensions:

  • Label Size: 0.25" (Height) × 0.9" (Width)

  • Horizontal Repeat: 1.125"

  • Vertical Repeat: 0.35"

Issue:

When I configure the report and print using SSRS Client Print, the paper size values appear incorrect (e.g., Paper Height = 25, Width = 35), and the output is not aligning properly with the actual label.

It seems like SSRS is using hundredths of an inch, but even after adjusting:

  • The label either prints too small

  • Or does not align correctly with the label spacing on the roll

What I’ve Tried:

  • Setting Report Page Size to 0.9in × 0.25in

  • Setting all margins to 0

  • Testing different page sizes including 1.125in × 0.35in to match label pitch

  • Checking printer driver settings for custom label size

Printer Dinensions:

image
image1275×792 99.6 KB

Report Builder:

image
image997×513 86.8 KB

Report Printed from print preview:

image
image1900×930 191 KB

Report output on label roll:

image
image471×391 39.6 KB

Getting Spacing, want to remove spacing.

Questions:

  1. What is the best practice for handling label spacing (repeat distance) in SSRS?

  2. Should the report page size match the label size or the repeat size?

  3. Has anyone successfully configured SSRS with Brady printers (i7100 or similar)?

  4. Are there any specific printer driver or SSRS settings required to avoid scaling issues?

Any guidance, sample RDLs, or suggestions would be really helpful.

Thanks in advance!

2

Always a challenge with trying to get labels to work with SSRS. You have done a great job explaining and presenting the problem.

Rather than using the preview, try using the preview in report builder and check the layout there, just make sure you use the correct output layout.

The other thing if I recall that there was an example in the documentation (some where) for getting multi column labels working. I’ll have a dig around, not guaranteeing anything there.

I am not familiar with that brand of printer, but normally the label size is based on the media, maybe the form size is incorrect in the printer driver (printer settings) giving all that white space.

3

@Kshitij @Hally

Yes. Instead of printing directly from SSRS, the better solution is:

Epicor → BAQ/SSRS Export → CSV File → Brady Workstation (just check if setup auto-picks files) → Brady i7100

Create the label template in Brady Workstation, map the CSV fields, and print automatically. This is typically more reliable and easier to maintain than SSRS label printing for Brady printers.

4

That’s pretty much how bartender works. You will find examples here for creating a file from a baq… of course you could call the export baq service as well.

5

Check your paper height and paper width in Printer Maintenance. You will want to make sure the paper height is set to the height of one label (or the label and space between) and the width is set to the full width of the 3 side by side labels.