Skip to Content
0
Former Member
May 30, 2009 at 07:10 PM

Pull name out of parameter field to put it into an email address

30 Views

I am working with a report that is a little different. I am trying to put the inspectors email address on the report, but I cannot link any other tables and the only place the inspectors name is located, it in the "?ReportTitleu201D The name will always be in the same spot and is separated by a ,. When I click the show report in our RMS software, it opens a report with the title that says "Semi-Annual Inspection Assigned to KNUDSEN, Timothy on 5-30-2009u201D What I want to do is break it down with an end result of Last name first inicial then the @emailaddress. The report title does not always start with the same words. Sometimes it is Reinspection, Occupancy Inspection, etc... The Inspectors name is always after the Assigned to.