Grouping not consistent between computers in Crystal Reports 2008
I have created a Crystal Report that is grouped by Months. When I run it through the application to the viewer, it displays exactly how I created it, by months. However, when one of the other users on a different computer tries to run the report through our application to the viewer, their version is sorted by day. Is their a setting that just needs to be adjusted on their viewer? Or is this something I need to change on the designer before deploying the report?
Ido Millet
Are you grouping on a formula? Show the expression. Perhaps the regional settings for date are different and your formula doesn't take that into account.
ASKER
Grouping is being done through the Group Expert.
Does the other user have Crystal installed?
mlmcc
mlmcc
ASKER
Yes..
I wonder if the defaults are set differently for date groups.
mlmcc
mlmcc
ASKER
Would that be in the Crystal Reports program or the viewer on there computer?
In the Crystal program under FILE --> OPTIONS or REPORT OPTIONS
mlmcc
mlmcc
Going back to Ido's question, you said that you're using the Group Expert, but what are you actually grouping on? A date/datetime field in a table, or some other kind of field, or a derived value in a view or stored procedure, or a formula in CR?
If it's a date/datetime field in a table, then I don't see how the grouping could be different on different computers, since the type of grouping (day, week, etc.) is stored in the report.
You said that the report is grouped by month, but then for the other user you said that "their version is sorted by day". I assume that you meant "grouped", not "sorted", but I wanted to make sure.
I don't suppose that you have another version of the report that's grouped by day (or a parameter that controls the grouping), and the other user may just be getting the other report (or a different parameter value)?
James
If it's a date/datetime field in a table, then I don't see how the grouping could be different on different computers, since the type of grouping (day, week, etc.) is stored in the report.
You said that the report is grouped by month, but then for the other user you said that "their version is sorted by day". I assume that you meant "grouped", not "sorted", but I wanted to make sure.
I don't suppose that you have another version of the report that's grouped by day (or a parameter that controls the grouping), and the other user may just be getting the other report (or a different parameter value)?
James
ASKER
James,
The value is coming from a table and it is a date. mm/dd/yyyy. I went through the group expert and set that field to be grouped into months. And on his screen it is grouped by day, not sorted.. My apologies.
There is definitely only one version of the report. Their aren't any other parameters that control grouping within the report.. He has told me that he has other similar reports on his computer that when he tries to view them don't group the same way the report is created. I believe it is the exact same scenario (report is created to be grouped by month, but will display as grouped by day for him)
mlmcc,
I have not looked at his settings in report options yet.. Sorry I have been out of town since Tuesday. I will try and take a look at that today. I will compare how the report settings are and just make sure his match. This should eliminate that as a possible suspect once I've verified the settings match?
The value is coming from a table and it is a date. mm/dd/yyyy. I went through the group expert and set that field to be grouped into months. And on his screen it is grouped by day, not sorted.. My apologies.
There is definitely only one version of the report. Their aren't any other parameters that control grouping within the report.. He has told me that he has other similar reports on his computer that when he tries to view them don't group the same way the report is created. I believe it is the exact same scenario (report is created to be grouped by month, but will display as grouped by day for him)
mlmcc,
I have not looked at his settings in report options yet.. Sorry I have been out of town since Tuesday. I will try and take a look at that today. I will compare how the report settings are and just make sure his match. This should eliminate that as a possible suspect once I've verified the settings match?
ANother thing to check, the setting for date time in the regional setting. If your is mm/dd/yyyy and his is dd/mm/yyyy then it might change the grouping as you are seeing.
mlmcc
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That does sound strange, but at least you got it working.
James
James
ASKER
Although I can't give you an explanation for this, I can tell you that if you have this problem to simply be sure you are running the same version software on each computer. That will solve the problem.