Print Page | Close Window

Report only pulls the record used in Show SQL

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1400
Printed Date: 10 Apr 2025 at 7:30pm


Topic: Report only pulls the record used in Show SQL
Posted By: Dagmax
Subject: Report only pulls the record used in Show SQL
Date Posted: 27 Sep 2007 at 4:22pm
I created a report and in order to test it I used a patient id that I new would test the conditions of the report.  Now when I deploy the report to the test environment it will only show data if I choose that particular patient I used when creating the report.  How do I modify the report to accept the patient id that is selected when running the report?  I am new to Crystal Reports.


Replies:
Posted By: hilfy
Date Posted: 28 Sep 2007 at 2:15pm
In the Select Expert, change the formula so that it looks for {patient ID field} = {?patient ID parameter}.  I suspect you have the specific ID you were testing with hard coded in there.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window