First Create a stored procedure that selects your data
create a crytsal report that user that stored procedure and unchech the field saying "Set parameter to NULL"
from your code create an unstance of your report then pass parameteres as
ReportDocument rpt = new ReportDocument();
rpt.load(server.mapPath("Your Path");
rpt.SetParameterValue("Parameter",value); // here parameters name is the name of parameter in your report which is a stores procedure parameter
DeepZone1
Member
32 Points
44 Posts
Crystal Report Using Parameterized Stored Procedure
Jan 02, 2013 07:36 PM|LINK
Does anyone know any tutorial about creating crystal report, in VS2010, using parameterized stored procedure?
asad.aries
Member
86 Points
37 Posts
Re: Crystal Report Using Parameterized Stored Procedure
Jan 04, 2013 04:53 PM|LINK
yeah sure it's easy
First Create a stored procedure that selects your data
create a crytsal report that user that stored procedure and unchech the field saying "Set parameter to NULL"
from your code create an unstance of your report then pass parameteres as
ReportDocument rpt = new ReportDocument(); rpt.load(server.mapPath("Your Path"); rpt.SetParameterValue("Parameter",value); // here parameters name is the name of parameter in your report which is a stores procedure parameter