how to pass parameters from dropdownlistcontrol in crystal reports

Posted by Charan44 under Regular Expressions on 6/1/2011 | Points: 10 | Views : 2847 | Status : [Member] | Replies : 3
hi,

iam having two tables dept and employe

dept
====

deptno int primary key
deptname varchar(50)
dloc varchar(25)

employe
========

empno int primary key
empname varchar(50)
salary money
deptno int foreign key




i want to display all deptno values in dropdownlist control when user select the deptno then all details of employe table and dept table i want to display in crystal report

can you give example which helps me




Responses

Posted by: Bugwee on: 6/1/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

first, you need to create a stored procedure that will have a parameter for deptno then add the stored procedure on your crystal report.
lastly, in your CR code just add this one
rptDoc.SetParameterValue("@deptNo", yourdropdownlist.selectedvalue)


Regards,
Bugwee

Charan44, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lakn2 on: 6/3/2011 [Member] Starter | Points: 25

Up
0
Down
try this


http://www.dotnetspider.com/resources/15820-show-reports-using-stored-procedure.aspx

http://www.c-sharpcorner.com/UploadFile/13af8f/6863/

Thanks&Regards
LakshmiNarayana Nalluri.

Charan44, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Susanthampy on: 6/3/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi

try this links,

http://www.pdssoftware.com/newsletter/mar07/page6.htm
http://msdn.microsoft.com/en-us/magazine/cc301570.aspx

Regards,
Susan

Charan44, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response