jsutherland_1 Posted August 8, 2017 Share Posted August 8, 2017 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 10The 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now