Joined: 19 May 2011
Online Status: Offline
Posts: 106
Posted: 20 Sep 2012 at 9:15am
I did suppress all but the group footer and got just the one line. On the tables they are only joined by the id and the only select statement I have is a date range.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 20 Sep 2012 at 9:22am
It still might be the combinataion of the join and the select statement.
you have to think it through or replicate the data set in sql and look at the data set int he raw there.
If you look in a table and the data is there but it is not in the data set for the report the most logical reason is your join and/or select statement has filtered it out.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 20 Sep 2012 at 10:41am
but is the 'raw' data in the data set as you expect it to be (which you can only see in the detail row).
Place the 'missing' raw fields in the details and see if it is in the data set.
You have to figure out if your formulas are wrong or the data set is wrong.
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
