Record Selection in Crystal Report 2008

50 pts.
Tags:
Crystal Reports
Crystal Reports 2008
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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' ?
    69,510 pointsBadges:
    report
  • OperPar
    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";
    50 pointsBadges:
    report
  • carlosdl
    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.
    69,510 pointsBadges:
    report
  • OperPar
    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
    50 pointsBadges:
    report
  • carlosdl
    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 ?
    69,510 pointsBadges:
    report
  • OperPar
    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
    50 pointsBadges:
    report
  • carlosdl
    "...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.
    69,510 pointsBadges:
    report
  • OperPar
    Carlos, So what are my option to fix this problem?
    50 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following