Jump to content
We've recently updated our Privacy Statement, available here ×

Set a variable as a title from the fields


jsutherland_1

Recommended Posts

I have a data set that looks something like this with 3 columns of data named Type, Label and Value:

Type                      Label                      Value==================================================================SubHead1                  Fiscal YearTitle                     Equipment ReportData                      Cars                        50Data                      Trucks                      25Data                      SUVs                        10

The Data rows form the pie chart.  The Title and SubHead1 vary depending on the report needs.  I need to have a Text field on top of my report be the value of Label "Equipment Report" when Type="Title" for example to get the right title on the report.  And, then another Text field for the subheading when type is "SubHead1"  I've tried various expressions but none work to grab the right row from the data set for a title or subheading. How can I do this?  Thanks in advance!

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...