I have created a dashboard that houses our Receiving Inspection data, replacing the old paper log that had been used prior. The dashboard works great.
However: There are still inspection stations that do not have access to Epicor and need the log in its paper form. I created a BAQ report that generates a printable log that looks the way its always looked for folks. Problem is, I need a systematic way to print this log every 12 records. 12 records is what fits on one log page so I need the new page to print when it is “full”.
Does anyone have any thoughts about how I might achieve this?
If you are using Crystal, there is a way to create a variable and count the records being processed during the print rendering, and then react at every 12th record with a Page break. I’ve seen it done, but have not done it myself.
If you are using SSRS, this might be more difficult (or impossible) using ReportBuilder, but might be possible if editing using Visual Studio.
I think a google search for ‘page breaks after a number of records’ for both crystal and ssrs might yield some ideas
If I were to try to trigger an alert message every 10 records, telling user to print log, is there a C# expression for the condition that the Receiver (lot) # ends in a 0??
Lot # is a varchar field so string expressions should work.Your condition could be the "lotnum" field of the "modified row" "ends with" the "0" expression
Will be true if the right most character of the string named Receiver is a ‘0’. Might want to add a TRIM() function to filter off any trailing spaces that might work their way in.
Receiver.Trim().Right(1) == '0'
If you really want to do every 12th, first convert the Receiver to an integer, then use the remainder operator.
(Int32.Parse(Receiver) % 12) == 0
will be true when Receiver is a multiple of twelve.
EDIT
FTR - that last one only does every 12th’ if the Receiver Lot#'s are sequential with no gaps or repeats.
looks like I can’t autoprint a baq report from a directive so I’m trying to think outside the box. Thank you so much for the C# bits. They will be handy.
