How to use stored procedure in Client/Server

Stimulsoft Reports.Silverlight discussion
Locked
flip
Posts: 23
Joined: Mon Dec 12, 2011 10:47 am

How to use stored procedure in Client/Server

Post 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?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to use stored procedure in Client/Server

Post by HighAley »

Hello.

You should use the Retrieve Columns button in the Edit Data Source dialog.
RetrieveColumns.png
RetrieveColumns.png (98.81 KiB) Viewed 3329 times
Thank you.
flip
Posts: 23
Joined: Mon Dec 12, 2011 10:47 am

Re: How to use stored procedure in Client/Server

Post by flip »

Thanks Aleksey,
that does work.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: How to use stored procedure in Client/Server

Post by HighAley »

Hello.

We are always glad to help you.

Thank you.
Locked