Report help

Alec Drummond $organization over 8 years ago

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.

Heath Wilder $organization over 8 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Robert Martin $organization over 8 years ago

The reports I write always have descriptions (it is standard for us). If you can elaborate what your required fields are, I will see if we have anything similar and will be happy to share.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel