| Author |
Message |
dan231
Newbie
Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
|
   Topic: Data not showing
Posted: 08 Nov 2019 at 9:17am |
|
I have a report that groups members. On the left on the CR program in preview, shows group drop downs and my member is listed here, but is not listed in the actual report data.
I've gone s far as removed each of the select expert filters and I still can't get the data to show.
I am not sure what else I should be checking for in order to see the data.
EDIT - when I add a filter to only show this member, the footer states 2 records, but the screen is blank
Edited by dan231 - 08 Nov 2019 at 9:25am
|
|
Thanks,
Dan
|
 IP Logged |
|
|
lockwelle
Moderator
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
|
Posted: 08 Nov 2019 at 10:45am |
|
How do you get the data? Do you use a stored procedure? if so I would run that and inspect the values. If you don't, I would use the Show Sql on the Database tab and run that. It might provide you some insight as to what is going on.
Without knowing anything about your data, this is where I would start.
HTH
|
|
IP Logged |
|
dan231
Newbie
Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
|
Posted: 08 Nov 2019 at 11:08am |
|
Its a DB2 database. I'm no SQL wiz, so that's not overly helpful to me.
What should I be looking for?
|
|
Thanks,
Dan
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 11 Nov 2019 at 2:54am |
|
Do you have any suppression criteria going on here?
|
|
IP Logged |
|
dan231
Newbie
Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
|
Posted: 12 Nov 2019 at 2:55am |
|
I might. How do I check for that? This isn't a report I created.
|
|
Thanks,
Dan
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 12 Nov 2019 at 3:34am |
|
it could be on any field but likely it would be in the section expert. open the section expert and select each section (likely details) and look at the suppression option to be checked or for the x-2 button to be red. if it is red it has a criteria. so click on the x-2 to see the suppression criteria.
Edited by DBlank - 12 Nov 2019 at 3:35am
|
|
IP Logged |
|
dan231
Newbie
Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
|
Posted: 20 Nov 2019 at 9:35am |
|
Finally found it! There was a formula that pointed to a field that didn't really pertain to the data at hand. Once removed, all the "missing" data was shown.
|
|
Thanks,
Dan
|
|
IP Logged |
|
|
|
