Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Report only pulls the record used in Show SQL Post Reply Post New Topic
Author Message
Dagmax
Newbie
Newbie
Avatar

Joined: 27 Sep 2007
Online Status: Offline
Posts: 1
Quote Dagmax Replybullet Topic: Report only pulls the record used in Show SQL
    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.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP 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.070 seconds.