Report Generation of an specific person

Question

0.00/5 (No votes)

See more:

How to generate a report by entering a specific persons any details...For eg:by providng an detail in an text box and diplaying the result

Posted 13-Feb-14 22:56pm

Jinu Jacob

Add a Solution

Comments

thatraja 14-Feb-14 5:50am

which reporting tool?

Jinu Jacob 14-Feb-14 23:37pm

I had been using SQL Server Bussiness Intelligence development studio for building report.

2 solutions

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)

pjeet_4411 · Answer 1 · 2014-02-14T01:26:00

Solution 1

It is dependent on SQL Query like as follows:

DECLARE @SearchWord NVARCHAR(MAX)

SELECT DISTINCT
*
FROM Employee
WHERE
FirstName LIKE '%' + @SearchWord+ '%'
OR LastName LIKE '%' + @SearchWord+ '%'
OR Address LIKE '%' + @SearchWord+ '%'
OR AnyOtherColumn LIKE '%' + @SearchWord+ '%'

Posted 14-Feb-14 1:26am

pjeet_4411

Comments

Jinu Jacob 15-Feb-14 0:00am

Thank You so much....It works for me......

sohail awr · Answer 2 · 2014-02-14T01:38:00

If you are using Crystal Report do these steps

Add Crystal Report references

In your form add these lines at top

VB

Imports CrystalDecisions.Shared
Imports CrystalDecisions.CrystalReports.Engine

VB

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
       Dim Rpt As New ReportDocument
       Dim frmView As New frmCRView  'Crystal Report viewer form
       Dim RptName As String = ""
       RptName = "Report Title"

       Rpt = New Report1 'Your Crystal Report Name

       frmView.CRViewer1.SelectionFormula = ("{Table1.pt_id}='" & Trim(Me.TextBox1.Text) & "'") 'Your selection formula if you need two fields just use this type ("{Table1.pt_id}='" & Trim(Me.TextBox1.Text) & "' and "{Table1.visit_id}='" & Trim(Me.TextBox2.Text) & "'")
       frmView.CRViewer1.ReportSource = Rpt
       frmView.CRViewer1.RefreshReport()
       frmView.Text = RptName & " for Patient: " & Me.TextBox1.Text
       frmView.Show()
   End Sub