Home > IT Answers > Business Intelligence > Record Selection in Crystal Report 2008
OperPar
50 pts.
 Record Selection in Crystal Report 2008
Crystal Reports, Crystal Reports 2008, Crystal Reports 2008 controls, Record Selection
I have a Crystal report 2008 that selects records from dynamic prompt based on Client field with status "Approved". When i select records that i know have a staus of "Approved" I see all of the records, but if I select records from dynamic prompt that dont have a status "Approved"  some other status like "Open" or "Closed" it only shows me one record

Software/Hardware used:
ASKED: February 21, 2011  7:32 PM
UPDATED: February 23, 2011  12:51 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Are you doing this with a record selection formula ? Can you post it ?

Can you post your report’s base query as well ?

Also, what do you mean by ‘from dynamic prompt’ ?

carlosdl
 63,580 pts.
 

Thanks Carlosdl

Here is my Selection formula and my bad not prompt I meant to say parameter :-)

{?Clients Selected}={BILLING.CID} And {HELPDESK.STATUS} = “Approved”;

OperPar
 50 pts.
 

I must be missing something…

This part:

{HELPDESK.STATUS} = “Approved”;

Tells CR to only select records whose status is “Approved”. So, no record with a different status should be included.

carlosdl
 63,580 pts.
 

Hello Carlos.

{HELPDESK.STATUS} = “Approved”; is my field where it is either Approved or Open or Closed etc. So my selection of records is with status Approved. Should you need more info please let me know.

Vlad

OperPar
 50 pts.
 

Sorry, I’m not sure I’m following you…

So, “Approved” is not really hard coded in the selection formula ?
Can we take a look at the actual formula, as you have it in CR ?

carlosdl
 63,580 pts.
 

Carlos,

It is hard coded in Selection Record. Here is my Selection record code: {BILLING.CID}={?Clients Selected} And {HELPDESK.STATUS} = “Approved”; Where BILLING.CID is a table with Clients ID. So when I am picking a Client and status is Approved it should display those Clients and that works fine. But if status is not approved for any clients then I display message “No Records” and all of the clients should appear, but it’s only showing first Client

OperPar
 50 pts.
 

“…then I display message “No Records…”

How do you do that ?

…”all of the clients should appear”

Your record selection formula is filtering out all records with status different from “Approved”. Those records are not being fetched from the database.

carlosdl
 63,580 pts.
 

Carlos,

So what are my option to fix this problem?

OperPar
 50 pts.