How to set title of crystal report dynamically with coding

Question

2.00/5 (4 votes)

See more:

Hello, i am working with crystal report. I want to do the crystal report's title dynamically with the usage of coding not static in the vb.net. the report title should be dynamic means if I have selected from combo and I want to show that selected item in the report title , it should be display in the crystal report title.

Help me..

[edit]SHOUTING removed - OriginalGriff[/edit]

Posted 23-Mar-12 18:55pm

Dipak V Nakum

Updated 14-Apr-20 18:42pm

OriginalGriff

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 24-Mar-12 1:00am

Please stop shouting. I mean, ALL CAPS is considered shouting on the Web, and rude. Please use correct capitalization, if you want to be taken seriously.
--SA

Dipak V Nakum 24-Mar-12 1:06am

Dear SAKryukov ,i knowing very well ,if you know the answer then post it else seat silently.

Dipak V Nakum 24-Mar-12 1:06am

Dear SAKryukov ,i knowing very well ,if you know the answer then post it else seat silently.

Sergey Alexandrovich Kryukov 25-Mar-12 4:07am

"Post silently" is extremely rude. You are not welcome here.
--SA

OriginalGriff 24-Mar-12 4:10am

DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.

Dipak V Nakum 24-Mar-12 4:12am

dear OriginalGriff, if u know answer then post it else its worth less dear.

OriginalGriff 24-Mar-12 4:13am

Reason for my vote of one: Rudeness. SA was being polite, and informing you that you had accidentally or deliberately been rude, and that you would improve your chances of an answer if you changed UPPER CASE to a more conventional case.
There is no reason to be rude to people who are trying to help you - it does not encourage others to assist you at all.
Think about it. We aren't paid to be here, you don't pay to receive help. Annoying people is not a good way to get their assistance.

Sergey Alexandrovich Kryukov 25-Mar-12 4:12am

I appreciate it. I cannot understand such behavior.
--SA

4 solutions

Solution 1

Well, you can just add a new Formula Field and pass value to that formula field from your vb.net.

That's it.

Hope this will solve your problem.

Posted 23-Mar-12 22:27pm

VikashGohil

Solution 3

hi Dipak.
u can use "Report Title" or "Report Comments" Or "File Author" Field in Special Fields Section of Crystal Report Designer and place them title section of your crystal report and set values of these fields in coding as shown example

VB

Private Sub BtnOk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnOk.Click
      Me.ViewReceiptTableAdapter.Connection = Connection
      Me.ViewReceiptTableAdapter.FillByDate(Me.DSetFeeReports.ViewReceipt, Me.DtDate.Value)
      CryDailyCollection1.SummaryInfo.ReportTitle = " Report Of " & ComboCity.text & "City"
      CryDailyCollection1.SetDataSource(Me.DSetFeeReports)

      Me.CrystalReportViewer1.ReportSource = CryDailyCollection1

  End Sub

This is easiest way to set dynamic Title of any crystal report.
i hope this solve your problem

Posted 23-Mar-12 23:17pm

Avneesh Sharma jaani

Solution 4

You can use crystal report's parameter field as the report title.

Dynamic values can be assigned to parameters.

Let me know in case you need more info.

Bhakti

Posted 25-Mar-12 9:20am

Member 2741192

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)

Dipak V Nakum · Accepted Answer · 2012-03-25T17:28:00

VB

Dim RPTTITLE As String
 
Try
Dim tmp As String
 
If ddlactive.SelectedItem.Text = "Yes" Then
tmp = "Y"

ds1 = con.FetchData("select * from computer_mast where type='" & ddlOpt.SelectedItem.Text & "' and active='" & tmp & "' order by deptname,ip ")
RPTTITLE = "Active " & ddlOpt.SelectedItem.Text & " Users"
ElseIf ddlactive.SelectedItem.Text = "No" Then
tmp = "N"
ds1 = con.FetchData("select * from computer_mast where type='" & ddlOpt.SelectedItem.Text & "' and active='" & tmp & "' order by deptname,ip ")
RPTTITLE = "Not Active " & ddlOpt.SelectedItem.Text & " Users"
End If
 
If ds1.Tables(0).Rows.Count > 0 Then
lblErr.Visible = False
rptname = "~/Reports/Report3.rpt"
con.con.Open()
rpt.Load(Server.MapPath(rptname))
rpt.SetDatabaseLogon("wml", "win")
rpt.SetDataSource(ds1.Tables(0))
rpt.SummaryInfo.ReportTitle = RPTTITLE
 
CrystalReportViewer1.ReportSource = rpt
 
rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, False, "ExportedReport")
 
Else
lblErr.Visible = True
End If
con.dttemp = ds1.Tables(0)
Catch ex As Exception
MsgBox(ex.Message)
End Try