ansaurus

Question

Answer 1

A:

I've never done anything like that...I'm not sure if it's possible. What will work for sure though is to use a parameter to control the report title. Simply create a parameter and then rpt.SetParamterValue("title", "Some Title")

dotjoe 2010-10-20 14:32:57

HiThanks for your response. and yes, if I was creating all of my reports from scratch then I could do it that way, my reason for asking about doing this in code is that there are already 200+ reports set up and so it is less time consuming executing this through vb code.

Richard 2010-10-20 14:33:49

I see...in order to dynamically change the report, you might need to save it after changing that field and then run it. Can you try a `rpt.SaveAs("test.rpt", RptFileFormat)` and then open it and see if the title was actually changed.

dotjoe 2010-10-20 14:43:03

The problem I have Joe is that the object may not exist on the report so this would throw an error and the report would not load. You get where Im coming from?

Richard 2010-10-20 14:47:41

Answer 2

A:

Since you've identified the problem as "Exists is undefined". Addressing that problem is more straightforward. Try replacing the "Exists" line with:

    If (rpt.ReportDefinition.ReportObjects.Contains("crlTitle")) Then

Were there any other problems?

Eric Towers 2010-10-20 15:16:00

Using this method gives me an IndexOutOfRangeException

Richard 2010-10-20 15:21:19

Having to do this without access to Crystal Reports module (i.e. from Express edition), so the corrected above is probably only close.

Eric Towers 2010-10-20 21:05:53

Answer 3

A:

Here is my solution:

Dim rpt as ReportDocument
Dim rptTextObject as TextObject = nothing
Dim mainColour As Color = Color.Green

Try
    If (rpt.ReportDefinition.ReportObjects("crlTitle") IsNot Nothing) Then
      rptTextObject = CType(rpt.ReportDefinition.ReportObjects("crlTitle"), TextObject)
      rptTextObject.Color = mainColour
      rptTextObject.Text = "Report Title"
    End If
Catch
End Try

I do this for each Object on the report that I want to either set text or set colour.

Richard 2010-10-21 10:50:52

ansaurus

tags:

views:

answers:

Dynamic Crystal Report

related questions