I have 2 tables, one with an persons name and another table with one to many designations they have with the year the designation was obtained. The output is coming out as follows:
Smith, John (AAA 1999)
Smith, John (BBB 2000)
I need the format to be as follows:
Smith, John (AAA 1999, BBB...
I have a 1-m table relationship where an individual can have multiple designations. For instance, Joe Smith can be an ASA, FSA, MIID and DAS while Mary Jones is an ASA, FSA, and MPD. Each designation is part of a 1 to many relationship in a different table than the individuals name. I am trying...
I am having a problem with a "*N". being appended to table names when attaching to an AS400 DB2 database through ODBC. I can manually change the table names through the Set Location function in Crystal Reports, but I am trying to create a Crystal Dictionary and there is no function to...
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.