Crystal Reports Record Selection Problem

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Record Selection Problem

Author	Message
Vlad Newbie Joined: 21 Feb 2011 Online Status: Offline Posts: 3	Topic: Record Selection Problem Posted: 21 Feb 2011 at 7:35am
	I have a report that selecting records based on field with status "Approved". Now i should see other records that are not falling under status "Approved" if I pick them from dynamic prompt, about nine of them but for some reason it shows me only one record. My selection formula is: {BILLING.CID}={?Clients Selected} And {HELPDESK.STATUS} = "Approved";
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 21 Feb 2011 at 7:50am
	If you want to see the record with either value, change the "And" to "Or". -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Vlad Newbie Joined: 21 Feb 2011 Online Status: Offline Posts: 3	Posted: 21 Feb 2011 at 8:21am
	Hello Hilfy.Thanks for quick reply. No, i dont need OR i need that selection. Here is scenario. I have a dynamic PROMPT where user selects Client, if he selected a client and in status field is "Approved" show all of those clients and it is doing that. If a status is not "Approved" anything else show those clients. I have 9 of those clients but it only shows me one.
	IP Logged

hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3701	Posted: 21 Feb 2011 at 10:58am
	So are you trying to show all clients in the parameter whether or not the data is marked approved? Or are you trying to show all records for the selectect clients who have an approved record? -Dell
	Proviti, Data & Analytics Practice www.protiviti.com/US-en/data-management-advanced-analytics
	IP Logged

Vlad Newbie Joined: 21 Feb 2011 Online Status: Offline Posts: 3	Posted: 22 Feb 2011 at 2:42am
	Hilfy, Here what I want to do. If a user chose any Client and status in those records "Approved" then show those records, and it's doing it. If records dont have status "Approved" then message and show all of the records with that criteria. I am displaying message but it is only displaying first record not all of them. Make sence? Vlad
	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.032 seconds.