I have a page called with a text box claim no . When the user enters CLAIM no . With the help of the claim no . I should display all the other values fromt the table which is equal to this claim no .

I am new to crystal report 11 and dotnet 2005 web based with VB . i use oracle as my database . Please guide me how to do it . Urgent

I'm assuming that the textbox claim no is on an asp.net page. What you can do is create a crystal report that uses an xsd (XML Data Schema) to design the report. Then, in the asp.net page, you can run the query to return a dataset, and pass the dataset to crystal reports.

Here's a page that describes how - although I think the writer has overdone this a little. You only really need to look at step 1 to create the xsd, step 2 to create the crystal report, and step 5 to learn how to pass the dataset.

I cannot help you if the textbox claim no is actually in a crystal report. (sorry). 

hi raghu,

just check out my article at http://www.vbdotnetheaven.com/UploadFile/joseabie/810242007082431AM/8.aspx