You can look at the tables directly and find this out. If your assemblies and operations are always in sequence, you can look at Erp.JobOper for the job you are on, order by assemblySeq/OperSeq and you’ll have what you need. If your assemblies are not done in sequence, then you will need to look at Erp.JobAsmbl and look at the priorpeer, nextpeer, child columns to figure out the assembly sequences.
If you can’t get the fields you want added to the data definition, you can still create an SSRS report from scratch. Create report parameters for job/assembly/operation and any information you need from the end activity. You can then add a button on End Activity that will all the report’s URL passing in the parameter values you need.
I've seen folks use Financial Report Designer for basic reporting. Excel Connect helps with more advanced needs. If you find you are exceeding the capabilities of Excel (in Excel Connect), you could look at writing the report in SSRS. If you do so, I would suggest making it as basic a report as possible (no fancy overlapping columns or things) so that it can easily export to Excel if you need to do further manipulations.The advantage of doing it as an SSRS report is that you could schedule the report and archive it if you wish.------------------------------Fred Zelhart CodaBearsCodaBears, Inc.Roselle IL6306727688------------------------------
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.