populate a query subject from a prompt in report studio

[giovanni.lucarelli]

hi!

it's 2 days that i'm looking for solving this problem  ???

this is my situation: I have a "customer" table; In report studio I prepare a prompt to choose a single customer from this table; then the answer of this prompt should to be write in a query subject in my model or in my DB...

:-\

does anybody have some idea?

thanks in advance!!!!

[david.stachon]

you're going to have to clarify what you mean by:

"should to be write in a query subject in my model or in my DB"

...it's not at all clear what you're trying to do.

[giovanni.lucarelli]

sorry, you're right...

I have table "CUSTOMER"; in report studio I need to use a Select and search prompt to recover 1 CUSTOMER_ID; when the user selected this CUSTOMER_ID I want that it will be write in another table in my db (SQL sERVER 2005).... this because all reporting that I'm going to design will be filter by the selected CUSTOMER_ID.

I solved this problem with a store procedure and works ok in Framework manager but I'm not able to call this store procedure in report studio....

thanks very much

[billylodz]

your procedure must return something to be able to use it in RS.

add some select at end and will work