Create a Single line report (1 Viewer)

[Elvis]

Hi Guys,

Been struggling to find a solution to this issue. Here is what I want to do. I would like to create a report that prints the following: ProcedureID, Version, name of procedure. Because I have multiple Versions associated with the procedure I only want the latest Version to be printed. What happens currently is that I group on the procedure Id but because there are mutliple versions I then get multiple lines in the report. See below what I get:

ProcedureID Version Name
ID1 1.0 Some old Name
1.1 Some old Name
1.2 Some old Name

What I would like is:

ID1 1.2 (as this is the last version) Some old name
ID2 4.0 Another Proc

What is the best way to acheive this.

Thanks in advance for any help you can provide.

 

[Brianwarnock]

The queries on which the report is based need to first group on procedure and max on version then link back to the table and pull the other information with your report based on the 2nd query.
It probably can be done using a subquery also.

Brian

 

[Elvis]

Brian, thank you for your response.

That got me on the right track, works a treat now.

 

[Brianwarnock]

Happy to help

Brian