Hi All,
I'm working with Crystal Reports 10, Developer Edition on a machine with Windows 2000. The database I'm using is MySQL Server. Here's my situation...
The Data
I have a database with two tables: user and program. The user table simply contains a list of users. The program table contains a list of programs created by each user. Users are expected to complete a program every day and thus, the program table contains a date field specifying when the program was created.
The Report
I have a report that prints yes or no for every day of the month for each user, telling whether or not the user completed the expected program in each day. Thus, each page of my report shows a given month, a list of users, and a whole bunch of boxes (more precisely, 1 for each day of the month). The boxes show an 'x' if the there is a program in the database for that user in that day. Make sense? (btw, the boxes are not really boxes; they're just formulas with borders)
The Problem
Some users have no programs at all for certain months, and therefore, they don't appear in the report for those months. That's exactly the problem. I need the entire list of users to print for each month, whether or not programs exist in the database for them. Currently, I'm grouping the records by month (group 1) and by user (group 2). How can I force the entire list of users to print for each month?
I'm aware that it makes sense for the users not to show up if they don't exist in a given month. That's obvious. I'm looking for some trick or workaround that's going to force the records to show up. Any ideas?
Thanks!
JC
_________________________________________________
To get the best response to a question, read faq222-2244.
I'm working with Crystal Reports 10, Developer Edition on a machine with Windows 2000. The database I'm using is MySQL Server. Here's my situation...
The Data
I have a database with two tables: user and program. The user table simply contains a list of users. The program table contains a list of programs created by each user. Users are expected to complete a program every day and thus, the program table contains a date field specifying when the program was created.
The Report
I have a report that prints yes or no for every day of the month for each user, telling whether or not the user completed the expected program in each day. Thus, each page of my report shows a given month, a list of users, and a whole bunch of boxes (more precisely, 1 for each day of the month). The boxes show an 'x' if the there is a program in the database for that user in that day. Make sense? (btw, the boxes are not really boxes; they're just formulas with borders)
The Problem
Some users have no programs at all for certain months, and therefore, they don't appear in the report for those months. That's exactly the problem. I need the entire list of users to print for each month, whether or not programs exist in the database for them. Currently, I'm grouping the records by month (group 1) and by user (group 2). How can I force the entire list of users to print for each month?
I'm aware that it makes sense for the users not to show up if they don't exist in a given month. That's obvious. I'm looking for some trick or workaround that's going to force the records to show up. Any ideas?
Thanks!
JC
_________________________________________________
To get the best response to a question, read faq222-2244.