How to Print the Records Based upon Search ? ?

Question

0.00/5 (No votes)

See more:

, +

Dear Sir,

Am working on Asp.net , c#, SqlServer 2005.

I have Made a Web Application. In that I have Took Gridview , Textbox and Print button....to search the Records from Large no. of DATABASE and Print it.

So, If i Search the Records, it is searching all the Records related to Search in Textbox.

BUT WHEN I CLICK THE PRINT BUTTON IT IS PRINTING ALL THE RECORDS FROM DATABASE.

So, JUST I NEED TO PRINT ONLY THE SEARCH RECORDS.
Every thing i need it by USING CRYSTAL REPORTS.

now Finally i want to print the Records what ever i have Searched., just by clicking the print button.

Please Please Please Please help me, how to do this ?

Thanks.

Posted 2-Jul-12 1:23am

Ranjith Reddy CSE

Add a Solution

Comments

Ranjith Reddy CSE 2-Jul-12 7:25am

Already , i have Created Crystal Report.....but its printing all the records from database.......Only i need to print SEARCH RECORDS only.

Many thanks in Advance. Please help me my dear EXPERTS.

ZurdoDev 2-Jul-12 8:11am

You'll have to provide some details of what you are doing, like code samples.

dimpledevani 2-Jul-12 8:41am

on print command enter your search condition in where clause and fire the query again to get only the required data or you can use the formula fields of crystal reports also...

sahabiswarup 3-Jul-12 2:48am

Ranjith do one thing after searching u save your search result into a datatable and then generate a HTML report based upon your datatable and print that report.
I hope this will work.

ShaikhM 5-Jul-12 22:28pm

May be you should add a RECORDSELECTION statement to you code for the application to filter the search records.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2013-10-31T02:47:00

Solution 1

To pass multiple values(yes, this's what do you want), check these
Using Multiple Value Parameters to Select Records for your Crystal Reports[^]
Printing Parameter Selections for Multiple or Range Values[^]

Posted 31-Oct-13 2:47am

thatraja