I'm having difficulty with a query for a ticket report. The report looks like a sheet of business cards with a dynamic ticket number in the corner. I have the layout working just fine and the report displays as it should with some fake test data. I need to dynamically run this report with parameters and can't figure out the query.
Table1 has 1 row in it with Field1 which holds the number of tickets which need to be printed. It also the rest of the info needed for the ticket: date, time, ticket name, etc. What I'd like the query to do is return the number of rows the field has in it. In a For Loop it would be pretty simple but I need to do it in SQL.
How can I take 1 row and return it to the report as 5 or 8 or 10 rows?
SessionId 1 would print 5 tickets, SessionId2 would print 15 tickets, etc...
View Complete Post