Print Page | Close Window

Sorting

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13494
Printed Date: 05 May 2024 at 1:04am


Topic: Sorting
Posted By: KevV
Subject: Sorting
Date Posted: 14 Jun 2011 at 8:28am
I have a report that I am sorting by a group and it works fine but when I add a second sort by a time field that is stored as a string value and run the report it comes back as a blank report.
 
Thanks
KevV 


Replies:
Posted By: DBlank
Date Posted: 14 Jun 2011 at 8:30am
likely this is a join issue
my guess is that the time field is the only field you are using from a table. When you added it to the report it enforced the join and returned zero records

Posted By: KevV
Date Posted: 14 Jun 2011 at 12:00pm
I kind of wondered about that but I was confused because I am using a field from that table in a formula in the report. I fiugred it would not work if I used any of those fields from the second table.
 
Thanks
KevV 

Posted By: DBlank
Date Posted: 15 Jun 2011 at 3:40am
this does put a bit of a question mark on if the issue is a join enforcement.
you can test it out by removing the sort so you get all of your values back, go into the DB expert
select the join and then select the enforce option that is matching to your join type. did your data disappear again?

Posted By: KevV
Date Posted: 15 Jun 2011 at 7:54am

I tried all the of the enforces and the report worked on all of them. I closed the report and ran it again and it worked. So I am not sure what was happening. Thanks for the help.

 
KevV


Print Page | Close Window