possible formula question

[espltd]

I have a string field that typically only has three different values for an entire dataset. So for example
row # location
1 Calif
2 Calif
3 Ariz
4 Calif
5 Nev
6 Calif
I was just wondering if there is a way to only display the unique string values in the header of the report, possibly using a formula? So in the header I would want something like
location 1 Calif
location 2 Nev
location 3 Ariz
Thanks Paul.

 

[hilfy]

If I understand you correctly, in the report header you want to display a list of the locations that are included in the report, right?

To do this, you'll need to use a subreport. The subreport will have the same tables, links between them, and record selection criteria as your main report. If you're using parameters to filter your data, select the parameters from the main report as "subreport links" to you subreport - that way they'll get set automatically from the main report. Group the subreport on the Location field, put the location in the group header, and suppress the details and group footer sections.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[espltd]

Hi thanks for the response. I ended up using a subreport as you stated above. I just used the same dataset as I have on the main report and created a group on the locations and suppressed everything else on the subreport.