• Replies 2 replies
  • Subscribers 961 subscribers
  • Views 114 views
  • Users 0 members are here
Related

Report help

Alec Drummond
$organization
Hi I am currently running a scheduled report to share with our management team. The report is a "Ticket Sales by Period", which contains all the info required, however, It identifies each performance from its "Perf Code" which is proving a bit problematic for an at-a-glance look, i.e. we have a performance code of 069HS0829 for a performance of High Society on 29th Aug and as we operate a rep season with 5 other productions the perf codes are all look very similar when listed in the report e.g. for another show called Mary Rose a code is 068MR0828. Is there a way - or another report - that would list the performance description rather than the performance code.
Parents
  • $organization

    Hi Alec,

    My thoughts would be to create a modified report that returns description. It's pretty simple as far as SSRS is concerned BUT getting to report writing stage does require some SQL skills and is a bit of a learning curve.  If you have someone with that skill set its not a big job.

Reply
  • $organization

    Hi Alec,

    My thoughts would be to create a modified report that returns description. It's pretty simple as far as SSRS is concerned BUT getting to report writing stage does require some SQL skills and is a bit of a learning curve.  If you have someone with that skill set its not a big job.

Children
No Data