Solved

Grouping not consistent between computers in Crystal Reports 2008

Posted on 2011-03-08
13
322 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:SeyerIT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
  • 2
  • +1
13 Comments
 
LVL 23

Expert Comment

by:Ido Millet
ID: 35070885
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.
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 35073889
Grouping is being done through the Group Expert.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35074980
Does the other user have  Crystal installed?

mlmcc
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 2

Author Comment

by:SeyerIT
ID: 35082352
Yes..
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35085348
I wonder if the defaults are set differently for date groups.

mlmcc
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 35085376
Would that be in the Crystal Reports program or the viewer on there computer?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35085810
In the Crystal program under FILE --> OPTIONS or REPORT OPTIONS

mlmcc
0
 
LVL 35

Expert Comment

by:James0628
ID: 35106536
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
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 35109435
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?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35110307
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
0
 
LVL 2

Accepted Solution

by:
SeyerIT earned 0 total points
ID: 35110453
Ok guys, we had a huge development about 15 minutes ago..  I can't explain exactly why this caused a problem but know that it did fix it. Even though the Crystal Reports software was installed using the same disc information on both of our computers, we ended up with different versions, etc. Apparently the ERP software we are using somehow interfered with my installation and installed a different version of the software than what ended up on the other users computer. Basically my computer ended up with;
Crystal Reports 2008 & Crystal Reports XI R2 .Net 3.0 Runtime (03_05_2008).

The versions that showed up on the other computer are;
Crystal Reports 2008 SP3 & Crystal Reports 2008 Runtime SP3.

The two different versions of the software were interpretting the data differently somehow. We went to the designer on the second computer that was displaying by date rather than month and although the grouping was there, it would't work until we removed the grouping and reapplyed it on that version of the designer. We then redeployed our report and pulled it back in on the first computer, which was originally recognizing the month group format and it still displayed correctly.

Again, I am not exactly sure the cause of this other than it seems the two different softwares were interpretting the grouping formats differently. mlmcc, you may still be right that the regional settings were just different. As we were getting ready to check that, we discovered the difference in the software versions and just dug into that. Currently the problem is resolved and we are going to get both computers on the same versions for future reports.
0
 
LVL 35

Expert Comment

by:James0628
ID: 35115002
That does sound strange, but at least you got it working.

 James
0
 
LVL 2

Author Closing Comment

by:SeyerIT
ID: 35145538
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.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question