Age Old Mystery: First Time Buyers by Show and FTB at Venue

Absolutely never attended whatsoever? Does it need to be broken out by show or simply and list? Do you have multiple venues? I could slap something together for you, but those are things that need to be cleared up first. Travis

Hi Travis! You are spectacular! Yes. The AD wants to know if this is someone's first time at the PAC, not just at a show or by season. We have two venues. It's a challenge given we do over 300 performances a season and they are different every single season. There is no rhyme or reason to the programming whatsoever. All of our subscriptions are CYO/DYO, etc. Having "said" that. If it's a simpler matter to segregate by show I'm all for it. Anything that gets us closer to the end result is great!! Pulling any kind of cohesive data here has been a great challenge! I would love to learn how you see it working!!

Here is how I would do it. Create a procedure example below. Create report in SSRS that is grouped by perf_no and stick each one in its own tab for easy viewing or uploads. With that said I also added a parameter to create a list for each distinct perf with a list description with New Patron + perf code, example :" New Patron: R0125D". If you need help with the ssrs let me know but it is pretty straight forward. By doing it this way you can use it as a scheduled report receive the excel spread sheet via email and even have the data in list broken out by perfs so you can spend your time with more important matters. I created a debug variable to show the bits and some variables before putting it live. You could leave it or simply remove appropriate if statements. Very important to set to false once live, make sure your history table name is correct and TEST,TEST,TEST within your TEST db before using and going live. Please keep in mind that I am not 100% in the loop obliviously, so you can add to the output and create more parameters if needed. I only gave you a quick example on my approach. If you would like help implementing this email me offline. Travis update, emailed it to you since it was gibberish

Here is how I would do it. Create a procedure example below. Create report in SSRS that is grouped by perf_no and stick each one in its own tab for easy viewing or uploads. With that said I also added a parameter to create a list for each distinct perf with a list description with New Patron + perf code, example :" New Patron: R0125D". If you need help with the ssrs let me know but it is pretty straight forward. By doing it this way you can use it as a scheduled report receive the excel spread sheet via email and even have the data in list broken out by perfs so you can spend your time with more important matters. I created a debug variable to show the bits and some variables before putting it live. You could leave it or simply remove appropriate if statements. Very important to set to false once live, make sure your history table name is correct and TEST,TEST,TEST within your TEST db before using and going live. Please keep in mind that I am not 100% in the loop obliviously, so you can add to the output and create more parameters if needed. I only gave you a quick example on my approach. If you would like help implementing this email me offline. Travis update, emailed it to you since it was gibberish

I put my example in my files on the site. Feel free to grab it if anyone else would like to see it. file name = Example new patron finder.txt. It is not in my example, but i did just think of something else to add to this in the while loop. After you count the contents of the new list wrap the list creating bit in a new if statement and test to the count if @count = 0 or @count is null skip and move on to the next one. This will make sure you are not creating list with 0 contents. Update: I forgot sli status. I updated it in my files.