Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: Data not showing Post Reply Post New Topic
Author Message
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet 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 IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4285
Quote lockwelle Replybullet 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 IP Logged
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet 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 IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9012
Quote DBlank Replybullet Posted: 11 Nov 2019 at 2:54am
Do you have any suppression criteria going on here?
IP IP Logged
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet 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 IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9012
Quote DBlank Replybullet 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 IP Logged
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet 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 IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.059 seconds.