sessions and crystal reports [Resolved]

Posted by Samanthajyesta under ASP.NET on 6/8/2010 | Views : 2463 | Status : [Member] | Replies : 4
Hi sir,
Actually i've 2 lables and 2 textboxes called empid and empname and a button called next. when i click on next, the nextemployee details from database can be shown.
And i've one more button called Generate. When i click on Generate button, one crystal report should be generated with that particular employees empid and empname only.
but when i'm doing this i'm getting entire employee details..
thats my problem.
clarify it as soon as possible.

http://www.dotnetfunda.com


Responses

Posted by: Muhilan on: 6/9/2010 [Member] Starter

Up
0
Down

Resolved
if you are retrieving records using SQL querying use where condition

ex..
select * from t.b where empid = textbox1

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

Posted by: Vuyiswamb on: 6/9/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Well my Crystal reports Skills are not string, i use the GRid to show my reports in my applications, But it seems like you need to filter the data based on the field that determines that record uniquely. That means you need to pass a parameter to Crystal report so that it will display only that record .

I have found this for you

http://aspalliance.com/1833
http://www.c-sharpcorner.com/UploadFile/mahesh/paramInCR11012006132839PM/paramInCR.aspx
http://p2p.wrox.com/book-professional-crystal-reports-vs-net/17318-how-pass-parameter-crystal-report-using-c.html

Thank you for posting at Dotnetfunda

Vuyiswa

Thank you for posting at Dotnetfunda
[Administrator]

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

Posted by: Samanthajyesta on: 6/10/2010 [Member] Starter

Up
0
Down
hi
i got solution for my problem .
i used stored procedure to display a particular employee details.

http://www.dotnetfunda.com

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

Posted by: Samanthajyesta on: 6/23/2010 [Member] Starter

Up
0
Down
hi sir,
can we write a sql stored procedure with out using parameters for an insert command.
my s.p. is like dis...
insert into emp(id,name) values(@id,@name).
how can we write @id and @name with out declaring the parameters.

http://www.dotnetfunda.com

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

Login to post response