LostAngel
Jul 20th, 2005, 10:33 AM
Hello, I have Crystal Reports 8, and am having a problem with grouping. I use the following connectionstring to connect to the MySQL database:
Provider=MSDASQL; DRIVER={MySQL ODBC 3.51 Driver}; SERVER=IP_Address; DATABASE=Database_Name; UID = User_Name; PASSWORD=PassWord; OPTION=3
I select the tbl I want in the report, Add the fields I want, but when I goto the Group Tab...it only displays ID as the available fields. I want to group by Employee Name, but its not listed...even though its a field in the table. Why is this?
Provider=MSDASQL; DRIVER={MySQL ODBC 3.51 Driver}; SERVER=IP_Address; DATABASE=Database_Name; UID = User_Name; PASSWORD=PassWord; OPTION=3
I select the tbl I want in the report, Add the fields I want, but when I goto the Group Tab...it only displays ID as the available fields. I want to group by Employee Name, but its not listed...even though its a field in the table. Why is this?