Reporting without using portal

[jjsaldana]

I am working for a PBS station and currently I am working on putting our pledge activities in a database. We have both radio and TV pledges. What we do in radio pledge is that we solicit donor for challenge grant and bonus gift (usually are in-kind) to offer our listeners. We do offer premium, but it’s only a handful of program over the weekend. The structure I set up works really well for radio pledge. I basically set up a solicited item table and scheduling table to track one solicit item can be scheduled in different pledge break.

I am trying to look ahead for our TV pledge that should be happening in a few months. TV pledge is program driven. We offer premium for each pledge break. The premium offer can get complicate. We offer different combination of premium package depending on the pledge level. I come out with an idea the other day to track TV pledge form program. I created a program table, a scheduling table and a program_premium table (a table between solicited item and program). I join program table to program_premium table, then join program to scheduling table. The data entry works great. All you need to do is add a program record and add in the pledge breaks in a scheduling portal, then select the premium offer in the program_premium portal.

The problem is when I try to run a report to see all our pledge break and what we offer in each pledge break for a specific date. I pull the records from scheduling table. I have one summary parts group by program and the body of the report is the break and time then premiums that are offered. The problem is that the only way I can show all the premiums is to use a portal to show the multiple items that are offered to a specific program. If I don’t use a portal, I only get the first record and I hate to use portal in my reporting. It is hard to control to mike the report looks nice. I was just wondering if there is any other object that can be used to bring out the many records in the program_premium table. I know the problem is that the scheduling table does not link to the program_premium table, but if I want the program_premium link to break, there are just too many redundant data entries. Thank you for your help.