Page 1 of 1

How to use stored procedure in Client/Server

Posted: Fri Dec 21, 2012 10:57 am
by flip
Hi,
i am using the latest version of the Silverlight designer, as client - server.
I would like to use a stored procedure in my report.
When I do Add datasource, the stored procedure is listed in the dialog. When I select a stored procedure, it is added in the dictionary panel, but the columns and parameters are not present.
So I can drag the stored procedure to the report design surface, but I can't show any data of it, because it has no columns.

Can you tell me why the columns are not shown, and how to show them?

Re: How to use stored procedure in Client/Server

Posted: Fri Dec 21, 2012 1:26 pm
by HighAley
Hello.

You should use the Retrieve Columns button in the Edit Data Source dialog.
RetrieveColumns.png
RetrieveColumns.png (98.81 KiB) Viewed 3615 times
Thank you.

Re: How to use stored procedure in Client/Server

Posted: Thu Dec 27, 2012 8:32 am
by flip
Thanks Aleksey,
that does work.

Re: How to use stored procedure in Client/Server

Posted: Thu Dec 27, 2012 1:52 pm
by HighAley
Hello.

We are always glad to help you.

Thank you.