I’ve inherited responsibility over Crystal Reports (For Enterprise) recently and am running into an issue. I’ve got a report a user created connected to a universe, one of the result objects is not returning a new value that was added to the table.
If I right click the result object and select “Browse Data” it shows 4 values, where it should be showing 5. If I go to the query filter and use the data preview pane, I can see the 5 values there, so at the query level the data IS there…also if I “View Script” and copy and paste the SQL into SQL Server I can also view the data and see all 5 values are showing up there as well.
Is there some sort of filter that could be applied to a result object that I’m not aware of? I’m not clicking the object in the report, I’m right clicking the result object from the Data Explorer pane and select “Browse Data”, AFAIK it should be showing all values without any filters.
Let me know if there is any information I could provide, any help is greatly appreciated!
Crystal Reports crashed and auto saved the report, the auto save version of this report doesn’t have the issue and correctly displays the data when clicking “Browse Data”.
This leads me to believe it’s some sort of bug, but just putting this here in case someone else ever encounters it.
This suggests to me that someone is supressing those records within the report itself. Have you checked record suppression in section expert?
Also have you definitely clicked the field in the report? Maybe someone has created a formula called the same thing, re-drag the field into the report and see what happens.
Not sure about this but have a look at the group selection… not sure when this is used to filter out results… i.e. at the SQL layer or later.
Did you find the problem?
I am facing a similar issue now. When I press “browse field” in Data Explorer, data is there. When I put the filed in the report, load it, nothing is displayed and “browse field” is also empty.
Any ideas?
Thank you
(BOB member since 2012-03-06)