Thanks for the reply.
Not to complicate matters further, but if the counter will tend to vary depending on the date range selected by the user (in our earlier example, let's assume the counter for the Miami rows would be 24 through 27 while the counter for the Seattle rows would be 1 through 3)...
Thanks for the reply. Unfortunately, I don't have access to the data at the moment, so I'll try to provide a comparable (if much smaller) example.
Instead of a report that looks like this:
City State Order # Hobby
Miami FL 42 Golf
Miami FL 65...
Hi,
I have a result set that often contains identical data for each variable except one. Rather that return, for example, 10 rows of data where all the values are the same except for this field, I'm asked to dispay the unique variable across 10 columns (hope that made sense.) So, instead of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.