Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    90

    Unanswered: Dynamic Fields Value

    Is there a way to dynamically set the dataset fields value?
    (e.g. =Fields!Item1.Value)

    How can I change this (=Fields!Item1.Value) at runtime from a different from?

    ex.
    from (=Fields!Item1.Value) to (=Fields!Product.Value)

    Thnx in advance!

  2. #2
    Join Date
    Nov 2009
    Posts
    9
    Are you talking CR or VB? If in CR, you could create a formula which returns the correct value based on which value you want to use.

  3. #3
    Join Date
    Sep 2009
    Posts
    90
    in VB.Net RDLC
    I forgot to indicate.

  4. #4
    Join Date
    Nov 2009
    Posts
    9

    Cool Change A Fields Value Dynamically

    The last time I tried to change a field's value dynamically was in VB6 but I would think the same principle applies. The approach I took was to set up all the data fields on the CR report that I needed and then I dynamically was able to control what went on the report by supplying the report with a recordset (under the old ADO).

    In terms of .Net, set up your report based on the data needed and then set the Data Source for the CR from VB.Net with the appropriate dataset (containing the data that you want to appear on the report). If you change the dataset, you change the data that appears on the report.

    That would be the approach that I take. I always found it better (performance wise) to have CR do as little data manipulation as possible. Let the VB format your data and then pass the data to CR for presentation.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •