How would one go about adding the job# to the shipping label?
I would have hoped it would have been as easy as selecting the field in report builder however I don’t see any useful fields in the existing data set in Report builder.
the data definition is shared with packing slip so im confused why it dosent have the same fields available in reports…
any ideas?
I was always under the assumption that since jobnum was listed as excluded on the ShipDtl record in the packing slip report data definition that you would not be able to use in either report. I know in previous label efforts I have had to copy the RDD and uncheck this field so it was not excluded.
Do you still need help with this? I have customized most of my reports, so I think I should be able to help you with it! Unfortunately it is not very intuitive, and requires a little extra work. Let me know if you need me =)
ya help would be useful. the shipping label is called from packing list but theres no apparent rdd for a shipping label… i found genship but it points to a different report style called bartender label… now im confused lol
Woof. Okay, I just need to know what you have done so far. Have you created a new report definition? It sounds like you have created a custom packlist, is that true?
Your right. i have made a copy of the SSRS shipLabel and PackSlip and Duplicated the RDD for pack slip and pointed it to my custom pack slip. that works great.
i added a logo to the shipping label but the default template dosent have Job# on the label which id like to add.
PackSlip Report Style looks like this
i assume the second half of the report location is whats pointing it to my copy of the label report. which works but im having trupble getting the new field to the report…
I copied my ShipLabel report and manually added JobNum to the data defenition query and on the report
now i assume somehow i need to figure out how to add the RDD but i cant figure out what Data defenition the lable uses…
Okay great! that makes a lot of things easier for me then. What you need to do is go to the report data definition for your customized packingslip. so, my customized RDD is NET-Packslip. Expand the tree on the left hand side, expand the report tables, and in the tree view, select the “ShipDtl” table. On the tabs in the form, go to “Report table” > “Exclusions”. Scroll down until you see the JobNum field, and uncheck the boxes.
Save that, and try printing the report again. IF you did everything correctly, then it should now show up, if not, then I need to look into the SQL of how you called it.
Yup did that part.
here is original that works but has no jobnumber
i added this in the copy (shiplabl1 is the new report name in ssrs)
i added T1.JobNum in the SQL
and field JobNum JobNum in the fields.
but if i run this report it dies… (by changing in Report Style the ShipLabl to ShipLabl1)
Change it to T2.JobNum in the SQL.
T2 is the ShipDtl table where the JobNum lives. You currently have it on the ShipHead table.
Dang it you beat me to it! That is the issue. T2.JobNum, not T1.JobNum
that was the huckleberry!!
sweet. thanks guys. i knew i was close…
you guys are great thanks
