Report Designer Field Expression

Permanently deleted user

October 04, 2017 15:15

I need to obtain the min / max dates from the database table feeding my report. Out of the dozens of sample dates listed, I only need to show the min(sample_date) and max(sample_date) in the report header

 

DATAFIELD = min(Sample_Date) does not render a value

 

Want I'd like to display is:

 

min(sample_date) " to " max(sample_date)

 

How can this be achieved?

 

Any help would be appreciated.

 

Walter

0

• 

  Permanently deleted user

  October 05, 2017 07:54

  Hi Walter,

   

  The first option that I can think of is include your date range field in the dataset that feeds the report.

   

  I assume that you have a workflow that populates a dataset and calls report generation with TemplateReport activity. In the workflow you can create a dictionary with value that you want display and add dictionary to your dataset. In the template you can use your field as and where you like.

   

  I hope this helps

   

   

  0

Please sign in to leave a comment.