September 19, 2008 at 7:25 am
Hi there,
I am currently developing a report which takes Sales Orders and assigns units from either stock or already raised Works Orders to the Sales Orders.
The logic to do this seems to be a bit complex for SSRS as there are four fields in a table which need to be populated and the values are dependent on the other three fields. I am currently trying to add the logic to the report in the form of embedded VB.net code.
However, I have hit a brick wall in that I can't figure out how to reference a dataset or sets from within either embedded code or a custom assembly.
Is it possible to get my code to do the following:
1. Check the values in the field calling the function and the other three related fields
2. Update the availability of units when one is assigned to an order
Any advice would be greatly appreciated.
Thanks
April 22, 2010 at 7:36 am
Did you ever figure out how to do this? I am facing a similar situation and no luck finding a resolution...
April 22, 2010 at 7:54 am
In the end, I found the task I was trying to accomplish was easier done server-side in a stored procedure.
Using this approach I was able to obtain a list of orders and then examine current stock and planned work in turn to see when the order could be fulfilled.
I then just called the stored procedure from my SSRS report.
I've attached the final sp that does this but I'm not sure how useful this will be to you as it is specific to our MRP system - Access Supply Chain.
HTH,
Chris
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply