Print Page | Close Window

record select expert showing all records

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17423
Printed Date: 03 May 2024 at 3:16pm


Topic: record select expert showing all records
Posted By: ridhwaans
Subject: record select expert showing all records
Date Posted: 27 Aug 2012 at 8:45am
I recently upgraded my crystal reports from crystal reports for visual studio 2005 to crystal reports XI release 2
Now, my select experts for the reports are not working anymore
for example, one of my reports, I pass a parameter as a discrete value from VB.net to crystal's record selection, the formula is below

{inventory.ID} = {?ID}

based on the ID record filter, crystal used to display a bunch of db fields information on one page (details section)
after the crystal report upgrade, this selection filter doesnt seem to work, and all the ID records are being shown (3000+ pages)

I've removed and readded the fields, and the select condition, but to no avail

Is this some sort of bug?


Replies:
Posted By: Sastry
Date Posted: 27 Aug 2012 at 6:47pm
Hi
 
--Check whether this parameter has changed to optional.
 
--Also crate a formula with your condition i.e. {inventory.ID} = {?id}   and place it on your detail and check whether it is showing 'true' or 'false'  if it shows true for all records then some thing is worong.
 
--Try to filter your records based on any other field and check the functinality.
 
 
 


-------------
Thanks,
Sastry

Posted By: mystere
Date Posted: 27 Dec 2012 at 1:25am
Hi ridhwaans,

Did you find the solution to the selection expert issue.
I am facing the same issue right now.

Thank you


Print Page | Close Window