Thank you Swaroop. That works for my example. Unfortunately the actual data I must use is in a SQL database. I read the information on a table-less cross join, but I could not figure out how to make that work. I know very little about writing SQL. If, in the case of the example, this table of fruit for Billy and Johnny were in a SQL database, how would I go about accomplishing the same goal? Thoughts? Thanks again!
1 of 1 people found this helpful
Once you select your database on the DataSource tab, I think you'll have the option under Table for "New Custom SQL".
I think then you should be able to use the method described in Section 1 on this link.