By using this website, you agree to our Terms of Use (click here)
Any tips for create once, use many times in Report Designer?
for instance. Employees have a lot of fields that are very specific. Branch, Supervisor, Work Calendar, Job Title, Class, Departments, or even # of hours in work week.
with SSRS, i would create a view, then just keep referring back to the view for the employee level reporting needs.
how can i accomplish the same thing in Report Designer, without having to constantly re-build the table joins when i need to access the same info again.
thanks for assistance Members!
Hi HappGilmore,
I don't have a solution unfortunately. If you could figure something out, that would be awesome.
However, I did create an idea out on the Acumatica ideas website to allow a Generic Inquiry (basically like a SQL View) to be a data source in Report Designer. I think this would accomplish what you are looking for if they implemented it:
Here is a link to the idea if you want to vote on it: https://feedback.acumatica.com/ideas/ACU-I-931
That would be great. I am routinely building Generic Inquiries to test that my table relationships are correct, then rebuild them in the Report Designer. Voted for your Idea a long time ago.
I have an Idea out there that I think would be another great addition. Allow a GI to be a table for another GI. Basically the equivalent of a subquery in SQL. Vote here, https://feedback.acumatica.com/ideas/ACU-I-1190