Joined: 19 May 2011
Online Status: Offline
Posts: 106
Topic: Sorting 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.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
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
Joined: 19 May 2011
Online Status: Offline
Posts: 106
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.
Joined: 19 May 2011
Online Status: Offline
Posts: 106
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
