# Print Lables from BAQ Report **URL:** \ **Category:** Epicor ERP 10\ **Tags:** baq, reports\ **Created:** [October 9, 2020, 6:57pm UTC](https://www.epiusers.help/t/print-lables-from-baq-report/71692 "2020-10-09T18:57:44Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![FTI-SeniorAdmin](https://www.epiusers.help/user_avatar/www.epiusers.help/fti-senioradmin/32/94053_2.png) [@FTI-SeniorAdmin](https://www.epiusers.help/u/FTI-SeniorAdmin)\ **Post date:** [October 9, 2020, 6:57pm UTC](https://www.epiusers.help/t/print-lables-from-baq-report/71692/1 "2020-10-09T18:57:45Z")
I have a very simple BAQ that I designed, It has 3 columns, Job Number, Part Number, and Serial Number. It’s filtered down at the BAQ level to only include a short list of PN’s so when you run it you see all the SN’s that were assigned to that PN and which job they are on. We want to use this BAQ in a SSRS report to print the SN, out so they can wrap it on a part. I’ve already created the Custom report menu item, and the report itself, and I have on field on the report for just the SN, but the default expression is “=First(Fields!SerialNo\_SerialNumber.Value, “BAQReportResult”)” When the report is run and a Job number (that has multiple assigned SN’s) is entered in the filter, it sadly only prints one page with one SN… I would like it to be one page per SN, what am I missing in that expression to do that? ---
**Author:** ![FTI-SeniorAdmin](https://www.epiusers.help/user_avatar/www.epiusers.help/fti-senioradmin/32/94053_2.png) [@FTI-SeniorAdmin](https://www.epiusers.help/u/FTI-SeniorAdmin)\ **Post date:** [October 9, 2020, 7:18pm UTC](https://www.epiusers.help/t/print-lables-from-baq-report/71692/2 "2020-10-09T19:18:56Z")
I got it! I don’t know if it was the best method or not, but this is how I did it. I inserted a Table wizard and put the Report Result SN field as the “Value” No row group and no column group, no subtotals. Once that was in place, I removed the header column and then down in the Row Groups section I went to group properties for the =(Details) line and in the “Page Breaks” section I checked off the “Between Each Instance of a group” This gave me a cell per page with each one of the SN’s that are associated with the job number I entered in the main report option field. YAY! ---
**Author:** ![FTI-SeniorAdmin](https://www.epiusers.help/user_avatar/www.epiusers.help/fti-senioradmin/32/94053_2.png) [@FTI-SeniorAdmin](https://www.epiusers.help/u/FTI-SeniorAdmin)\ **Post date:** [October 12, 2020, 12:13pm UTC](https://www.epiusers.help/t/print-lables-from-baq-report/71692/3 "2020-10-12T12:13:06Z")
Ok, so in addition to this, does anyone know how to make a field on a BAQ report mandatory and not allow it to be left blank? This BAQ will generate 12,960 pages if the Job number “Option” is mistakenly left blank. There is the immediate printer selection box that comes up after hitting print that should jog the memory of “Did you enter a job number” but I was just wondering if I could prevent the full BAQ from trying to print. ---
**Author:** ![Carson](https://www.epiusers.help/user_avatar/www.epiusers.help/carson/32/28741_2.png) [@Carson](https://www.epiusers.help/u/Carson)\ **Post date:** [October 15, 2020, 1:42pm UTC](https://www.epiusers.help/t/print-lables-from-baq-report/71692/4 "2020-10-15T13:42:44Z")
Three options in increasing difficulty: Set a default value to the option. At least then they had to intentionally clear it out to break it. Modify the report so it doesn’t print if the option field is blank. This is a little ugly since it will generate al the data, but fail to print. Make a BPM or screen customization to error if no option is entered. (Maybe that’s four options) ---
**Author:** ![FTI-SeniorAdmin](https://www.epiusers.help/user_avatar/www.epiusers.help/fti-senioradmin/32/94053_2.png) [@FTI-SeniorAdmin](https://www.epiusers.help/u/FTI-SeniorAdmin)\ **Post date:** [October 15, 2020, 1:46pm UTC](https://www.epiusers.help/t/print-lables-from-baq-report/71692/5 "2020-10-15T13:46:30Z")
Thanks for the suggestions, I will have to try a few of these options to see what works best.