General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>One problem with this approach is if you add even one Contact type, you have to add a column to your main SELECT. Then you have to remember to add another Contact column in your report.
Unless you start off by selecting all the different distinct contact types and build the rest from there. If you want to get really fancy you can also find out the max number of repeating line info (like the person with 4 cell phones) in advance an work from that info. Then you will have overflows on some printers, so arguing to write out such a list into excel is the appropriate way - But in most projects there is not enough time to do everything in a more generic way<g>.
regards
thomas
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only