Hello,
We have a legacy crystal report which we created for use with Vantage to go down our open job orders and list for each job, it’s current op (lowest level operation on the method not completed), last worked op/last labour date/last worked part (based on most recent labour transaction) - the crystal report has a subreport which handles the lookup against the job operations which couldn’t be handled in the main report. To get this to work requires defining shared variables in the parent report and then updating them in the subreport and finally displaying them in the main report. This all works ok, and we have converted to work with our E10 databases.
However we have a single crystal reports licence so this is run centrally and the output is exported to csv. There is then roughly 30 minutes of daily formatting in excel before this is used in our daily production meetings.
I have been asked to look at getting this working in SRSS so as it can be run anytime and there is no need to mess about with the formatting. Due the complexity of the formatting I can’t do this in a single recordsource and having googled this is it appears that using a shared/global variable is way more complex in SRSS. Parameters don’t work as I need to “return” an updated value from the subreport. Does anyone have any experience of doing this that they can easily explain?
Alternatively is there a way of creating secondary record set/query that could get these values as each row of the parent is created?
Any help suggestion greatly appreciated.