I hope so I am not the first one who has this requirement. I have the requirement that on the based of the users input I should get the value for another field. Sounds easy but this value should be get from combination of activedirectory and StoreProc.
I have a custom Project that extends ReportingService.Interfaces ie IDB...
1) Create a Connection string based on what input the programmer has set during creating datasource while creating the report. -- COMPLETED and Working fine
2) Based on the commandType -- Send the Command text to the function that will call the storeproc and also active direcotry and get the values -- This is working fine only when the CommandType is set to TEXT and "select * from Locations" which
will give @StoreNo
But Now I have to pass the storeproc with the parameter ie in the text it will be "exec uspselectdeptByLocations @StoreNo" WHAT SHOULD BE DONE... How can I pass the parameter value to this custom dataextension. I know this is not at all good explanation
but I need help.
My custom dataextension should accept any commandType with dynamic parameter value.
View Complete Post