Help Needed - Job Traveler SSRS Report

Epicor ERP 10
, ,
1

Hello,

I am editing the Job Traveler SSRS report to include a barcode of the Job Number for use with ECM. I want this barcode to only be displayed on page one of the traveler.

I am running into an issue when I print more than one job traveler at a time, where the job number on the first job traveler prints on all of the job travelers.

My report has multiple datasets, and SSRS is requiring me to use an aggregate function in my expression: =First(Fields!Calc_BCJobNum.Value, “JobHead”). I believe the First() function is the source of my issue, as it is returning the first job number in the query and using that on each traveler. However, I’m unsure of a different method to display the job number.

For the visibility settings, I am using the expression =IIF(Globals!PageNumber = 1, False, True) in my textbox visibility options to show this barcode only on page one.

image
image1171×539 40.3 KB

I have also tried to move the text box out of the report header and into a row group that is being grouped by JobNum, but then I lose the ability to reference the PageNumber in my visibility settings to only show it on Page 1.

I would greatly appreciate any suggestions on how to reference my Calc_BCJobNum field and display only on page one.

1 Like
2

@THAero,

To put non static values in the report header the best method is the Report Properties “Code”. You can set the value inside the Tablix and then get the values in the report header.

SET
image

GET
image

image
image658×519 17 KB

5 Likes
3

I also believe that this should work for you as well. In looking at the screen shot, I see a field in the body of your report for the barcoded Job Number. You add a Text Box in the header with the Expression of (= “" & ReportItems!TxtBCJob.Value & "”). The “*” tells it that it is a barcode and the TxtBCJob is the name of the text box in question from the Properties screen. Then set the Font for the Text Box to your Barcode Font.

image
image698×244 10.2 KB

3 Likes
4

Thank you. I updated the text box in the header to use the expression =ReportItems!TxtBCJob.Value, since the TxtBCJob text box is using the expression =Fields!Calc_BCJobNum.value and it is functioning properly now.

1 Like