sessions and crystal reports [Resolved]

Posted by Samanthajyesta under ASP.NET on 6/8/2010 | Views : 3634 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

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

0	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

0	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

Latest Posts