Reporting on specific details

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a general report for "Client Awards". However I just want to report on
a certain company. I tried the following within the detail portion of the
report and an expression builder and I cannot for the life of me seem to get
this to work so all I get is a certain companies records. I am still getting
the entire report.

[chrCompanyName] = "Allscripts Healthcare Solutions"

PLEASE HELP!

Thanks!
 
You need to either apply a filter to your report, or change the criteria in
the query upon which your report is built.
 
I have a general report for "Client Awards". However I just want to
report on a certain company. I tried the following within the detail
portion of the report and an expression builder and I cannot for the
life of me seem to get this to work so all I get is a certain
companies records. I am still getting the entire report.

[chrCompanyName] = "Allscripts Healthcare Solutions"

PLEASE HELP!

Thanks!
Click to expand...

Put the following criterium in your query at the field "[chrCompanyName]":

Like "*" & [For which company?] & "*"

When opening the report, a box will pop-up asking for the name of the
company. The way the criterium is defined, part of the name will suffice.
 
Back
Top