I could have sworn there is a standard report that reports on number of comp seats and the comp reason....am I just imagining it or is there a report that will give me this information. I have a company manager who is asking for it and I'm not having any luck finding it.
Thanks for the help everyone!!!
I'm looking for help to see if I can add Price Type Reason to the Attendance by Performance report. Anyone have any thoughts? I can't seem to find a recent thread on price type reasons.
Thanks,
Susie
Broadway Sacramento
Price Type Reasons are in the TR_COMP_CODE table. You can join it from the T_SUB_LINEITEM table.
LEFT JOIN TR_COMP_CODE AS CC WITH (NOLOCK) ON CC.id = SLI.comp_code