Web report parameters

iomega55 · Post by **iomega55** » Mon Sep 25, 2006 1:49 am

Hi:
First at all, thank you for response all our questions.

The most of the reports we have at this moment are involved with parameters, more clear stored procedures with parameters.

For example I have a web form named MyWebForm.aspx with 2 textboxes and 1 button. So how can I pass the value from the textboxes to my report.

I see http://forum.stimulsoft.com/Default.aspx?g=posts&t=105, but it could be helpul if you can give a short sample

Can you please share a sample with stored procedures with parameters as the datasource of the report, when the parameters are sent via the click event from a web form

Thanks.

iomega55 · Post by **iomega55** » Mon Sep 25, 2006 2:08 am

I found this:
http://forum.stimulsoft.com/Default.aspx?g=posts&t=84

One question is, how must I create my report in designer if my datasource is a stored procedure with parameters. I saw the tutorial, but I suppose it uses a stored procedure with no parameters.

Please dont forget the sample

.

Post by **Vital** » Mon Sep 25, 2006 3:59 am

Please see SqlParameters sample project from DEMO pack. This sample project created for winforms, but you can use this way in Web too without changes.

Thank you.

iomega55 · Post by **iomega55** » Mon Sep 25, 2006 3:13 pm

Thanks.

But I'm sorry

How must I create my report in designer if my datasource is a stored procedure with parameters. I saw the tutorial, but I suppose it uses a stored procedure with no parameters.

I think I need to create the params for the datasource, and give them some value just for the datasource creation, and the rest is the way you mention in the sqlparameter sample. Is this correct?

this is the stored procedure who receives a parameter.

- execute TableA_GetByKey @Key

- Create @Key parameter

- when I run the process it returns the statement executed with sucesss

- but when I retrieve columns it returns I must declare scalar value @Key

remus · Post by **remus** » Mon Sep 25, 2006 8:20 pm

Hi
I also would like a clear example of using stored procedures with stimulreport.
It would be greatly appreciated.
Thanks
Philip Andrews

Post by **Vital** » Tue Sep 26, 2006 5:52 am

Please check following Flash Demo: How to use Sql Parameters in Web

Thank you.