Skip to Content
Former Member
Sep 11, 2013 at 07:21 PM

Assign value of parameter programmatically then pass to stored procedure


Hi all,

I have been reading on how to do this all day and have not found the answer

I have a reports that receives a single one record XML file that contains a list of order numbers.

I used that XML file in a Formula Field I called OrderList to make a coma delimited list of the orders (Done).

When I added the stored Procedure as a Data Set I saw the Parameter it automatically created.

When I type in a list if Order numbers it works great.

It seems If I could assign my OrderList to that Parameter and disable the prompt my job would be done.

Any Ideas on how i can do this please?

Thanks so very much