Custom reports based on inventory model?
Hello,
I'd like to generate a number of reports with an inventory model as the context of the report - e.g. which projects used a particular inventory model over some period of time.
Creating the SQL queries has not been a problem, but getting a reference to the inventory model is where I'm stuck. Is there any way to generate a report where an inventory model will be passed in as the RESOURCE_ID parameter? Or any other way of getting an inventory model as the context of a custom report?
The nearest I can come up with is to do a global report with a text param where the user can paste the name of the model and then use
WHERE resource_name = $P{NAME}
but that's not ideal.
-
Hey Ben, usually that's done as a text parameter as you said, though usually with the model barcode instead of the name (especially if using the size field). That way you could also use a scan gun if you have the model barcode posted somewhere or have a cheat sheet.
Let me know if you need assistance with report development. I provide a lot of custom reports for Flex clients.
-
Hi Ben,
I'll second Aaron's advice here. There's at least one embedded report that uses the unit as the context in just this way, but via the barcode: Serialized Container Manifest. Barcodes are required to be unique within a system, so they are an easy, reliable way to get that context.
Please sign in to leave a comment.
Comments
2 comments